删除磁盘组

将磁盘组arc删除

重新指定归档目录

SQL>  alter system set log_archive_dest_1='location=+DATA';

System altered.

更改控制文件位置

SQL> show parameter control

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time        integer     7
control_files                        string      +DATA/rac10/controlfile/curren
                                                 t.267.1001289955, +ARC/rac10/c
                                                 ontrolfile/current.268.1001289
                                                 957
control_management_pack_access       string      DIAGNOSTIC+TUNING

更改redo位置

SQL> select member from v$logfile;

MEMBER
--------------------------------------------------------------------------------
+DATA/rac10/onlinelog/group_1.log
+ARC/rac10/onlinelog/group_1.log
+DATA/rac10/onlinelog/group_2.log
+ARC/rac10/onlinelog/group_2.log
+DATA/rac10/onlinelog/group_3.log
+ARC/rac10/onlinelog/group_3.log
+DATA/rac10/onlinelog/group_4.log
+ARC/rac10/onlinelog/group_4.log

在二节点dismount  arc磁盘组

SQL> alter diskgroup arc dismount;

Diskgroup altered.
在一节点删除

SQL> drop  diskgroup  ARC including contents;

Diskgroup dropped.

集群中删除磁盘组

[grid@rac1 ~]$ srvctl remove diskgroup -g arc

在集群中更改数据库依赖的磁盘组

[root@rac1 /]# crsctl status res ora.rac10.db -f|grep DEPENDENCIES

START_DEPENDENCIES=hard(ora.DATA.dg,ora.OCR.dg,ora.ARC.dg) weak(type:ora.listener.type,global:type:ora.scan_listener.type,uniform:ora.ons,global:ora.gns) pullup(ora.DATA.dg,ora.OCR.dg,ora.ARC.dg)

STOP_DEPENDENCIES=hard(intermediate:ora.asm,shutdown:ora.DATA.dg,shutdown:ora.OCR.dg,shutdown:ora.ARC.dg)

[root@rac1 /]#  srvctl modify database -d rac10 -a "OCR,DATA"