ORA-01113:file 1 needs media recovery

[hrishy]

Hi

Whats teh contents of the alert log.

Did you try to restart the instance ?

regards
Hrishy

[boobathi]

hi,
i had restarted the instance again and my databse is running again.
thanks for everyone, helped me to solve this issue.

[boobathi]

hi,
i had restarted the instance again and my databse is running again.
thanks for everyone helped me to solve this issue.

[udaysap]

Hi

I think u need whole database recovery

sql>Recover Database

Try this

[gandolf989]

Hi

I think u need whole database recovery

sql>Recover Database

Try this

It is a bit late to offer help on this post.
You should check the date before responding to old posts.

[vijaya lakshmi]

SQL> startup
ORACLE instance started.

Total System Global Area 1068937216 bytes
Fixed Size 2260048 bytes
Variable Size 629146544 bytes
Database Buffers 432013312 bytes
Redo Buffers 5517312 bytes
Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF'


SQL> select name,open_mode from v$database;

NAME OPEN_MODE
--------- --------------------
XE MOUNTED
SQL> SELECT MEMBER FROM V$LOG G, V$LOGFILE F WHERE G.GROUP# = F.GROUP# AND G.STA
TUS = 'CURRENT';

MEMBER
--------------------------------------------------------------------------------

C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_DD4MKPHY_.LOG

SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
ORA-00279: change 409803 generated at 03/14/2017 11:02:59 needed for thread 1
ORA-00289: suggestion :
C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\ARCHIVELOG\2017_03_15\O1_MF_1_5_%U_

.ARC
ORA-00280: change 409803 for thread 1 is in sequence #5


Specify log: {=suggested | filename | AUTO | CANCEL}
C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_DD4MKPHY_.LOG
Log applied.
Media recovery complete.
SQL> alter database open resetlogs;

Database altered.

SQL> select name,open_mode from v$database;

NAME OPEN_MODE
--------- --------------------
XE READ WRITE

SQL>

[gandolf989]

SQL> startup
ORACLE instance started.

Total System Global Area 1068937216 bytes
Fixed Size 2260048 bytes
Variable Size 629146544 bytes
Database Buffers 432013312 bytes
Redo Buffers 5517312 bytes
Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF'


...

Do you think that the original poster is going to see your response and do you
think that they are still having the same issue after 11 years?