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.

Report message to a moderator

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: 68767
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Aug 31 05:28:45 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.