oracle如何实现多副本,Oracle添加一个控制文件副本

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;