Oracle Server - RMAN question: How do you connect scn# to realtime

Author

RMAN question: How do you connect scn# to realtime

EdwardNing

2005-07-28, 7:23 am

I would like to test an incomplete recovery. When I do "list backup of
archivelog all", I can get the scn# and timestamp of each archivelog, but
the timestamp is only "26-Aug-2005", with no hour:Mi:sec info, in this case,
how could I know for sure which archived redolog to apply?

It is 9201 on windows.

Thanks very much for your help.

Mark D Powell

2005-07-28, 9:23 am

Edward, try looking at the v$archived_log and v$log_history views to
see if you can find what you want there. You will need to use a
to_char() on one of the date columns to display the time. Alternately
the sys.smon_scn_time table has the system scn and time entries for the
last week at 5 to 10 minute intervals if you just need to narrow the
time range down.

The alter log should have date and time for the log switches in it.

But on the recovery you can specify the date and time to recover to.
Oracle will then prompt for the necessary archived redo logs. The same
is true if you recover to SCN but then it is up to you to determine
what SCN to recover to.

HTH -- Mark D Powell --

Sponsored Links