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