思路:1、在数据库中先创建一个新的redo组放在data的磁盘组中2、切换日志文件以便原redo的信息都已归档,并且所有的redo状态为变为inactive3、在asm中执行drop diskgroup 删除磁盘组步骤:1 添加redo组备注:由于在测试环境的RAC里有REDO的磁盘组,但是我查看redo文件并没有在这里,所有我现在创建redo组9到redo的磁盘组中。SQL> alter database add logfile group 9 ('+REDO_ORCL','+REDO_ORCL') size 50m; Database altered. SQL>select g.group#,g.members,g.archived,g.status,e.member from v$log g,v$logfile e where g.group#=e.group# order by g.group#; GROUP#MEMBERS ARC STATUS MEMBER---------- ---------- --- ---------------- -------------------------------------------------- 1
2 YES INACTIVE +DATA_ORCL/orcldb/onlinelog/group_1.307.762625909 1
2 YES INACTIVE +DATA_ORCL/orcldb/onlinelog/group_1.305.762625911 2
2 YES INACTIVE +DATA_ORCL/orcldb/onlinelog/group_2.300.762625913 2
2 YES INACTIVE +DATA_ORCL/orcldb/onlinelog/group_2.309.762625917 3
2 YES INACTIVE +DATA_ORCL/orcldb/onlinelog/group_3.310.762625919 3
2 YES INACTIVE +DATA_ORCL/orcldb/onlinelog/group_3.311.762625923 4
2 YES INACTIVE +DATA_ORCL/orcldb/onlinelog/group_4.312.762625925 4
2 YES INACTIVE +DATA_ORCL/orcldb/onlinelog/group_4.313.762625929 5
2 NOCURRENT
+DATA_ORCL/orcldb/onlinelog/group_5.314.762625931 5
2 NOCURRENT
+DATA_ORCL/orcldb/onlinelog/group_5.315.762625935 6
2 YES INACTIVE +DATA_ORCL/orcldb/onlinelog/group_6.316.762625937 GROUP#MEMBERS ARC STATUS MEMBER---------- ---------- --- ---------------- -------------------------------------------------- 6
2 YES INACTIVE +DATA_ORCL/orcldb/onlinelog/group_6.317.762625941 7
2 NOCURRENT
+DATA_ORCL/orcldb/onlinelog/group_7.318.762625943 7
2 NOCURRENT
+DATA_ORCL/orcldb/onlinelog/group_7.319.762625947 8
2 YES INACTIVE +DATA_ORCL/orcldb/onlinelog/group_8.320.762625949 8
2 YES INACTIVE +DATA_ORCL/orcldb/onlinelog/group_8.321.762625953 9
2 YES UNUSED +REDO_ORCL/orcldb/onlinelog/group_9.258.775928535 9
2 YES UNUSED +REDO_ORCL/orcldb/onlinelog/group_9.257.7759285352 切换日志让新创建的这个redo状态变为inactiveSQL> alter system switch logfile;System altered.SQL> alter system switch logfile;System altered.SQL> select g.group#,g.members,g.archived,g.status,e.member from v$log g,v$logfile e where g.group#=e.group# order by g.group#; GROUP#MEMBERS ARC STATUS MEMBER---------- ---------- --- ---------------- -------------------------------------------------- 1
2 YES INACTIVE +DATA_ORCL/orcldb/onlinelog/group_1.307.762625909 1
2 YES INACTIVE +DATA_ORCL/orcldb/onlinelog/group_1.305.762625911 2
2 NOCURRENT
+DATA_ORCL/orcldb/onlinelog/group_2.300.762625913 2
2 NOCURRENT
+DATA_ORCL/orcldb/onlinelog/group_2.309.762625917 3
2 YES INACTIVE +DATA_ORCL/orcldb/onlinelog/group_3.310.762625919 3
2 YES INACTIVE +DATA_ORCL/orcldb/onlinelog/group_3.311.762625923 4
2 YES INACTIVE +DATA_ORCL/orcldb/onlinelog/group_4.312.762625925 4
2 YES INACTIVE +DATA_ORCL/orcldb/onlinelog/group_4.313.762625929 5
2 YES ACTIVE +DATA_ORCL/orcldb/onlinelog/group_5.314.762625931 5
2 YES ACTIVE +DATA_ORCL/orcldb/onlinelog/group_5.315.762625935 6
2 NOCURRENT
+DATA_ORCL/orcldb/onlinelog/group_6.316.762625937 GROUP#MEMBERS ARC STATUS MEMBER---------- ---------- --- ---------------- -------------------------------------------------- 6
2 NOCURRENT
+DATA_ORCL/orcldb/onlinelog/group_6.317.762625941 7
2 YES INACTIVE +DATA_ORCL/orcldb/onlinelog/group_7.318.762625943 7
2 YES INACTIVE +DATA_ORCL/orcldb/onlinelog/group_7.319.762625947 8
2 YES INACTIVE +DATA_ORCL/orcldb/onlinelog/group_8.320.762625949 8
2 YES INACTIVE +DATA_ORCL/orcldb/onlinelog/group_8.321.762625953 9
2 YES INACTIVE +REDO_ORCL/orcldb/onlinelog/group_9.258.775928535 9
2 YES INACTIVE +REDO_ORCL/orcldb/onlinelog/group_9.257.7759285353 删除磁盘组3.1 查看磁盘组的状态节点一:SQL> select name,state from v$asm_diskgroup;NAME
STATE------------------------------ -----------OCR_ORCL
MOUNTEDDATA_ORCL
MOUNTEDREDO_ORCL
MOUNTED节点二:SQL> select name,state from v$asm_diskgroup;NAME
STATE------------------------------ -----------OCR_ORCL
MOUNTEDDATA_ORCL
MOUNTEDREDO_ORCL
MOUNTED3.2 卸载节点二的磁盘组SQL> alter diskgroup REDO_ORCL dismount force; Diskgroup altered.3.3 节点一磁盘组删除SQL> select name,state from v$asm_diskgroup;NAME
STATE------------------------------ -----------OCR_ORCL
MOUNTEDDATA_ORCL
MOUNTEDREDO_ORCL
MOUNTEDSQL> drop diskgroup REDO_ORCL including contents;Diskgroup dropped.SQL> select name,state from v$asm_diskgroup;NAME
STATE------------------------------ -----------OCR_ORCL
MOUNTEDDATA_ORCL
MOUNTED3.4 查看磁盘组状态节点二SQL> select name,state from v$asm_diskgroup;NAME
STATE------------------------------ -----------OCR_ORCL
MOUNTEDDATA_ORCL
MOUNTED3.5 crsctl查看$ /pmsdb/grid/bin/crsctl stat res -t--------------------------------------------------------------------------------NAME TARGETSTATESERVER
STATE_DETAILS --------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.DATA_ORCL.dg
ONLINEONLINE node1
ONLINEONLINE node2
ora.LISTENER.lsnr
ONLINEONLINE node1
ONLINEONLINE node2
ora.OCR_ORCL.dg
ONLINEONLINE node1
ONLINEONLINE node2
ora.asm
ONLINEONLINE node1
Started
ONLINEONLINE node2
Started
ora.eons
ONLINEONLINE node1
ONLINEONLINE node2
ora.gsd
OFFLINE OFFLINEnode1
OFFLINE OFFLINEnode2
ora.net1.network
ONLINEONLINE node1
ONLINEONLINE node2
ora.ons
ONLINEONLINE node1
ONLINEONLINE node2
--------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.LISTENER_SCAN1.lsnr1ONLINEONLINE node2
ora.oc4j1OFFLINE OFFLINE
ora.node1.vip1ONLINEONLINE node1
ora.node2.vip1ONLINEONLINE node2
ora.scan1.vip1ONLINEONLINE node2 4 加入磁盘组里asmca创建即可,并且我这里创建完之后,自动就mount了,然后键入数据库查看redo组9还在。 |