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 : 1/18/2015 by Anuj
 
Comments
No comment found.
 


Add Your Comments
 
Name :
Email :
Comments :

 

 
 
  Archives
 
  Recent Posts

Checking database patch level
Posted on :   11/2/2017

Finding database home information in database
Posted on :   10/10/2017

Beginner to Exadata?
Posted on :   8/31/2017

  Recent Comments
 

Home  |  About Me  |  Contact  |  Oracle12cSIG(IOUG)

All Rights Reserved 2013 Oracle-12c