Oracle & Archivelogs & STBY Database
Hi,
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;
SCOT / SAPConnect configuration SAP client copy