RE: Can't open database
- From: <Satheesh.Babu@xxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 13 Jul 2004 15:57:44 +0530
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Rivaldi Bahar
Sent: Tuesday, July 13, 2004 3:37 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
