DG+非RAC环境增加控制文件

denglj · 发表于 2022-3-16 09:09:22

环境：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

郑全 · 发表于 2022-3-16 11:59:11

本帖最后由郑全于 2022-3-16 12:01 编辑

DG物理备库要增加控制文件怎么办呢

denglj · 发表于 2022-3-19 10:48:34

本帖最后由 denglj 于 2022-3-19 10:49 编辑

郑全发表于 2022-3-16 11:59
DG物理备库要增加控制文件怎么办呢

这两个帖应该可以
http://bbs.cqsztech.com/forum.ph ... iewthread&tid=29836
http://bbs.cqsztech.com/forum.php?mod=viewthread&tid=29837

帐号		自动登录	找回密码
密码			注册

[Oracle] DG+非RAC环境增加控制文件