Monday, 11 November 2013

Recover table in 12c using RMAN

If one has RMAN backups, recovering table my be as easy as this:

1. For log sequence number:
RMAN> CONNECT TARGET "<ID@DB> AS SYSBACKUP";
          UNTIL SEQUENCE <LOG SEQ Number> THREAD <Thread>
          AUXILIARY DESTINATION <PATH>
          REMAP TABLE <REMAP SCHEMA:TABLE>:<TOSCHEMA:TABLE>;
RMAN>  RECOVER TABLE <Schema>.<TABLE> OF PLUGGABLE DATABASE <DB>

2.Point in time:
RMAN> CONNECT TARGET "<ID@DB> AS SYSBACKUP";
RECOVER TABLE <Schema>.<TABLE>
UNTIL TIME 'SYSDATE-1'
AUXILIARY DESTINATION '<PATH>'
DATAPUMP DESTINATION '<PATH>'
DUMP FILE 'DUMPFILE'
NOTABLEIMPORT;

Above option create dumpfile and doesnot import data because of NOTABLEIMPORT option.


More later!!!!

No comments:

Post a Comment