Home

About Me Contact Me Oracle12cSIG(IOUG)
 
Home  :: Oracle 12c – Recovering a lost /corrupted table of a Pluggable database from RMAN Backup

Oracle 12c Recovering a lost /corrupted table of a Pluggable database from RMAN Backup

0 Comments


 

 

Oracle 12c has automated table level recovery using RMAN. If you lose a table in a pluggable database after user error or get data destroyed because of user or application issue, you can easily restore and recover that table to point in time when issue happened using a single RMAN Command.

Recover table anuj.my_jobs of pluggable database PDB1 until scn 1837963 auxiliary destination '     ';

 

It is a lot easier in Oracle 12c.Below are the requirements for using RMAN table restore

1. Initialization parameter compatible  is set to 12.0 or higher
2. Database is running in archive log mode
3. Control file auto backup is enabled before level 0 backup
4. RETENTION POLICY is set
5. Table should not be residing in system table space
6. Level 0 backup  and all desired backups are available

Download
Oracle 12c -Table Recovery in from RMAN Backups -part2.docx
Posted on : by Anuj
 
Comments
No comment found.
 


Add Your Comments
 
Name :
Email :
Comments :

 

 
 
  Archives
 
  Recent Posts

Open world 2018 is on the corner! Are you attending?
Posted on :   9/7/2018

Step by Step Oracle Database 18c Installation on Oracle Linux 6
Posted on :   9/4/2018

APACOUC Session - Oracle 12cR1 was great Oracle 12c R2 is awesome! by Anuj Mohan
Posted on :   9/4/2018

  Recent Comments
 

Home  |  About Me  |  Contact  |  Oracle12cSIG(IOUG)

All Rights Reserved 2013 Oracle-12c