OraFAQ Forum: Backup & Recovery » recover truncate table data

Home » RDBMS Server » Backup & Recovery » recover truncate table data (Oracle 10.2.0.4 64bit , HP-UX 11.23 64bit)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

recover truncate table data [message #555491]

Thu, 24 May 2012 11:00

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.

Report message to a moderator

Re: recover truncate table data [message #555492 is a reply to message #555491]

Thu, 24 May 2012 11:06

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

Report message to a moderator

Re: recover truncate table data [message #555499 is a reply to message #555491]

Thu, 24 May 2012 11:44

John Watson
Messages: 8794
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

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.

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Feb 01 10:30:40 CST 2023