High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center