【备份恢复】 控制文件多路径

 控制文件多路径

更改控制文件为多路径，至少要在4个位置。

1.查看控制文件路径：
SQL> show parameter control

 

NAME                                 TYPE        VALUE

------------------------------------ -----------

control_file_record_keep_time        integer     7

control_files                        string      /u01/app/oracle/oradata/PROD/c

                                                 ontrol01.ctl, /u01/app/oracle/

                                                 oradata/PROD/control02.ctl

control_management_pack_access       string      DIAGNOSTIC+TUNING

SQL>

[oracle@wang oradata]$ cd /u01/app/oracle/oradata/

2.创建目录：

[oracle@wang oradata]$ mkdir con1/ con2/ con3

[oracle@wang oradata]$ ls

con1  con2  con3  ORA11GR2  PROD

3.修改参数control_files:

SQL> alter system set control_files='/u01/app/oracle/oradata/PROD/control01.ctl','/u01/app/oracle/oradata/con1/control02.ctl','/u01/app/oracle/oradata/con2/control03.ctl','/u01/app/oracle/oradata/con3/control04.ctl' scope=spfile;

 

System altered.

4.关库（使触发检查点保证数据库一致性状态）：

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

5.进入操作系统层面复制控制文件：

[oracle@wang PROD]$ ls

control01.ctl  redo01.log  redo03.log    system01.dbf  temp1.dbf  test01.dbf  undotbs01.dbf  users02.dbf

control02.ctl  redo02.log  sysaux01.dbf  temp01.dbf    temp2.dbf  tool01.dbf  users01.dbf

[oracle@wang PROD]$ cp control01.ctl control03.ctl

[oracle@wang PROD]$ cp control01.ctl control04.ctl

[oracle@wang PROD]$ ls

control01.ctl  control03.ctl  redo01.log  redo03.log    system01.dbf  temp1.dbf  test01.dbf  undotbs01.dbf  users02.dbf

control02.ctl  control04.ctl  redo02.log  sysaux01.dbf  temp01.dbf    temp2.dbf  tool01.dbf  users01.dbf

[oracle@wang PROD]$ mv control02.ctl /u01/app/oracle/oradata/con1/

[oracle@wang PROD]$ mv control03.ctl /u01/app/oracle/oradata/con2/

[oracle@wang PROD]$ mv control04.ctl /u01/app/oracle/oradata/con3/

[oracle@wang PROD]$ ls

control01.ctl  redo02.log  sysaux01.dbf  temp01.dbf  temp2.dbf   tool01.dbf     users01.dbf

redo01.log     redo03.log  system01.dbf  temp1.dbf   test01.dbf  undotbs01.dbf  users02.dbf

[oracle@wang PROD]$

6.验证：

[oracle@wang PROD]$ cd ..

[oracle@wang oradata]$ ls

con1  con2  con3  ORA11GR2  PROD

[oracle@wang oradata]$ cd con1

[oracle@wang con1]$ ls

control02.ctl

[oracle@wang con1]$ cd ..

[oracle@wang oradata]$ ls

con1  con2  con3  ORA11GR2  PROD

[oracle@wang oradata]$ cd con2

[oracle@wang con2]$ ls

control03.ctl

[oracle@wang con2]$ cd ..

[oracle@wang oradata]$ cd con3

[oracle@wang con3]$ ls

control04.ctl

[oracle@wang con3]$

7.重启数据库使控制参数生效：

SQL> show parameter control

 

NAME                                 TYPE        VALUE

------------------------------------ -----------

control_file_record_keep_time        integer     7

control_files                        string      /u01/app/oracle/oradata/PROD/c

                                                 ontrol01.ctl, /u01/app/oracle/

                                                 oradata/con1/control02.ctl, /u

                                                 01/app/oracle/oradata/con2/con

                                                 trol03.ctl, /u01/app/oracle/or

                                                 adata/con3/control04.ctl

control_management_pack_access       string      DIAGNOSTIC+TUNING

SQL>
完成！！！！！！！！！！！

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/31397003/viewspace-2126953/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/31397003/viewspace-2126953/