Oracle11g RAC 删除控制文件
注:本测试是在【Oracle11g RAC 增加控制文件(一)】这个基础上完成的。
1:一致性关闭数据库
1 2 |
[grid@rac1 ~]$ srvctl stop database -d racdb [grid@rac1 ~]$ |
2:删除要删除的控制文件
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 |
[grid@rac1 ~]$ asmcmd ASMCMD> ls DATA/ OCR_VOTE/ OV/ ASMCMD> ASMCMD> ASMCMD> cd data ASMCMD> ls <strong>ASM/</strong> RACDB/ ASMCMD> cd racdb ASMCMD> ls CONTROLFILE/ DATAFILE/ ONLINELOG/ PARAMETERFILE/ TEMPFILE/ spfileRACDB.ora ASMCMD> cd con* ASMCMD> ls Current.260.838213361 Current.261 Current.262 <strong>ASMCMD> rm Current.261 ASMCMD> rm Current.262</strong> ASMCMD> ls Current.260.838213361 ASMCMD> ASMCMD> cd .. ASMCMD> ls CONTROLFILE/ DATAFILE/ ONLINELOG/ PARAMETERFILE/ TEMPFILE/ spfileRACDB.ora ASMCMD> cd .. ASMCMD> ls RACDB/ ASMCMD> //我们可以看到,当我们把cp创建的那两个文件删除后,自动创建的ASM目录由于已空,也一并自动删除了 |
3:1节点修改参数并启动数据库
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 |
[oracle@rac1 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.2.0 Production on Tue Feb 11 16:37:02 2014 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to an idle instance. SQL> startup nomount; ORACLE instance started. Total System Global Area 835104768 bytes Fixed Size 2231088 bytes Variable Size 570426576 bytes Database Buffers 260046848 bytes Redo Buffers 2400256 bytes SQL> SQL> alter system set control_files='+data/racdb/CONTROLFILE/Current.260.838213361' scope=spfile; System altered. SQL> shutdown abort; ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 835104768 bytes Fixed Size 2231088 bytes Variable Size 570426576 bytes Database Buffers 260046848 bytes Redo Buffers 2400256 bytes Database mounted. Database opened. SQL> SQL> show parameter control_files NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ control_files string +DATA/racdb/controlfile/curren t.260.838213361 SQL> |
4:2节点启动数据库
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 |
[oracle@rac2 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.2.0 Production on Tue Feb 11 16:38:37 2014 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 835104768 bytes Fixed Size 2231088 bytes Variable Size 562037968 bytes Database Buffers 268435456 bytes Redo Buffers 2400256 bytes Database mounted. Database opened. SQL> SQL> show parameter control_files NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ control_files string +DATA/racdb/controlfile/curren t.260.838213361 SQL> |
完成删除控制文件的动作。