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@(protected)]
> 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@(protected)&subject=unsubscribe
To search the archives - http://www.freelists.org/archives/oracle-l/
