| ORA-01113: file 1 needs media recovery [message #168146] |
Wed, 19 April 2006 01:06  |
oradba16
Messages: 54
Registered: September 2005
|
Member |
|
|
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?
can anyone plz help to resolve this issue.....
thanks in advance
|
|
|
|
| Re: ORA-01113: file 1 needs media recovery [message #168154 is a reply to message #168146] |
Wed, 19 April 2006 01:52  |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
| oradba16 wrote on Wed, 19 April 2006 11:36 |
the important point to remember is I DONT HAV ANY BACKUP of 'SYSTEM' datafile.....
|
If you don't have a backup then how will you recover from the failure?
I guess you can't.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
