-
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.
this space intentionally left blank
-
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?
this space intentionally left blank
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
|