ASM中增加CONTROLFILE

                           ASM中增加CONTROLFILE
ORACLE 10.2

     由于10.2 ASMCMD没有CP命令,相当不方便,只能使用RMAN来增加一个新的CONTROLFILE了.

1,备份永远处于第一位;

2,把当前ORACLE进行MOUNT;

3,使用RMAN,进行BACKUP,然后RESTORE

RMAN> backup as copy current controlfile;

RESTORE

RMAN> restore controlfile to '+DG1/orcl/controlfile/c6';

RMAN>  restore controlfile to '+DG1/orcl/controlfile/c5';

 

4,改CONTROL_FILES,重启DB,以RESETLOGS方式打开.
SQL> shutdown immediate;

SQL> startup mount;

SQL> alter database open resetlogs;

SQL> select name from v$controlfile;

NAME
--------------------------------------------------------------------------------
+DG1/orcl/controlfile/c5
+DG1/orcl/controlfile/c6