OraFAQ Forum: Backup & Recovery » Recover dropped table from rman backup

Home » RDBMS Server » Backup & Recovery » Recover dropped table from rman backup (Windows)

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

Recover dropped table from rman backup [message #623936]

Tue, 16 September 2014 08:05

sagardrock
Messages: 4
Registered: September 2014

Junior Member

If I want to recover table dropped few days before. I have RMAN backup taken before dropping table.
I don't have table in recycle-bin.(or Suppose I had dropped it with PURGE option)

Now I have only old RMAN backup. I don't want to recover full database(because it's time consuming and only interested in single table)

please suggest all possible ways to do this?

Report message to a moderator

Re: Recover dropped table from rman backup [message #623939 is a reply to message #623936]

Tue, 16 September 2014 08:14

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Welcome to this forum.

>please suggest all possible ways to do this?
You recover whole DB, then SELECT the desired table

Report message to a moderator

Re: Recover dropped table from rman backup [message #623941 is a reply to message #623939]

Tue, 16 September 2014 08:23

John Watson
Messages: 8994
Registered: January 2010
Location: Global Village

Senior Member

Or, if using the current release, use the RECOVER TABLE command within RMAN,
http://docs.oracle.com/database/121/BRADV/rcmresind.htm
The automation of the incomplete recovery and Data Pump is very clever.

Report message to a moderator

Re: Recover dropped table from rman backup [message #623944 is a reply to message #623941]

Tue, 16 September 2014 08:42

sagardrock
Messages: 4
Registered: September 2014

Junior Member

recovery whole database will take more time also it will rollback all changes in other tables.
No I'm not using 12i

Report message to a moderator

Re: Recover dropped table from rman backup [message #623945 is a reply to message #623944]

Tue, 16 September 2014 08:43

sagardrock
Messages: 4
Registered: September 2014

Junior Member

*12c

Report message to a moderator

Re: Recover dropped table from rman backup [message #623946 is a reply to message #623944]

Tue, 16 September 2014 08:59

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

Senior Member
Account Moderator

You recover the database in other place, export the table then import it in the original database.

Report message to a moderator

Re: Recover dropped table from rman backup [message #623948 is a reply to message #623946]

Tue, 16 September 2014 09:09

sagardrock
Messages: 4
Registered: September 2014

Junior Member

No simple way other than this??

Report message to a moderator

Re: Recover dropped table from rman backup [message #623951 is a reply to message #623948]

Tue, 16 September 2014 10:04

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

Senior Member
Account Moderator

No.

Report message to a moderator

Re: Recover dropped table from rman backup [message #624415 is a reply to message #623948]

Mon, 22 September 2014 10:39

LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL

Senior Member

sagardrock wrote on Tue, 16 September 2014 10:09

No simple way other than this??

You only need to recover the SYSTEM, SYSAUX, UNDOTBS and the tablespace containing the table to be recovered.

Check out: RMAN Tablespace Point-in-Time Recovery

[Updated on: Thu, 18 December 2014 01:14] by Moderator

Report message to a moderator

Previous Topic:	rman crosscheck
Next Topic:	Flashback Database error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 26 06:19:13 CST 2025