Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Archived Redo Logs not applied in standby database

Hi,

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.

Regards,

Ranjith

Former Member
replied

Hello Ranjith,

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.

Regards

Stefan

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question