urgent - database can't open due to ORA-01113: file needs media recovery!!!
Hi,
Today I tried to restart my database, I got the following error when issuing startup command:
Code:
SQL> startup
ORACLE instance started.
Total System Global Area 2820219832 bytes
Fixed Size 455608 bytes
Variable Size 671088640 bytes
Database Buffers 2147483648 bytes
Redo Buffers 1191936 bytes
Database mounted.
ORA-01113: file 10 needs media recovery
ORA-01110: data file 10: 'D:\ORACLE\ORADATA\DB01.DBF'
SQL> RECOVER DATAFILE 'D:\ORACLE\ORADATA\DB01.DBF';
ORA-00279: change 2250966028 generated at 09/24/2007 17:28:20 needed for thread
1
ORA-00289: suggestion :
D:\ORACLE\ORADATA\ARCHIVE\DBT001S44739.ARC
ORA-00280: change 2250966028 for thread 1 is in sequence #144739
Specify log: {=suggested | filename | AUTO | CANCEL}
ORA-00308: cannot open archived log
'D:\ORACLE\ORADATA\ARCHIVE\DBT001S44739.ARC'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
Unfortunately I don't have the old archive log files. Please help!!!
