Printable View
hi,
i am using oracle 9i on windows XP,
when i try to open the database i found system file needs media recovery,
the following error occurs
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: datafile 1:'D:\ORACLE\ORADATA\SONA\SYSTEM01.dbf'
the important point to remember is I DONT HAV ANY BACKUP of 'SYSTEM' datafile.....
NOW HOW CAN I RECOVER THE SYSTEM DATAFILE?
i m running my database in archive log mode
can anyone plz help to resolve this issue.....
thanks in advance
first of all, what did you do to make it need recovery
hi,
actually i try to open the database at that time i found this error so i want to do recovery.....
no what did you do before that, to make the file need recovery, just opening the database wouldnt cause that
...and what is the point of running in archive log mode if you don't have a backup?
Is this a prodcution db? If not, why dont you try doing a recover database since you said you are in archive log mode
Did you try running the recover command and letting recover using the archive logs? You may not need to restore anything.
hi,
i try to recover the system file by giving the following command and try to open the database but it once again shows the same error with different datafile that it needs recovery........
this is wat i did to recover:
SQL> recover datafile 'D:\ORACLE\ORADATA\SONA\SYSTEM01.DBF';
Media recovery complete.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 2 needs media recovery
ORA-01110: data file 2: 'D:\ORACLE\ORADATA\SONA\UNDOTBS01.DBF'
SQL> recover datafile 'D:\ORACLE\ORADATA\SONA\UNDOTBS01.DBF';
Media recovery complete.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 3 needs media recovery
ORA-01110: data file 3: 'D:\ORACLE\ORADATA\SONA\CWMLITE01.DBF'
SQL> recover datafile 'D:\ORACLE\ORADATA\SONA\CWMLITE01.DBF'
Media recovery complete.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 4 needs media recovery
ORA-01110: data file 4: 'D:\ORACLE\ORADATA\SONA\DRSYS01.DBF'
SQL> recover datafile 'D:\ORACLE\ORADATA\SONA\DRSYS01.DBF'
Media recovery complete.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 5 needs media recovery
ORA-01110: data file 5: 'D:\ORACLE\ORADATA\SONA\EXAMPLE01.DBF'
..............
wat to do now?
i hav control file backup.can i recover it by "recover database using backup control file until cancel" ?
any suggestions plz......
sorry itz my mistake that not having any backup.....
plz help me to solve this issue.....
what did you do to get it to this point, its important and makes a different
Why didnt you recover the eample01.dbf file?
i issued the same following this and try to recover all file but at last it shows error "ORA-01092: ORACLE instance terminated. Disconnection forced"
here i listed wat i did
SQL> recover datafile 'D:\ORACLE\ORADATA\SONA\SYSTEM01.DBF';
Media recovery complete.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 2 needs media recovery
ORA-01110: data file 2: 'D:\ORACLE\ORADATA\SONA\UNDOTBS01.DBF'
SQL> recover datafile 'D:\ORACLE\ORADATA\SONA\UNDOTBS01.DBF';
Media recovery complete.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 3 needs media recovery
ORA-01110: data file 3: 'D:\ORACLE\ORADATA\SONA\CWMLITE01.DBF'
SQL> recover datafile 'D:\ORACLE\ORADATA\SONA\CWMLITE01.DBF'
Media recovery complete.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 4 needs media recovery
ORA-01110: data file 4: 'D:\ORACLE\ORADATA\SONA\DRSYS01.DBF'
SQL> recover datafile 'D:\ORACLE\ORADATA\SONA\DRSYS01.DBF'
Media recovery complete.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 5 needs media recovery
ORA-01110: data file 5: 'D:\ORACLE\ORADATA\SONA\EXAMPLE01.DBF'
SQL> recover datafile 'D:\ORACLE\ORADATA\SONA\EXAMPLE01.DBF'
Media recovery complete.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 6 needs media recovery
ORA-01110: data file 6: 'D:\ORACLE\ORADATA\SRASDEV\INDX01.DBF'
SQL> recover datafile 'd:/oracle/oradata/srasdev/indx01.dbf';
Media recovery complete.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 7 needs media recovery
ORA-01110: data file 7: 'D:\ORACLE\ORADATA\SRASDEV\TOOLS01.DBF'
SQL> recover datafile 'd:/oracle/oradata/srasdev/tools01.dbf';
Media recovery complete.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 8 needs media recovery
ORA-01110: data file 8: 'D:\ORACLE\ORADATA\SRASDEV\USERS01.DBF'
SQL> recover datafile 'd:/oracle/oradata/srasdev/users01.dbf';
Media recovery complete.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 9 needs media recovery
ORA-01110: data file 9: 'D:\ORACLE\ORADATA\SRASDEV\SAAS_UNIV_DATA01.DBF'
SQL> recover datafile 'd:/oracle/oradata/srasdev/saas_univ_data01.dbf';
Media recovery complete.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 10 needs media recovery
ORA-01110: data file 10: 'D:\ORACLE\ORADATA\SRASDEV\SIS_DB_DATA01.DBF'
SQL> recover datafile 'd:/oracle/oradata/srasdev/SIS_DB_DATA01.dbf';
Media recovery complete.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 11 needs media recovery
ORA-01110: data file 11: 'D:\ORACLE\ORADATA\SRASDEV\SAAS_WEBREF_DATA01.DBF'
SQL> recover datafile 'd:/oracle/oradata/srasdev/saas_WEBREF_DATA01.dbf';
Media recovery complete.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
so wat to do now?
any suggestions plz......
plz help me to solve this issue.....
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.
hi,
i had restarted the instance again and my databse is running again.
thanks for everyone helped me to solve this issue.
Hi
I think u need whole database recovery
sql>Recover Database
Try this
It is a bit late to offer help on this post.Quote:
Originally Posted by udaysap
You should check the date before responding to old posts. :rolleyes:
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>
Do you think that the original poster is going to see your response and do youQuote:
Originally Posted by vijaya lakshmi
think that they are still having the same issue after 11 years?