Database Backup and Recovery (MOSC)

MOSC Banner

question on v$archived_log applied

edited Oct 24, 2018 5:02AM in Database Backup and Recovery (MOSC) 1 commentAnswered

So I have a 10.2.0.5 database with a standby.   The standby is just manually getting archived logs applied to it via a cron script.

The script basically identifies the archived logs to apply and is doing a recovery until cancel.

I have another standby (same version) that is applying the archived logs but is doing a recovery until time statement (via a cron script as well).

The question I have is this.    The standby with the recovery until cancel.  I thought that every log that was applied should be reflected in the v$archived_log view with an applied='YES'.

However they do not ever show up here with that value.  However I do see that in the v$database view that the SCN# is going up as the logs are being applied.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center