重庆思庄oracle技术分享-DG+非RAC环境增加控制文件

环境：DG+非RAC
主库执行
SQL> show parameter control;

NAME TYPE VALUE

---

control_file_record_keep_time integer 7
control_files string /u01/app/oracle/oradata/orcl15
0/control01.ctl, /u01/app/orac
le/fast_recovery_area/orcl150/
control02.ctl, /u01/app/oracle
/oradata/orcl150/control02.ctl
control_management_pack_access string DIAGNOSTIC+TUNING
SQL> alter system set control_files=’/u01/app/oracle/oradata/orcl150/control01.ctl’,’/u01/app/oracle/fast_recovery_area/orcl150/control02.ctl’,’/u01/app/oracle/oradata/orcl150/control02.ctl’,’/u01/app/oracle/fast_recovery_area/orcl150/control03.ctl’ scope=spfile sid=‘orcl150’;

System altered.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> ! cp /u01/app/oracle/fast_recovery_area/orcl150/control02.ctl /u01/app/oracle/fast_recovery_area/orcl150/control03.ctl

SQL> startup
ORACLE instance started.

Total System Global Area 3206836224 bytes
Fixed Size 2257520 bytes
Variable Size 1811942800 bytes
Database Buffers 1375731712 bytes
Redo Buffers 16904192 bytes
Database mounted.
Database opened.
SQL> show parameter control;

NAME TYPE VALUE

---

control_file_record_keep_time integer 7
control_files string /u01/app/oracle/oradata/orcl15
0/control01.ctl, /u01/app/orac
le/fast_recovery_area/orcl150/
control02.ctl, /u01/app/oracle
/oradata/orcl150/control02.ctl
, /u01/app/oracle/fast_recover
y_area/orcl150/control03.ctl
control_management_pack_access string DIAGNOSTIC+TUNING
备库查询
SQL> show parameter control

NAME TYPE VALUE

---

control_file_record_keep_time integer 7
control_files string /u01/app/oracle/oradata/orcl15
1/control01.ctl, /u01/app/orac
le/fast_recovery_area/orcl150/
control02.ctl
control_management_pack_access string DIAGNOSTIC+TUNING