Oleh: tolaho | 28 November 2008

Oracle Shutdown In Progress

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.


Tanggapan

  1. 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


Beri tanggapan

Your response:

Kategori