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_at_gmail.com]
> 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_at_freelists.org&subject=unsubscribe
To search the archives - http://www.freelists.org/archives/oracle-l/
Received on Thu Sep 09 2004 - 11:01:36 CDT
