| Data recover from crashed system [message #72690] |
Tue, 16 September 2003 08:31  |
Tina
Messages: 38
Registered: November 2001
|
Member |
|
|
Hello all
I am installing oracle 8i on win2000
i dint take backup of my database
my system was crashed. how can i restore my oracle data from hard disk please give me a solution detail
|
|
|
|
| Re: Data recover from crashed system [message #72694 is a reply to message #72690] |
Fri, 19 September 2003 04:12  |
Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland
|
Senior Member |
|
|
Hi Tina,
I guess there's no way to recover if you've no backup.
You can try to recreate the database with blank datafiles and copy the old ones instead, but this is a hardly bloody way and I don't know if it's working. I'd never tried that.
rgds
Uwe
|
|
|
|
| Re: Data recover from crashed system [message #72721 is a reply to message #72690] |
Thu, 02 October 2003 16:21 |
Manish
Messages: 79
Registered: December 2000
|
Member |
|
|
minimum requirement to try ot recover
1) atleast one good controlfile
2) system tablespace should be intact
3) archive logs .
If you have these three it will depend on the consistency of the controlfile and the system tablespace and the archive logs.
If you do not have either "Lord Have Mercy"
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
