Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Finding SCN during recovery
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. 1216Received on Thu Sep 09 2004 - 11:01:36 CDT
> -----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/