| ORA-01113: file 3 needs media recovery [message #168358] |
Thu, 20 April 2006 00:30  |
oradba16
Messages: 54
Registered: September 2005
|
Member |
|
|
hi,
i am using oracle 9i on windows XPand my database is running in archive log mode
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'
so 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.....
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
