From oracle-l-bounce@freelists.org Tue Jul 13 09:10:31 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i6DEAGK14038 for ; Tue, 13 Jul 2004 09:10:26 -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 i6DEA6613971 for ; Tue, 13 Jul 2004 09:10:16 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 004C272DABB; Tue, 13 Jul 2004 08:50:37 -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 14706-50; Tue, 13 Jul 2004 08:50:36 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 86FD672DA8D; Tue, 13 Jul 2004 08:50:20 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 13 Jul 2004 08:48:44 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5BA4172DA16 for ; Tue, 13 Jul 2004 08:48:43 -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 13833-91 for ; Tue, 13 Jul 2004 08:48:43 -0500 (EST) Received: from web20422.mail.yahoo.com (web20422.mail.yahoo.com [66.163.170.245]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 8E6B472D9AE for ; Tue, 13 Jul 2004 08:48:38 -0500 (EST) Message-ID: <20040713141322.19200.qmail@web20422.mail.yahoo.com> Received: from [68.167.56.202] by web20422.mail.yahoo.com via HTTP; Tue, 13 Jul 2004 07:13:22 PDT Date: Tue, 13 Jul 2004 07:13:22 -0700 (PDT) From: Paul Drake Subject: Re: Can't open database To: oracle-l@freelists.org In-Reply-To: MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 4947 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: discgolfdba@yahoo.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org --- Rivaldi Bahar wrote: > Hi, > > I'm curious if I still have an option to open the > database.... > The database is not in archivelog mode, online > logfiles > are overwritten, old controlfiles gone. Undocumented > > parameter from metalink didn't help. > > Tia. > > -riv- > > > SQL> @riv_file.sql > > ORACLE instance started. > > Total System Global Area 202868968 bytes > > Fixed Size 731368 bytes > > Variable Size 167772160 bytes > > Database Buffers 33554432 bytes > > Redo Buffers 811008 bytes > > > Control file created. > > SQL> alter database open resetlogs; > alter database open resetlogs > * > ERROR at line 1: > ORA-01194: file 1 needs more recovery to be > consistent > ORA-01110: data file 1: > '/oradata/qcmscl_13072004/system01.dbf' > > > SQL> spool off did you: - take a backup of what you had before you started? - determine which was the current online redo log - apply the current online redo log? hth. Pd ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------