Oracle 11g Dataguard suspend log transfer for physical standby

Oracle 11g Dataguard suspend log transfer for physical standby
Category: Oracle2017-07-18 10:03:17
These two days the production end of the log produced too much lead to the recovery of the archive log directory full of the phenomenon, after clearing the disaster recovery log found log_archive_dest_2 in error state, need to enable it. In the actual production system, there are usually such scenarios, such as on the system maintenance Day, a large number of business updates to the main library, there will be a large number of DML operations, in order to avoid the main library of business updates to the backup of the repository, you can pause the main library of the log transfer, if the main library update problems, The repository also retains a full data image that can perform failover (failover).

1. View the archive path of the backup on the main library

Sql> Show Parameter Log_archive_dest_2

NAME TYPE VALUE

Log_archive_dest_2 string Service=flame ASYNC valid_for=
(Online_logfiles,primary_role)
Db_unique_name=flame

Sql> Show Parameter log_archive_dest_state_2

NAME TYPE VALUE

Log_archive_dest_state_2 string ENABLE

2. Suspend the log transfer of the master library to the standby by setting the defer parameter

Sql> alter system set log_archive_dest_state_2 = ' defer ';

System altered.

Performing an archive log switchover

sql> alter system switch logfile;

System altered.

3, restore the main library to the backup log transfer, the suspended log transfer of the archive log will be transferred to the repository, will not cause the archive log gap

Sql> alter system set log_archive_dest_state_2 = ' Enable ';
System altered.

Oracle 11g Dataguard suspend log transfer for physical standby