Home » RDBMS Server » Backup & Recovery » Recover data from no archive log mode database(PLS URGENT REPLY)
icon9.gif  Recover data from no archive log mode database(PLS URGENT REPLY) [message #338201] Mon, 04 August 2008 03:28 Go to next message
ziauldba
Messages: 55
Registered: January 2007
Location: Bangladesh
Member

Dear sir,
I face a great problem today accidentally i deleted a table from my production database, but my DB is no archive log mode,
and i have DMP backup at yesterday evening.my 20 hour data is lost.
is it possible to recover this tables data...
-------------pls give me reply urgent.
Re: Recover data from no archive log mode database(PLS URGENT REPLY) [message #338204 is a reply to message #338201] Mon, 04 August 2008 03:42 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No it is not possible.
Now you know why ARCHIVELOG mode is great and why export is NOT a backup method.

Next time, don't use URGENT it is fordbidden.
Next time, post your Oracle version (4 decimals) most solutions depend on version.

Regards
Michel
Previous Topic: smon and instance recovery
Next Topic: Backup to tape device
Goto Forum:
  


Current Time: Thu Dec 08 14:35:38 CST 2016

Total time taken to generate the page: 0.05418 seconds