RE: Finding SCN during recovery
- From: "Gogala, Mladen" <Mladen.Gogala@xxxxxxxx>
- To: "'rjamya@xxxxxxxxx'" <rjamya@xxxxxxxxx>, Oracle Discussion List <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 9 Sep 2004 12:05:53 -0400
That change can probably be found in one of rhe redo log archives.
There is a table called V$ARCHIVED_LOG which has columns FIRST_CHANGE
and NEXT_CHANGE describing change numbers. You might want to take a peek
in the reference manual for more.
--
Mladen Gogala
A & E TV Network
Ext. 1216
> -----Original Message-----
> From: rjamya [mailto:rjamya@xxxxxxxxx]
> Sent: Thursday, September 09, 2004 11:59 AM
> To: Oracle Discussion List
> Subject: Finding SCN during recovery
> Where would I find change# 79332404433 ?? I have tried
> dumping coltrolfile (on the main db) and tried to convert eh
> SCN, there are some close, but none that matches this number.
>
> We generally clone a db, by taking hot backup, create backup
> control file and then recover.
--
To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe
To search the archives - //www.freelists.org/archives/oracle-l/
Other related posts:
