增加控制文件

来源：互联网发布：汉服复兴知乎编辑：程序博客网时间：2024/05/16 12:07

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 下）把控制文件转换成建立控制文件的脚本