Maintaining the Configuration of Single Primary Database and a Physical Standby
edited May 21, 2013 12:02AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 3 commentsAnswered
In the scenario of single Primary Database and a Physical Standby:
IN PRIMARY:
log_archive_dest_1=LOCATION=/oraLog/tempArchive VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
log_archive_dest_2=SERVICE=STANDBYDB LGWR ASYNC REOPEN=30 REGISTER VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=STANDBYDB
log_archive_dest_3=location=/oraLog/standby/racprod valid_for=(STANDBY_LOGFILE,STANDBY_ROLE)
IN PHYSICAL STANDBY:
log_archive_dest_1=LOCATION=/oraLog/racprod/archive valid_for=(STANDBY_LOGFILE,STANDBY_ROLE)
log_archive_dest_2=SERVICE=PRIMARYDB ARCH NOAFFIRM OPTIONAL reopen=30 register VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=PRIMARYDB
log_archive_dest_3=location=/oraLog/racprod/standby valid_for=(STANDBY_LOGFILE,STANDBY_ROLE)
IN PRIMARY:
log_archive_dest_1=LOCATION=/oraLog/tempArchive VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
log_archive_dest_2=SERVICE=STANDBYDB LGWR ASYNC REOPEN=30 REGISTER VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=STANDBYDB
log_archive_dest_3=location=/oraLog/standby/racprod valid_for=(STANDBY_LOGFILE,STANDBY_ROLE)
IN PHYSICAL STANDBY:
log_archive_dest_1=LOCATION=/oraLog/racprod/archive valid_for=(STANDBY_LOGFILE,STANDBY_ROLE)
log_archive_dest_2=SERVICE=PRIMARYDB ARCH NOAFFIRM OPTIONAL reopen=30 register VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=PRIMARYDB
log_archive_dest_3=location=/oraLog/racprod/standby valid_for=(STANDBY_LOGFILE,STANDBY_ROLE)
0