重庆思庄Oracle、Redhat认证学习论坛

标题: 备库增加控制文件-暂停应用日志 [打印本页]

作者: denglj 时间: 2022-3-19 10:44
标题: 备库增加控制文件-暂停应用日志
数据库版本：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
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
                                                         1/control01.ctl, /u01/app/orac
                                                         le/fast_recovery_area/orcl150/
                                                         control02.ctl, /u01/app/oracle
                                                         /fast_recovery_area/orcl150/co
                                                         ntrol03.ctl, /u01/app/oracle/f
                                                         ast_recovery_area/orcl150/cont
                                                         rol04.ctl
control_management_pack_access    string                DIAGNOSTIC+TUNING
SQL> alter database recover managed standby database using current logfile disconnect from session;

Database altered.

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)