My oracle 11g -R2 database was working fine but now its showing this error :-
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0
I searched internet and was found out to do following steps :-
step1: connect / as sysdba
step2: shutdown immediate;
step3: startup mount;
step4: alter database recover;
step5: alter database open;
step6: exit;
when i wrote "alter database recover;" it showed this error that's why further steps were not performed :-
"ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done"
I again searched internet and tried these steps :-
step1: connect / as sysdba
step2: select status, database_status from v$instance; (status column was shown as "mounted" on this query)
step3: alter database mount; (skipped this step as database was already mounted)
step4: select open_mode from v$database; (status column showed "mounted")
step5: exit;
step6: connect / as sysdba
step7: alter database open;
step8: select status, database_status from v$instance;
step9: select open_mode from v$database;
On step#7 it showed following error that's why further steps were not performed :-
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
Please help me out.