ORA-01113: file x needs media recovery Error

% oerr ora 01113

01113, 00000, “file %s needs media recovery”

// *Cause: An attempt was made to online or open a database with a file that

// is in need of media recovery.

// *Action: First apply media recovery to the file.

SQL> startup mount

2. Find the name of the redo log file which belongs to the active group

SQL> SELECT MEMBER FROM V$LOG G, V$LOGFILE F WHERE G.GROUP# = F.GROUP# AND G.STATUS = 'CURRENT';

SQL> select GROUP#, STATUS from v$log;

SQL> alter system set "_allow_resetlogs_corruption"=TRUE scope=spfile;

SQL> shutdown immediate;

SQL> startup mount;

3. Using a backup control file, start the cancel based recovery. The system may suggest a non-existing archive log

— ignore it and specify the log file name {with full path} that you got in the above step

SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL

ORA-00279: change 21375038 generated at 09/21/2007 20:12:47 needed for thread 1

ORA-00289: suggestion : /export/pspp/oracle/dbs/arch1_4_633901491.dbf

ORA-00280: change 21375038 for thread 1 is in sequence #4

Specify log: {=suggested filename AUTO CANCEL}

/OraRedo/RedoLogFiles/siamst_log01.dbf

Log applied.

Media recovery complete.

If no luck Cancel < -- Enter CANCEL here

4. Finally open the database in RESETLOGS mode.

It is recommended to reset the online logs after incomplete recovery or recovery with a backup control file

SQL> ALTER DATABASE OPEN RESETLOGS;

Database altered.