ORA-01113:file 1 needs media recovery

[boobathi]

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

[davey23uk]

first of all, what did you do to make it need recovery

[boobathi]

hi,
actually i try to open the database at that time i found this error so i want to do recovery.....

[davey23uk]

no what did you do before that, to make the file need recovery, just opening the database wouldnt cause that

[KenCunningham]

...and what is the point of running in archive log mode if you don't have a backup?

[thomasp]

Is this a prodcution db? If not, why dont you try doing a recover database since you said you are in archive log mode

[gandolf989]

Did you try running the recover command and letting recover using the archive logs? You may not need to restore anything.

[boobathi]

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.....

[davey23uk]

what did you do to get it to this point, its important and makes a different

Why didnt you recover the eample01.dbf file?

[boobathi]

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.....