Oracle12c在生产库停止DataGuard怎么搞？-创新互联

在生产库停止DataGuard操作如下。

SQL> show parameter log_archive_dest_2

NAME                 TYPE     VALUE

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

log_archive_dest_2          string    service="orcldg", SYNC AFFIRM

                         delay=0 optional compression=d

                         isable max_failure=0 max_conne

                         ctions=1 reopen=300 db_unique_

                         name="orcldg" net_timeout=10,

                         valid_for=(online_logfile,all_

                         roles)

log_archive_dest_20          string

log_archive_dest_21          string

log_archive_dest_22          string

log_archive_dest_23          string

NAME                 TYPE     VALUE

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

log_archive_dest_24          string

log_archive_dest_25          string

log_archive_dest_26          string

log_archive_dest_27          string

log_archive_dest_28          string

log_archive_dest_29          string

SQL> show parameter log_archive_dest_state_2

NAME                 TYPE     VALUE

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

log_archive_dest_state_2       string    ENABLE

log_archive_dest_state_20       string    enable

log_archive_dest_state_21       string    enable

log_archive_dest_state_22       string    enable

log_archive_dest_state_23       string    enable

log_archive_dest_state_24       string    enable

log_archive_dest_state_25       string    enable

log_archive_dest_state_26       string    enable

log_archive_dest_state_27       string    enable

log_archive_dest_state_28       string    enable

log_archive_dest_state_29       string    enable

以下三种方式效果是一样的。

SQL> alter system set log_archive_dest_state_2=defer;

System altered.

SQL> alter system set log_archive_dest_state_2=defer scope=both;

System altered.

SQL> alter system set log_archive_dest_state_2=defer scope=both sid='*';

System altered.

发现有报错了。

DGMGRL> show configuration;

Configuration - dg_config

 Protection Mode: MaxAvailability

 Members:

 orcl  - Primary database

  Error: ORA-16810: multiple errors or warnings detected for the database

  orcldg - Physical standby database

   Warning: ORA-16857: standby disconnected from redo source for longer than specified threshold

Fast-Start Failover: DISABLED

Configuration Status:

ERROR  (status updated 45 seconds ago)

DGMGRL>

在生产库启动DataGuard如下：

重新修改数据库参数为enable

SQL> alter system set log_archive_dest_state_2=enable;

System altered.

状态正常了。

DGMGRL> show configuration;

Configuration - dg_config

 Protection Mode: MaxAvailability

 Members:

 orcl  - Primary database

  orcldg - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS  (status updated 7 seconds ago)

日常运维工作，这些过程要熟悉，熟练，懂原理，多动手。每天进步一点点。

另外有需要云服务器可以了解下创新互联cdcxhl.cn，海内外云服务器15元起步，三天无理由+7*72小时售后在线，公司持有idc许可证，提供“云服务器、裸金属服务器、高防服务器、香港服务器、美国服务器、虚拟主机、免备案服务器”等云主机租用服务以及企业上云的综合解决方案，具有“安全稳定、简单易用、服务可用性高、性价比高”等特点与优势，专为企业上云打造定制，能够满足用户丰富、多元化的应用场景需求。