| corrupt system datafile [message #53190] |
Mon, 02 September 2002 03:15  |
rana
Messages: 12
Registered: July 2002
|
Junior Member |
|
|
Unfurtunately One of my server's system data file got corrupted , I don't have any backup for last one week. Pls help me, how to retrieve lost data.
thanx in advance
RANA
|
|
|
|
| Re: corrupt system datafile [message #53212 is a reply to message #53190] |
Tue, 03 September 2002 14:34  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
Well may be next time you will do have one. If you don't have backup from the last week, what about two weeks ago? That is your only one hope - valid backup.
Are you running in NOARCHIVELOG too? SYSTEM tablespace is impossible to recover w/o backup. You might have to re-create your db from scratch.
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
