Oracle 12c 在生产库停止Data Guard怎么搞?
在生产库停止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) 日常运维工作,这些过程要熟悉,熟练,懂原理,多动手。每天进步一点点。 (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |