Home » RDBMS Server » Backup & Recovery » recover truncate table data (Oracle 10.2.0.4 64bit , HP-UX 11.23 64bit)
recover truncate table data [message #555491] Thu, 24 May 2012 11:00 Go to next message
snowball
Messages: 213
Registered: April 2006
Location: China
Senior Member
Hi, all
Our client has this scenario:
May 23th 4:00 PM a user truncate a critical table.
The customer need to recover the data before truncate.

The recover materials list like this:
1. A cold backup of this database at May 1th.
2. The archive log except May 1th ~ May 15th.
3. Every day exp at 00:30 and 12:00.

Is there any way to recover the data before truncate table with these material?

Thanks very much.

Report message to a moderator

Re: recover truncate table data [message #555492 is a reply to message #555491] Thu, 24 May 2012 11:06 Go to previous messageGo to next message
BlackSwan
Messages: 20085
Registered: January 2009
Senior Member
>Is there any way to recover the data before truncate table with these material?
NO

Report message to a moderator

Re: recover truncate table data [message #555499 is a reply to message #555491] Thu, 24 May 2012 11:44 Go to previous messageGo to next message
John Watson
Messages: 3102
Registered: January 2010
Location: Global Village
Senior Member
Quote:
Is there any way to recover the data before truncate table with these material?
No, the best you can do is import the table from the 12:00 export, and lose four hours of changes.

Report message to a moderator

Re: recover truncate table data [message #555650 is a reply to message #555499] Sat, 26 May 2012 08:22 Go to previous message
snowball
Messages: 213
Registered: April 2006
Location: China
Senior Member
Oh, thanks.
The customer needs the consistent data before the truncated.
So I have to think out another ways to find the data, maybe a recover software to try.

Report message to a moderator

Previous Topic: what happen in hot backup mode, forgot put end bacup mode in oracle 11g R2
Next Topic: Scheduler on Particular Condition
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 18 16:29:35 CDT 2013

Total time taken to generate the page: 0.53038 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.