Can 't open database 2004-07-13 - By Rivaldi Bahar
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 > @(protected)
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 (See ORA-01194.ora-code.com): file 1 needs more recovery to be consistent
ORA-01110 (See ORA-01110.ora-code.com): 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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
