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: 229
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.
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: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Is there any way to recover the data before truncate table with these material?
NO
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: 8922
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.
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: 229
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.
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:
  


Current Time: Thu Mar 28 06:13:03 CDT 2024