반응형
현 상태 확인
[root@datarac1 bin]# id
uid=0(root) gid=0(root) groups=0(root) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[root@datarac1 bin]# pwd
/u01/app/19.0.0/grid/bin
[root@datarac1 bin]# ./ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 4
Total space (kbytes) : 491684
Used space (kbytes) : 84516
Available space (kbytes) : 407168
ID : 1930868031
Device/File Name : +OCRVOTE
Device/File integrity check succeeded
Device/File not configured
Device/File not configured
Device/File not configured
Device/File not configured
Cluster registry integrity check succeeded
Logical corruption check succeeded
[root@datarac1 bin]#
[root@datarac1 bin]# ./ocrcheck -details
Status of Oracle Cluster Registry is as follows :
Version : 4
Total space (kbytes) : 491684
Used space (kbytes) : 84516
Available space (kbytes) : 407168
ID : 1930868031
Device/File Name : +OCRVOTE/datarac/OCRFILE/registry.255.1137239017
Device/File integrity check succeeded
Device/File not configured
Device/File not configured
Device/File not configured
Device/File not configured
Cluster registry integrity check succeeded
Logical corruption check succeeded
[root@datarac1 bin]#
[root@datarac1 bin]# ./crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 8e99de0aed5d4f45bff8818da83cea68 (/dev/oracleasm/asm-disk01) [OCRVOTE]
2. ONLINE 1c4f3d989f684fbebf542f9bfb363318 (/dev/oracleasm/asm-disk02) [OCRVOTE]
3. ONLINE 124978c179a24f20bf37f7db95407eed (/dev/oracleasm/asm-disk03) [OCRVOTE]
Located 3 voting disk(s).
[root@datarac1 bin]#
--OCR/VOTE가 사용하는 ASM Disk 확인
[oracle@datarac1 ~]$ id
uid=54321(oracle) gid=54322(dba) groups=54322(dba) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[oracle@datarac1 ~]$ env | grep SID
ORACLE_SID=+ASM1
[oracle@datarac1 ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 19.0.0.0.0 - Production on Tue May 23 09:21:38 2023
Version 19.19.0.0.0
Copyright (c) 1982, 2022, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.19.0.0.0
SQL> set linesize 150
SQL> col name for a20
SQL> col state for a10
SQL> col path for a40
SQL> select name, group_number "g_no", disk_number "d_no", state, redundancy, path from v$asm_disk order by 6;
NAME g_no d_no STATE REDUNDA PATH
-------------------- ---------- ---------- ---------- ------- ----------------------------------------
OCRVOTE_0000 2 0 NORMAL UNKNOWN /dev/oracleasm/asm-disk01
OCRVOTE_0001 2 1 NORMAL UNKNOWN /dev/oracleasm/asm-disk02
OCRVOTE_0002 2 2 NORMAL UNKNOWN /dev/oracleasm/asm-disk03
DATA1_0000 1 0 NORMAL UNKNOWN /dev/oracleasm/asm-disk04
DATA1_0001 1 1 NORMAL UNKNOWN /dev/oracleasm/asm-disk05
DATA1_0002 1 2 NORMAL UNKNOWN /dev/oracleasm/asm-disk06
0 3 NORMAL UNKNOWN /dev/oracleasm/asm-disk07
0 1 NORMAL UNKNOWN /dev/oracleasm/asm-disk08
0 0 NORMAL UNKNOWN /dev/oracleasm/asm-disk09
0 2 NORMAL UNKNOWN /dev/oracleasm/asm-disk10
10 rows selected.
SQL>OCR/VOTE용 ASM Disk Group에 ASM DISK 추가 삭제
--OCR/VOTE용 ASM Disk Group에 ASM DISK 추가
[oracle@datarac1 ~]$ id
uid=54321(oracle) gid=54322(dba) groups=54322(dba) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[oracle@datarac1 ~]$ env | grep SID
ORACLE_SID=+ASM1
[oracle@datarac1 ~]$
[oracle@datarac1 ~]$
[oracle@datarac1 ~]$
[oracle@datarac1 ~]$ sqlplus "/as sysasm"
SQL*Plus: Release 19.0.0.0.0 - Production on Tue May 23 10:39:17 2023
Version 19.19.0.0.0
Copyright (c) 1982, 2022, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.19.0.0.0
SQL> select * from v$asm_operation;
no rows selected
SQL> ALTER DISKGROUP OCRVOTE ADD DISK '/dev/oracleasm/asm-disk07' REBALANCE POWER 5;
Diskgroup altered.
SQL> select * from v$asm_operation;
GROUP_NUMBER OPERA PASS STAT POWER ACTUAL SOFAR EST_WORK
------------ ----- --------- ---- ---------- ---------- ---------- ----------
EST_RATE EST_MINUTES ERROR_CODE CON_ID
---------- ----------- -------------------------------------------- ----------
2 REBAL COMPACT WAIT 5 5 0 0
0 0 0
2 REBAL REBALANCE RUN 5 5 62 62
4241 0 0
2 REBAL REBUILD DONE 5 5 0 0
0 0 0
GROUP_NUMBER OPERA PASS STAT POWER ACTUAL SOFAR EST_WORK
------------ ----- --------- ---- ---------- ---------- ---------- ----------
EST_RATE EST_MINUTES ERROR_CODE CON_ID
---------- ----------- -------------------------------------------- ----------
2 REBAL RESYNC DONE 5 5 0 0
0 0 0
SQL> select * from v$asm_operation;
no rows selected
SQL>
SQL> set linesize 150
SQL> col name for a20
SQL> col state for a10
SQL> col path for a40
SQL> select name, group_number "g_no", disk_number "d_no", state, redundancy, path from v$asm_disk order by 6;
NAME g_no d_no STATE REDUNDA PATH
-------------------- ---------- ---------- ---------- ------- ----------------------------------------
OCRVOTE_0000 2 0 NORMAL UNKNOWN /dev/oracleasm/asm-disk01
OCRVOTE_0001 2 1 NORMAL UNKNOWN /dev/oracleasm/asm-disk02
OCRVOTE_0002 2 2 NORMAL UNKNOWN /dev/oracleasm/asm-disk03
DATA1_0000 1 0 NORMAL UNKNOWN /dev/oracleasm/asm-disk04
DATA1_0001 1 1 NORMAL UNKNOWN /dev/oracleasm/asm-disk05
DATA1_0002 1 2 NORMAL UNKNOWN /dev/oracleasm/asm-disk06
OCRVOTE_0003 2 3 NORMAL UNKNOWN /dev/oracleasm/asm-disk07
0 1 NORMAL UNKNOWN /dev/oracleasm/asm-disk08
0 0 NORMAL UNKNOWN /dev/oracleasm/asm-disk09
0 2 NORMAL UNKNOWN /dev/oracleasm/asm-disk10
10 rows selected.
SQL>exit
--OCR/VOTE 확인
[root@datarac1 bin]# id
uid=0(root) gid=0(root) groups=0(root) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[root@datarac1 bin]# pwd
/u01/app/19.0.0/grid/bin
[root@datarac1 bin]# ./ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 4
Total space (kbytes) : 491684
Used space (kbytes) : 84516
Available space (kbytes) : 407168
ID : 1930868031
Device/File Name : +OCRVOTE
Device/File integrity check succeeded
Device/File not configured
Device/File not configured
Device/File not configured
Device/File not configured
Cluster registry integrity check succeeded
Logical corruption check succeeded
[root@datarac1 bin]#
[root@datarac1 bin]#
[root@datarac1 bin]# ./ocrcheck -details
Status of Oracle Cluster Registry is as follows :
Version : 4
Total space (kbytes) : 491684
Used space (kbytes) : 84516
Available space (kbytes) : 407168
ID : 1930868031
Device/File Name : +OCRVOTE/datarac/OCRFILE/registry.255.1137239017
Device/File integrity check succeeded
Device/File not configured
Device/File not configured
Device/File not configured
Device/File not configured
Cluster registry integrity check succeeded
Logical corruption check succeeded
[root@datarac1 bin]# ./crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 8e99de0aed5d4f45bff8818da83cea68 (/dev/oracleasm/asm-disk01) [OCRVOTE]
2. ONLINE 1c4f3d989f684fbebf542f9bfb363318 (/dev/oracleasm/asm-disk02) [OCRVOTE]
3. ONLINE 124978c179a24f20bf37f7db95407eed (/dev/oracleasm/asm-disk03) [OCRVOTE]
Located 3 voting disk(s).
[root@datarac1 bin]#
--OCR/VOTE용 ASM Disk Group에 ASM DISK 삭제
[oracle@datarac1 ~]$ id
uid=54321(oracle) gid=54322(dba) groups=54322(dba) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[oracle@datarac1 ~]$ env | grep SID
ORACLE_SID=+ASM1
[oracle@datarac1 ~]$ sqlplus "/as sysasm"
SQL*Plus: Release 19.0.0.0.0 - Production on Tue May 23 10:46:20 2023
Version 19.19.0.0.0
Copyright (c) 1982, 2022, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.19.0.0.0
SQL> set linesize 150
SQL> col name for a20
SQL> col state for a10
SQL> col path for a40
SQL> select name, group_number "g_no", disk_number "d_no", state, redundancy, path from v$asm_disk order by 6;
NAME g_no d_no STATE REDUNDA PATH
-------------------- ---------- ---------- ---------- ------- ----------------------------------------
OCRVOTE_0000 2 0 NORMAL UNKNOWN /dev/oracleasm/asm-disk01
OCRVOTE_0001 2 1 NORMAL UNKNOWN /dev/oracleasm/asm-disk02
OCRVOTE_0002 2 2 NORMAL UNKNOWN /dev/oracleasm/asm-disk03
DATA1_0000 1 0 NORMAL UNKNOWN /dev/oracleasm/asm-disk04
DATA1_0001 1 1 NORMAL UNKNOWN /dev/oracleasm/asm-disk05
DATA1_0002 1 2 NORMAL UNKNOWN /dev/oracleasm/asm-disk06
OCRVOTE_0003 2 3 NORMAL UNKNOWN /dev/oracleasm/asm-disk07
0 1 NORMAL UNKNOWN /dev/oracleasm/asm-disk08
0 0 NORMAL UNKNOWN /dev/oracleasm/asm-disk09
0 2 NORMAL UNKNOWN /dev/oracleasm/asm-disk10
10 rows selected.
QL>
SQL> ALTER DISKGROUP OCRVOTE DROP DISK OCRVOTE_0000;
Diskgroup altered.
SQL> select * from v$asm_operation;
GROUP_NUMBER OPERA PASS STATE POWER ACTUAL SOFAR EST_WORK EST_RATE EST_MINUTES
------------ ----- --------- ---------- ---------- ---------- ---------- ---------- ---------- -----------
ERROR_CODE CON_ID
-------------------------------------------- ----------
2 REBAL COMPACT WAIT 1 1 0 0 0 0
0
2 REBAL REBALANCE RUN 1 1 53 94 2148 0
0
2 REBAL REBUILD DONE 1 1 0 0 0 0
0
GROUP_NUMBER OPERA PASS STATE POWER ACTUAL SOFAR EST_WORK EST_RATE EST_MINUTES
------------ ----- --------- ---------- ---------- ---------- ---------- ---------- ---------- -----------
ERROR_CODE CON_ID
-------------------------------------------- ----------
2 REBAL RESYNC DONE 1 1 0 0 0 0
0
SQL> select * from v$asm_operation;
no rows selected
SQL> select name, group_number "g_no", disk_number "d_no", state, redundancy, path from v$asm_disk order by 6;
NAME g_no d_no STATE REDUNDA PATH
-------------------- ---------- ---------- ---------- ------- ----------------------------------------
0 0 NORMAL UNKNOWN /dev/oracleasm/asm-disk01
OCRVOTE_0001 2 1 NORMAL UNKNOWN /dev/oracleasm/asm-disk02
OCRVOTE_0002 2 2 NORMAL UNKNOWN /dev/oracleasm/asm-disk03
DATA1_0000 1 0 NORMAL UNKNOWN /dev/oracleasm/asm-disk04
DATA1_0001 1 1 NORMAL UNKNOWN /dev/oracleasm/asm-disk05
DATA1_0002 1 2 NORMAL UNKNOWN /dev/oracleasm/asm-disk06
OCRVOTE_0003 2 3 NORMAL UNKNOWN /dev/oracleasm/asm-disk07
0 2 NORMAL UNKNOWN /dev/oracleasm/asm-disk08
0 1 NORMAL UNKNOWN /dev/oracleasm/asm-disk09
0 3 NORMAL UNKNOWN /dev/oracleasm/asm-disk10
10 rows selected.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.19.0.0.0
[oracle@datarac1 ~]$
--OCR/VOTE 확인
[root@datarac1 bin]# id
uid=0(root) gid=0(root) groups=0(root) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[root@datarac1 bin]# pwd
/u01/app/19.0.0/grid/bin
[root@datarac1 bin]# ./ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 4
Total space (kbytes) : 491684
Used space (kbytes) : 84516
Available space (kbytes) : 407168
ID : 1930868031
Device/File Name : +OCRVOTE
Device/File integrity check succeeded
Device/File not configured
Device/File not configured
Device/File not configured
Device/File not configured
Cluster registry integrity check succeeded
Logical corruption check succeeded
[root@datarac1 bin]# ./ocrcheck -details
Status of Oracle Cluster Registry is as follows :
Version : 4
Total space (kbytes) : 491684
Used space (kbytes) : 84516
Available space (kbytes) : 407168
ID : 1930868031
Device/File Name : +OCRVOTE/datarac/OCRFILE/registry.255.1137239017
Device/File integrity check succeeded
Device/File not configured
Device/File not configured
Device/File not configured
Device/File not configured
Cluster registry integrity check succeeded
Logical corruption check succeeded
[root@datarac1 bin]# ./crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 1c4f3d989f684fbebf542f9bfb363318 (/dev/oracleasm/asm-disk02) [OCRVOTE]
2. ONLINE 124978c179a24f20bf37f7db95407eed (/dev/oracleasm/asm-disk03) [OCRVOTE]
3. ONLINE 626f4793a1794fc9bfeec52aa161bbcf (/dev/oracleasm/asm-disk07) [OCRVOTE]
Located 3 voting disk(s).
[root@datarac1 bin]# exit
반응형