Data Guard Attributes : SYNC / ASYNC and Standby Redo Logs
Dears,
We are running database 11g R2 (11.2.0.1) 32 bit on Windows. We are in the process of building data guard between both databases
Primary Database Unique Name : ORCLTRNG
Standby Database Unique Name : ORCLSBY
The setup was completed successfully . Here below are the parameters in spfile related to archives.
Primary:
ALTER SYSTEM SET Log_archive_dest_1 = 'location=USE_DB_RECOVERY_FILE_DEST valid_for=(ALL_LOGFILES,ALL_ROLES) db_unique_name=ORCLTRNG' SCOPE=SPFILE;
ALTER SYSTEM SET log_archive_dest_state_1 = 'ENABLE' scope=spfile;
ALTER SYSTEM SET log_archive_dest_2 = 'SERVICE=SBY LGWR ASYNC NOAFFIRM DB_UNIQUE_NAME=ORCLSBY VALID_FOR=(ALL_LOGFILES,PRIMARY_ROLE)' scope=spfile;