Shulou(Shulou.com)06/01 Report--

Stop DataGuard operations in production libraries as follows.

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

The following three ways have the same effect.

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.

I found out there was a mistake.

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>

Start DataGuard in the production library as follows:

Modify the database parameter to enable again

SQL> alter system set log_archive_dest_state_2=enable;

System altered.

Status normal.

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)

Daily operation and maintenance work, these processes should be familiar, skilled, understand the principle, more hands-on. A little progress every day.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.