Oracle Database Recovery Problem
        Posted  
        
            by Palani
        on Server Fault
        
        See other posts from Server Fault
        
            or by Palani
        
        
        
        Published on 2010-01-14T16:58:15Z
        Indexed on 
            2010/04/06
            17:03 UTC
        
        
        Read the original article
        Hit count: 431
        
I am very new to Oracle, and trying to restore a oracle 8i database on win 2000 server.
- I have one week old database backup (backup taken with exp command), and i want to restore it now.
- Now I am unable to login through sqlplus (got shutdown in progress error)
- I have a backup and i want to restore it, but oracle is not starting at all, and 'imp' command is failing.
I started sqlplus / as sysdba and following is the log of what i am trying to do. Can some one guide me further.
SQL> shutdown immediate;
ORA-01109: database not open    
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.
Total System Global Area  143423516 bytes
Fixed Size                    75804 bytes
Variable Size              58105856 bytes
Database Buffers           85164032 bytes
Redo Buffers                  77824 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area  143423516 bytes
Fixed Size                    75804 bytes
Variable Size              58105856 bytes
Database Buffers           85164032 bytes
Redo Buffers                  77824 bytes
Database mounted.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01245: offline file 1 will be lost if RESETLOGS is done
ORA-01110: data file 1: 'C:\ORACLE\ORADATA\ABCD\SYSTEM01.DBF'
© Server Fault or respective owner