Re: RMAN question: How do you connect scn# to realtime
- From: "Mark D Powell" <Mark.Powell@xxxxxxx>
- Date: 28 Jul 2005 06:26:02 -0700
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 --
.
- References:
- RMAN question: How do you connect scn# to realtime
- From: EdwardNing
- RMAN question: How do you connect scn# to realtime
- Prev by Date: Re: Sybrand Bakker: Gets humiliated in public?
- Next by Date: resize tablesepace temp
- Previous by thread: RMAN question: How do you connect scn# to realtime
- Next by thread: pmap - anon pages
- Index(es):
Relevant Pages
|
