Linux / Windows – what’s the difference…

Oracle & Archivelogs & STBY Database


I have wondered about SQL query: select max(sequence#) from v$archived_log where applied='YES' same way as others – that when you manually apply archivelogs to standby database then why will be there difference between PRD and STBY databases when executing that query…
The answer is quite simple:
For manual recovered history you have to look at v$log_history instead of v$archived_log.
And as far I have found out, manual recovery never writes logs in v$archived_log, you have to check log_history or alertlog file.

So the correct command on STBY DB would be:
select max(SEQUENCE#) from v$log_history;

, ,

Leave a Reply

Your email address will not be published. Required fields are marked *