添加控制文件—场景(DG备库)

原创

Liujun_Deng 2022-03-22 21:07:17 博主文章分类：Oracle ©著作权

文章标签 oracle sql sed 文章分类 Oracle 数据库

©著作权归作者所有：来自51CTO博客作者Liujun_Deng的原创作品，请联系作者获取转载授权，否则将追究法律责任

数据库：11.2.0.4

系统：rhel 7.9

SQL> select open_mode,database_role,db_unique_name from v$database;

OPEN_MODE DATABASE_ROLE DB_UNIQUE_NAME

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

READ ONLY WITH APPLY PHYSICAL STANDBY ORCL151

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, /u01/app/oracle

/fast_recovery_area/orcl150/co

ntrol03.ctl

control_management_pack_access string DIAGNOSTIC+TUNING

SQL> alter database recover managed standby database cancel;

Database altered.

SQL> alter system set control_files='/u01/app/oracle/oradata/orcl151/control01.ctl','/u01/app/oracle/fast_recovery_area/orcl150/control02.ctl','/u01/app/oracle/fast_recovery_area/orcl150/control03.ctl','/u01/app/oracle/fast_recovery_area/orcl150/control04.ctl' scope=spfile;

System altered.

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> ! cp /u01/app/oracle/fast_recovery_area/orcl150/control03.ctl /u01/app/oracle/fast_recovery_area/orcl150/control04.ctl

SQL> startup

ORACLE instance started.

Total System Global Area 3206836224 bytes

Fixed Size 2257520 bytes

Variable Size 1811942800 bytes

Database Buffers 1375731712 bytes