Jika database oracle problem, solusi :
c:\>sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 – Production on Sel Okt 10 07:51:41 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn username/password@XE
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
sql>conn / as sysdba
atau
conn sys/manager as sysdba
sql>shutdown immediate;
SQL> startup
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 4 needs media recovery
ORA-01110: data file 4: ‘D:\ORADATA\XE\USERS.DBF’
SQL> alter database recover datafile ‘D:\ORADATA\XE\USERS.DBF’;
Database altered.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 6 needs media recovery
ORA-01110: data file 6: ‘D:\ORADATA\XE\USERNAME.ORA’
SQL> alter database recover datafile ‘D:\ORADATA\XE\username.DBF’;
alter database recover datafile ‘D:\ORADATA\XE\username.DBF’
*
ERROR at line 1:
ORA-01179: file D:\ORADATA\XE\username.DBF does not exist
SQL> alter database recover datafile ‘D:\ORADATA\XE\username.ora’;
Database altered.
SQL> alter database open;
Database altered.
Mau nanya kok terjadi :
ERROR at line 1:
ORA-01113: file 4 needs media recovery
ORA-01110: data file 4: ‘D:\ORADATA\XE\USERS.DBF’
apakah karena listrik mati, kena virus atau apa ?
apakah database dalam mode achive ?, sehingga perintah
SQL> alter database recover datafile ‘D:\ORADATA\XE\username.ora’;
dapat dijalankan ?
terima kasih
Berdasar pengalaman memang karna listrik mati atau komputer sering restart tanpa prosedur normal. Setelah dijalankan perintah syntax, biasanya SQL kembali normal lagi.
Thx
Oleh: setijoagus on 4 Desember 2008
at 9:45 am