From oracle-l-bounce@freelists.org Thu Sep 9 11:01:36 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i89G1ak03546 for ; Thu, 9 Sep 2004 11:01:36 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i89G1aI03541 for ; Thu, 9 Sep 2004 11:01:36 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 76CA272D74F; Thu, 9 Sep 2004 11:03:11 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 31159-05; Thu, 9 Sep 2004 11:03:11 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 49A7172D378; Thu, 9 Sep 2004 11:03:10 -0500 (EST) Message-ID: <30462D80AA52E74698512ADCC4F7EAA31223979A@EXCHANGE> From: "Gogala, Mladen" To: "'rjamya@gmail.com'" , Oracle Discussion List Subject: RE: Finding SCN during recovery Date: Thu, 9 Sep 2004 12:05:53 -0400 MIME-Version: 1.0 Content-type: text/plain Content-Transfer-Encoding: 8bit X-archive-position: 9320 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Mladen.Gogala@aetn.com Precedence: normal Reply-To: Mladen.Gogala@aetn.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org 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@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@freelists.org&subject=unsubscribe To search the archives - http://www.freelists.org/archives/oracle-l/