RE: Can't open database

From: <Satheesh.Babu_at_iflexsolutions.com>
Date: Tue, 13 Jul 2004 15:57:44 +0530
Message-ID: <10898BE7CA96D611988B000802255AAF07162228@fmgrt.rt.i-flex.com>

Have u used _allow_resetlogs_corruption? If not,
Set _allow_resetlogs_corruption=3Dtrue in init.ora Startup mount;
Recover database;
Alter database open;

If this doesn't solve the problem there is someother way of increasing the SCN to high value using 10015 to start. I haven't used this event personally may be somebody else can help you.

Thanks and Regards,
Satheesh Babu.S

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Rivaldi Bahar Sent: Tuesday, July 13, 2004 3:37 PM
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:20:02 CDT