Home » RDBMS Server » Backup & Recovery » Recover dropped table from rman backup (Windows)
icon5.gif  Recover dropped table from rman backup [message #623936] Tue, 16 September 2014 08:05 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
John Watson
Messages: 8804
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68418
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68418
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Mar 26 19:37:52 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.