Emergency UNIX and Linux Support

SQL> select status from v$instance;

STATUS
------------
MOUNTED

SQL> shutdown immediate
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> Startup mount
ORACLE instance started.

Total System Global Area  167772160 bytes
Fixed Size                  1977176 bytes
Variable Size              88085672 bytes
Database Buffers           71303168 bytes
Redo Buffers                6406144 bytes
Database mounted.
SQL> ALTER DATABASE RECOVER;
ALTER DATABASE RECOVER
*
ERROR at line 1:
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done


SQL> alter database open;                                                             
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SQL>

SQL> recover database until cancel USING BACKUP CONTROLFILE;
ORA-00279: change 91832826 generated at 01/31/2012 20:55:27 needed for thread 1
ORA-00289: suggestion :
/var/opt/mediation/ora/oralog/bgw/archive_log_1_4152_716325247.dbf
ORA-00280: change 91832826 for thread 1 is in sequence #4152


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
CANCEL
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1:
'/var/opt/mediation/ora/oradata/BGW/datafile/o1_mf_system_5wcl4ors_.dbf'


ORA-01112: media recovery not started


SQL>

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-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1:
'/var/opt/mediation/ora/oradata/BGW/datafile/o1_mf_system_5wcl4ors_.dbf'


SQL>

alter database open resetlog