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

标题: DG+非RAC环境增加控制文件 [打印本页]

作者: denglj 时间: 2022-3-16 09:09
标题: 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

作者: 郑全 时间: 2022-3-16 11:59
本帖最后由郑全于 2022-3-16 12:01 编辑

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

作者: denglj 时间: 2022-3-19 10:48
本帖最后由 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、Redhat认证学习论坛 (http://bbs.cqsztech.com/)