1 2 Previous Next 26 Replies Latest reply on Jul 31, 2012 5:01 PM by 9233598

    log_archive_dest_1 got changed each time after switchover through dgmgrl

    9233598
      I was testing different scenarios to switchover from a to b, a to c, c to b, b to c, b to a for my one primary with 2 standby configuration.

      In some cases, the log_archive_dest_1 got changed.

      alert .log will have those errors:

      ARC7: Archiving not possible: no primary destinations
      ARC7: Failed to archive thread 1 sequence 2692 (4)

      drc*.log shows:
      07/29/2012 02:06:37
      SQL Execution error=604, sql=[ALTER SYSTEM ARCHIVE LOG CURRENT]. See error stack below.
      ORA-00604: error occurred at recursive SQL level 1
      ORA-16014: log 1 sequence# 2692 not archived, no available destinations
      ORA-00312: online log 1 thread 1: '+DAT/prd/onlinelog/group_1.342.785963735'
      ORA-00312: online log 1 thread 1: '+FRA
      RSM0 failed to reset Redo Transport Services, error ORA-16778
      Deferring associated archivelog destinations of sites permanently disabled due to Switchover
      Notifying Oracle Clusterware to buildup primary database after SWITCHOVER
      Data Guard notifying Oracle Clusterware to start services and other instances change
      Command SWITCHOVER TO prdl completed

      Then I checked log_archive_dest_1 it changed to standby_roles as below without db_unique_name.

      log_archive_dest_1 location="USE_DB_RECOVERY_FILE_DEST", valid_for=(STANDBY_LOGFILE,STANDBY_ROLE)

      Why this behavior happen? how to prevent it in real life during role transitions?

      Thanks in advance.
        1 2 Previous Next