Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: RMAN question: How do you connect scn# to realtime
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 -- Received on Thu Jul 28 2005 - 08:26:02 CDT