Home

About Me Contact Me Oracle12cSIG(IOUG)
 
Home  :: Oracle12c

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

How to find correct Golden Gate version?
Posted on :   2/28/2021

Automatic Indexing
Posted on :   5/31/2020

Database 19c New Features
Posted on :   5/28/2020

  Recent Comments
 

Home  |  About Me  |  Contact  |  Oracle12cSIG(IOUG)

An error occurred on the server when processing the URL. Please contact the system administrator.

If you are the system administrator please click here to find out more about this error.