| Recover database when windows Crash [message #352270] |
Mon, 06 October 2008 22:51  |
ziauldba
Messages: 55
Registered: January 2007
Location: Bangladesh
|
Member |
|
|
Dear sir,
I have Oracle 9i database, today unfortunately my windows is crash
and reinstall the windows in another drive,
my database is archive log mode..
is it possible to recover my database pls give suggestion ....
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Recover database when windows Crash [message #352340 is a reply to message #352305] |
Tue, 07 October 2008 03:41  |
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
|
Senior Member |
|
|
May be you have a chance, if Oracle support your company.
The tool Data Unloader can unload your data from the datafiles into the dump file. I and my teams have had an experience with the circumstance. No archivelog, no full backup, and we're lucky because no datafiles were lost and crased or failed. But it take us many, many time to rebuild the database. Some rows was lost, some code was lost. Rebuilt from OBJ$, SEQ$, DD$, rebuilt the code from extract ddl before, rebuilt the database link, reconfigured host_name, etc... and imported many dump files from unloaded datafile.
In your case, I think, M.Cadot is right. You should create new database, import the dump file which made 3 days before than rebuilt everything like us. And, you should force your future database in archive log mode, backup daily/weekly. Nothing cannot appears.
[Updated on: Tue, 07 October 2008 03:43] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
