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