控制文件(拷贝文件需要关机)：
--#查看
SQL> show parameter control

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time        integer     7
control_files                        string      /u01/app/oracle/oradata/ZHH/co
                                                 ntrol01.ctl
control_management_pack_access       string      DIAGNOSTIC+TUNING
SQL>
SQL> select name from v$controlfile;

NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/ZHH/control01.ctl

1 row selected.
SQL>
--创建一个目录
SQL> alter system set control_files=
2 '/u01/app/oracle/oradata/ZHH/ora_control1.ctl',
3 '/u01/app/oracle/oradata/ZHH/ora_control2.ctl' scope=spfile;

System altered.

SQL>
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
--#复制文件
[oracle@z ~]$ cd /u01/app/oracle/oradata/ZHH
[oracle@z ZHH]$ ls
control01.ctl redo03a.log   redo05_b.log temp01.dbf
redo01a.log    redo04_a.log sysaux01.dbf undotbs01.dbf
redo02a.log    redo05_a.log system01.dbf users01.dbf
[oracle@z ZHH]$ mv control01.ctl ora_control2.ctl
[oracle@z ZHH]$ ls
ora_control2.ctl redo03a.log   redo05_b.log temp01.dbf
redo01a.log       redo04_a.log sysaux01.dbf undotbs01.dbf
redo02a.log       redo05_a.log system01.dbf users01.dbf
[oracle@z ZHH]$ cp ora_control2.ctl ora_control1.ctl
[oracle@z ZHH]$ ls
ora_control1.ctl redo02a.log   redo05_a.log system01.dbf   users01.dbf
ora_control2.ctl redo03a.log   redo05_b.log temp01.dbf
redo01a.log       redo04_a.log sysaux01.dbf undotbs01.dbf
[oracle@z ZHH]$
--#再次查看
SQL> show parameter control

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time        integer     7
control_files                        string      /u01/app/oracle/oradata/ZHH/or
                                                 a_control1.ctl, /u01/app/oracl
                                                 e/oradata/ZHH/ora_control2.ctl
control_management_pack_access       string      DIAGNOSTIC+TUNING
SQL> select name from v$controlfile
2 ;

NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/ZHH/ora_control1.ctl
/u01/app/oracle/oradata/ZHH/ora_control2.ctl

2 rows selected.

SQL>

ITPub博客

控制文件添加

最新文章