Oracle & Archivelogs & STBY Database

28/12/2012 [D_A] HOWTO, Oracle, Tehniline, 0

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;

archivelogs, Oracle, standby database

SCOT / SAPConnect configuration SAP client copy