From oracle-l-bounce@freelists.org Thu Sep 9 10:54:43 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i89FshD00860 for ; Thu, 9 Sep 2004 10:54:43 -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 i89FshI00855 for ; Thu, 9 Sep 2004 10:54:43 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EDEFC72D567; Thu, 9 Sep 2004 10:56:18 -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 28452-80; Thu, 9 Sep 2004 10:56:18 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4C09F72D60E; Thu, 9 Sep 2004 10:56:18 -0500 (EST) Message-ID: <9177895d0409090859798120d0@mail.gmail.com> Date: Thu, 9 Sep 2004 11:59:04 -0400 From: rjamya To: Oracle Discussion List Subject: Finding SCN during recovery In-Reply-To: Mime-Version: 1.0 Content-type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit References: X-archive-position: 9319 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: rjamya@gmail.com Precedence: normal Reply-To: rjamya@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Hello all, while doing recovery on a test database we issue "recover database using backup controlfile " and Oracle responds with "ORA-00279: change 79332404433 generated at 09/08/2004 04:32:03 needed for thread 2 " >From the rawfiles only, oracle seems to know that 79332404433 is the scn it is looking for=E2=80=A6 since we've recreated the cntrl files, I kno= w it isn't stored there.. 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. any ideas? Raj -- To unsubscribe - mailto:oracle-l-request@freelists.org&subject=unsubscribe To search the archives - http://www.freelists.org/archives/oracle-l/