Archived Redo Logs not applied in standby database
I have configured ODG for SAP ECC6.0 server. Two days back, due to the disk space issue, archived redo logs stopped transferring to the standby database, so missing archived redo logs have been copied to the standby database and started the automatic recovery. After the automatic recovery, there are some redo logs that are not shown in the output of query "select sequence#, archived, applied from v$archived_log order by sequence#;".
Output is as mentioned below:
SEQUENCE# ARC APP
50651 YES YES
50652 YES YES
50686 YES YES
50760 YES YES
50761 YES YES
50793 YES YES
50794 YES YES
50795 YES YES
50796 YES YES
Here, between 50652 and 50686, some archived redo logs are missing, but these archived redo logs are available in the oraarch directory.
Please let me know, how to resolve this issue.
Stefan Koehler replied
as you mentioned, that you have done manual steps you need to register the archive log file.
Please execute the following command for every manual copied archive log file on the standby database:
shell> sqlplus / as sysdba SQL> alter database register logfile '<ARCHIVELOG_PATH>';
After that check it again.