Archive logs are not transferred from Primary to Standby
edited Nov 8, 2012 3:56PM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 3 commentsAnswered
The standby database is occasionally missing some archive logs that are
not transferred from the primary database. The following archive logs
are received but not applied on the standby as there is one or more
files missing in the sequence.
I transferred the missing files manually and applied them manually on the standby using 'alter database register logfile...
This triggered again a miss-transfer of files from primary to standby and the standby is missing again some archive logs.
The standby is configured in the primary as:
log_archive_dest_2 = "SERVICE=XXXXXX_S ASYNC VALID_FOR=(ONLINE_LOGFILES, PRIMARY_ROLE) REOPEN=60 DB_UNIQUE_NAME=XXXXXX_S"
This triggered again a miss-transfer of files from primary to standby and the standby is missing again some archive logs.
The standby is configured in the primary as:
log_archive_dest_2 = "SERVICE=XXXXXX_S ASYNC VALID_FOR=(ONLINE_LOGFILES, PRIMARY_ROLE) REOPEN=60 DB_UNIQUE_NAME=XXXXXX_S"
0