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