SQL> alter system set
2 control_files='/u01/apps/oracle/oradata/TS/controlfile/o1_mf_7gxj1qrn_.ctl',
'/u01/apps/oracle/oradata/TS/controlfile/control02.ctl',
'/u01/apps/oracle/oradata/TS/controlfile/control03.ctl'
scope=spfile;
System altered.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> host cp /u01/apps/oracle/oradata/TS/controlfile/o1_mf_7gxj1qrn_.ctl /u01/apps/oracle/oradata/TS/controlfile/control02.ctl
SQL> host cp /u01/apps/oracle/oradata/TS/controlfile/o1_mf_7gxj1qrn_.ctl /u01/apps/oracle/oradata/TS/controlfile/control03.ctl
SQL> startup
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1218992 bytes
Variable Size 100664912 bytes
Database Buffers 180355072 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
SQL> select name from v$controlfile;
NAME
--------------------------------------------------------------------------------
/u01/apps/oracle/oradata/TS/controlfile/o1_mf_7gxj1qrn_.ctl
/u01/apps/oracle/oradata/TS/controlfile/control02.ctl
/u01/apps/oracle/oradata/TS/controlfile/control03.ctl
ORACLE 运行中进行控制文件的备份
方法一:
SQL> alter database backup controlfile to '/u01/apps/oracle/backup';
Database altered.
方法二:
SQL> alter database backup controlfile to trace;
Database altered.
(udump 下)把控制文件转换成建立控制文件的脚本