Home » RDBMS Server » Backup & Recovery » recover table which truncated (10.2.0.1)
recover table which truncated [message #557232] Mon, 11 June 2012 03:43 Go to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Dear all,
How to recover a table which truncate incautiously?
Re: recover table which truncated [message #557236 is a reply to message #557232] Mon, 11 June 2012 03:50 Go to previous messageGo to next message
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
Re: recover table which truncated [message #557237 is a reply to message #557236] Mon, 11 June 2012 03:55 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Thanks,
Do the incomplete recover,right? is it the only way? how about flashback?
Re: recover table which truncated [message #557238 is a reply to message #557237] Mon, 11 June 2012 03:56 Go to previous messageGo to next message
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
Re: recover table which truncated [message #557243 is a reply to message #557232] Mon, 11 June 2012 04:15 Go to previous messageGo to next message
Michel Cadot
Messages: 58645
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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



Re: recover table which truncated [message #557252 is a reply to message #557248] Mon, 11 June 2012 05:01 Go to previous messageGo to next message
Michel Cadot
Messages: 58645
Registered: March 2007
Location: Nanterre, France, http://...
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

Re: recover table which truncated [message #558348 is a reply to message #557252] Thu, 21 June 2012 03:19 Go to previous message
Andrey_R
Messages: 188
Registered: January 2012
Location: Euro-Asia
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:
  


Current Time: Sat Aug 02 03:03:47 CDT 2014

Total time taken to generate the page: 0.09934 seconds