OraFAQ Forum: Backup & Recovery » recover table which truncated

Home » RDBMS Server » Backup & Recovery » recover table which truncated (10.2.0.1)

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

recover table which truncated [message #557232]

Mon, 11 June 2012 03:43

andy huang
Messages: 498
Registered: July 2011

Senior Member

Dear all,
How to recover a table which truncate incautiously?

Report message to a moderator

Re: recover table which truncated [message #557236 is a reply to message #557232]

Mon, 11 June 2012 03:50

Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku

Senior Member

The only way is performing recovery till the time before truncate command executed

Report message to a moderator

Re: recover table which truncated [message #557237 is a reply to message #557236]

Mon, 11 June 2012 03:55

andy huang
Messages: 498
Registered: July 2011

Senior Member

Thanks,
Do the incomplete recover,right? is it the only way? how about flashback?

Report message to a moderator

Re: recover table which truncated [message #557238 is a reply to message #557237]

Mon, 11 June 2012 03:56

Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku

Senior Member

If you've enabled flashback database, then it's ok. If not, then there's no way

Report message to a moderator

Re: recover table which truncated [message #557243 is a reply to message #557232]

Mon, 11 June 2012 04:15

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Once again you didn't read the documentation that as a complete section about recovering truncated table.

Regards
Michel

[Updated on: Mon, 11 June 2012 05:01]

Report message to a moderator

Re: recover table which truncated [message #557248 is a reply to message #557238]

Mon, 11 June 2012 04:34

andy huang
Messages: 498
Registered: July 2011

Senior Member

Hi,
Oracle doc say as flowing,flashback can not recover the data which truncated, do you think?

You cannot roll back a TRUNCATE TABLE statement, nor can you use a FLASHBACK TABLE statement to retrieve the contents of a table that has been truncated.

Kamran Agayev wrote on Mon, 11 June 2012 03:56

If you've enabled flashback database, then it's ok. If not, then there's no way

Report message to a moderator

Re: recover table which truncated [message #557252 is a reply to message #557248]

Mon, 11 June 2012 05:01

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Michel Cadot wrote on Mon, 11 June 2012 11:15

Once again you didn't read the documentation that as a complete section about recovering truncated table.

Regards
Michel

Report message to a moderator

Re: recover table which truncated [message #558348 is a reply to message #557252]

Thu, 21 June 2012 03:19

Andrey_R
Messages: 441
Registered: January 2012
Location: Israel

Senior Member

If you do flashback database - you return the *whole database* to some point in time.
However, this means *everything*(all database objects) is affected and returns to same state it was in that point in time,
not only your desired table.

then you will have to execute the command "ALTER DATABASE OPEN RESETLOGS " statement. and not be able to "flashback" to the "current state" afterwards, without using RMAN tool.

you can read about flashback database here >> http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9011.htm

[Updated on: Thu, 21 June 2012 03:20]

Report message to a moderator

Previous Topic:	Enabling Block change Tracking
Next Topic:	Moving from one Windows environment to another Linux environment

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 04 03:50:17 CDT 2025