Restore Table from RMAN Backup Oracle 12c

 
One of the amazing features of Oracle Database 12c is that now you can do a logical restore from a physical backup. Before 12c it was not possible to restore a table from a RMAN backup. This feature is amazing speciall when you have a large database and needs to restore a small table. One of the pre-requisites is you must have a Full Backup of the database and also archivelogs after the fully backup must be available. We can proceed to do the restore with below RMAN command
$ rman target /
RECOVER TABLE HR.EMP
UNTIL TIME ‘SYSDATE-0.22’
AUXILIARY DESTINATION ‘/backups/rmanbkp’
REMAP TABLE ‘HR’.’EMP’:’EMP_RECVR’
HR.EMP is the table to be recovered from the RMAN backup
SYSDATE-0.22 is the time till where the table will be rolled back; this is to specify the point in time for recovery: UNTIL TIME, UNTIL SCN, or UNTIL SEQUENCE can be used
Auxiliary Destination is destination where a instance is created for the recovery process
REMAP TABLE clause is used to specify to restore the table with another name
Using this method even individual table paritions can be restored.

Category: DatabaseRMANUncategorized

Tags:

One comment

Leave a Reply

Article by: Shadab Mohammad