-
Hi
Whats teh contents of the alert log.
Did you try to restart the instance ?
regards
Hrishy
-
hi,
i had restarted the instance again and my databse is running again.
thanks for everyone, helped me to solve this issue.
-
ORA-01113: file 1 needs media recovery
hi,
i had restarted the instance again and my databse is running again.
thanks for everyone helped me to solve this issue.
-
file needs file recovery
Hi
I think u need whole database recovery
sql>Recover Database
Try this
-
Originally Posted by udaysap
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.
-
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>
-
Originally Posted by 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'
...
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|