Home

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

Oracle 12c Recovering a lost /corrupted table - Part 1

0 Comments

Oracle 12c has automated table level recovery using RMAN. If you lose a table 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 owner.table_name until scn nnnnnnnn auxiliary destination  '    ' ;

 

Prior to Oracle 12c this was done as follows (obviously a tedious process)

  1. Identify data files holding lost /corrupted tables 

  2. Identify free space for system/sysaux and datafiles of step 1

  3. TSPITR

  4. Export table data

  5. Import in database

Read More...


Download
Oracle 12c -Table Recovery from RMAN Backups.pdf
Posted on : 12/29/2014 by Anuj
 
Comments
No comment found.
 


Add Your Comments
 
Name :
Email :
Comments :

 

 
 
  Archives
 
  Recent Posts

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

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

IOUG Collaborate 17
Posted on :   3/25/2017

  Recent Comments
 

Home  |  About Me  |  Contact  |  Oracle12cSIG(IOUG)

All Rights Reserved 2013 Oracle-12c