1、查看原有控制文件副本:
SQL> show parameter control_files;
2、关闭数据库:
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
3、复制控制文件并赋权限:
cp /u01/app/oracle/oradata/orcl/control01.ctl /backup/controlfils/control03.ctl
chown -R oracle:oinstall control03.ctl
4、启动实例(以nomount方式):
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 1653518336 bytes
Fixed Size 2253784 bytes
Variable Size 1023413288 bytes
Database Buffers 620756992 bytes
Redo Buffers 7094272 bytes
5、修改参数文件,指定多路复用控制文件路径:
SQL> alter system set control_files="/u01/app/oracle/oradata/orcl/control01.ctl","/u01/app/oracle/fast_recovery_area/orcl/control02.ctl","/backup/controlfils/control03.ctl" scope=spfile;
System altered.
6、关闭数据库:
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
7、重新启动数据库:
SQL> startup;
ORACLE instance started.
Total System Global Area 1653518336 bytes
Fixed Size 2253784 bytes
Variable Size 1023413288 bytes
Database Buffers 620756992 bytes
Redo Buffers 7094272 bytes
Database mounted.
Database opened.
8、查看参数文件:
SQL> show parameter control_files;