This discussion is archived
3 Replies Latest reply: Mar 23, 2013 8:51 AM by Lonion RSS

VALID_FOR Parameter

user11982706 Newbie
Currently Being Moderated
Another thread on this forum prompted me to post this question. DB version 11.2.0.1
Primary:

ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ONLINE_LOGFILE,PRIMARY_ROLE) DB_UNIQUE_NAME=PLMQDBS'

ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='SERVICE=PLMQDBST ASYNC VALID_FOR=(ONLINE_LOGFILE,PRIMARY_ROLE) DB_UNIQUE_NAME=PLMQDBST' scope=both


Standby:

ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ONLINE_LOGFILE,PRIMARY_ROLE) DB_UNIQUE_NAME=PLMQDBST'

ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='SERVICE=PLMQDBS ASYNC VALID_FOR=(STANDBY_LOGFILE,STANDBY_ROLE) DB_UNIQUE_NAME=PLMQDBS'
Is VALID_FOR is correctly set for primary and standby ? I am not facing any issue with these values set, archives are generated and shipped & applied on standby. But if i switch roles, then would it be fine ?

Edited by: user11982706 on Mar 22, 2013 7:45 PM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points