Can't open database

From: Rivaldi Bahar <rbahar99_at_plasa.com>
Date: Tue, 13 Jul 2004 17:07:11 +0700
Message-ID: <web-790324@b1.c.plasa.com>

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

---

"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 "

---

---

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:06:02 CDT