3 Replies Latest reply on Mar 23, 2013 3:51 PM by Lonion

    VALID_FOR Parameter

    user11982706
      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