Beranda > Oracle > Oracle Shutdown In Progress

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.

Kategori:Oracle
  1. setijoagus
    4 Desember 2008 pukul 9:45 am

    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

  1. No trackbacks yet.

Tinggalkan Balasan

Isikan data di bawah atau klik salah satu ikon untuk log in:

Logo WordPress.com

You are commenting using your WordPress.com account. Logout / Ubah )

Gambar Twitter

You are commenting using your Twitter account. Logout / Ubah )

Foto Facebook

You are commenting using your Facebook account. Logout / Ubah )

Foto Google+

You are commenting using your Google+ account. Logout / Ubah )

Connecting to %s

%d blogger menyukai ini: