RE: Can't open database

From: <Jorma.Vuorio_at_nokia.com>
Date: Tue, 13 Jul 2004 13:27:21 +0300
Message-ID: <C89E990FB0879F4DAD7CE51CFE6F6A0F02074AB4@esebe007.ntc.nokia.com>

Hmmm...

Not sure, but try just BEFORE "alter database open resetlogs"

RESTORE DATABASE UNTIL CANCEL; CANCEL; and then ...open resetlogs.

Br.
Jorma

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of ext Rivaldi Bahar Sent: 13 July, 2004 13:07
To: oracle-l_at_freelists.org
Subject: Can't open database

Hi,=20

I'm curious if I still have an option to open the=20 database....
The database is not in archivelog mode, online logfiles=20 are overwritten, old controlfiles gone. Undocumented=20 parameter from metalink didn't help.

Tia.

-riv-

SQL> @riv_file.sql

ORACLE instance started.

Total System Global Area 202868968 bytes=20

                                     =20
Fixed Size                   731368 bytes=20
                                     =20
Variable Size             167772160 bytes=20
                                     =20
Database Buffers           33554432 bytes=20
                                     =20
Redo Buffers                 811008 bytes=20
                                     =20

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=20 ORA-01110: data file 1:=20
'/oradata/qcmscl_13072004/system01.dbf'=20

SQL> spool off

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
"Gabung INSTANIA, dapatkan XENIA. Daftar di www.telkomnetinstan.com, = langsung dapat akses Internet Gratis..
Dan ..ikuti "Instan Smile" berhadiah Xenia,Tour S'pore, Komputer,dll, = info hub : TELKOM Jatim 0-800-1-467826 "
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_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
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_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
-----------------------------------------------------------------

Received on Tue Jul 13 2004 - 05:24:37 CDT