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




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
5. Table should not be residing in system table space
6. Level 0 backup  and all desired backups are available

Oracle 12c -Table Recovery in from RMAN Backups -part2.docx
Posted on : 1/18/2015 by Anuj
No comment found.

Add Your Comments
Name :
Email :
Comments :


  Recent Posts

Oracle Database 19c is available via LiveSQL
Posted on :   1/21/2019

How Do I Find the Exadata Documentation, Such as Owner and User Guide
Posted on :   5/31/2018

Exachk 18.2.0_20180518 is available now…
Posted on :   5/20/2018

  Recent Comments

Home  |  About Me  |  Contact  |  Oracle12cSIG(IOUG)

All Rights Reserved © 2013 Oracle-12c