Home » RDBMS Server » Backup & Recovery » Recover database when windows Crash
Recover database when windows Crash [message #352270] Mon, 06 October 2008 22:51 Go to next message
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 #352276 is a reply to message #352270] Mon, 06 October 2008 23:11 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What backup do you have?

Regards
Michel
Re: Recover database when windows Crash [message #352283 is a reply to message #352276] Mon, 06 October 2008 23:25 Go to previous messageGo to next message
ziauldba
Messages: 55
Registered: January 2007
Location: Bangladesh
Member

not any backup........but i have export backup before 3 days.
Re: Recover database when windows Crash [message #352287 is a reply to message #352283] Mon, 06 October 2008 23:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Create a new database and import and you lose 3 days of work.
Nothing more can be done. This is why export is NOT a backup method and you just learn it the hard way.

Regards
Michel
Re: Recover database when windows Crash [message #352301 is a reply to message #352270] Tue, 07 October 2008 00:39 Go to previous messageGo to next message
ziauldba
Messages: 55
Registered: January 2007
Location: Bangladesh
Member

I know Export is not a backup method...Can i retrieve my data from this datafile. pls suggest me.............
Re: Recover database when windows Crash [message #352305 is a reply to message #352301] Tue, 07 October 2008 00:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Create a new database and import

Regards
Michel
Re: Recover database when windows Crash [message #352340 is a reply to message #352305] Tue, 07 October 2008 03:41 Go to previous message
trantuananh24hg
Messages: 668
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

Previous Topic: Restore stuck affer the control files
Next Topic: Error with reclaim db_recovery_file_dest
Goto Forum:
  


Current Time: Mon Dec 05 10:39:37 CST 2016

Total time taken to generate the page: 0.10534 seconds