Dg master for all configured the LGWR sync affirm, the main library startup, case library alter database open read only; Then the alter database recover managed standby database to disconnect from the session; Found in data after deletion, found themselves unable to realize the data real-time synchronization, must through the alter system switch logfile, for library to synchronous main data library,
In order to realize real-time synchronization must be enabled the alter database recover managed standby database using current logfile disconnect from the session.

The main library configuration:
*. Log_archive_config='dg_config=(pri, STD)
*. Log_archive_dest_1='location=/u01/app/arch/ims valid_for=(all_logfiles, all_roles) db_unique_name=pri'
*. Log_archive_dest_2='service=STD LGWR sync affirm valid_for=(online_logfiles, primary_role) db_unique_name=STD'
*. Log_archive_dest_state_1='enable'
*. Log_archive_dest_state_2='enable'
*. Log_archive_max_processes=4
*. Log_file_name_convert='/u01/app/oracle/oradata/ims','/u01/app/oracle/oradata/ims'
*. Memory_target=1606418432
*. Open_cursors=300
*. The processes=150
*. Remote_login_passwordfile='EXCLUSIVE'
*. Standby_file_management='auto'
*. Undo_tablespace='UNDOTBS1'

For the library configuration
*. Fal_client='STD'
*. Fal_server='pri'
*. Log_archive_config='dg_config=(pri, STD)
*. Log_archive_dest_1='location=/u01/app/arch/ims valid_for=(all_logfiles, all_roles) db_unique_name=STD'
='service=*. Log_archive_dest_2 pri LGWR sync affirm valid_for=(online_logfiles, primary_role) db_unique_name=pri'
*. Log_archive_dest_state_1='enable'
*. Log_archive_dest_state_2='enable'
*. Log_archive_max_processes=4
*. Log_file_name_convert='/u01/app/oracle/oradata/ims','/u01/app/oracle/oradata/ims'
*. Memory_target=1606418432
*. Open_cursors=300
*. The processes=1500
*. Remote_login_passwordfile='EXCLUSIVE'
*. Sessions=1655
*. Standby_file_management='auto'
*. Undo_tablespace='UNDOTBS1'

CodePudding user response:

Carefully check whether right in DG for library set standby logfile,
The size and the main library is consistent; Better a set number of units

Otherwise not real-time synchronization!

CodePudding user response:

The select db_unique_name protection_mode, protection_level from v $database;
Look at what is the mode,