Monthly Archives: August 2018

RMAN RECOVER TABLE Feature New to Oracle Database 12c (Point in Time TABLE RECOVERY Example)

% rman target sys/oracle@t12ccdb log recover_table5.log RMAN> RECOVER TABLE SMEDS.”RECTEST” OF PLUGGABLE DATABASE T12CPDB1 UNTIL SEQUENCE 64 thread 1 AUXILIARY DESTINATION ‘/testcases/rectbl’ REMAP TABLE ‘SMEDS’.’RECTEST’:’TEST4_RECTEST’; Starting recover at 21-JAN-13 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=16 device type=DISK RMAN-05026: WARNING: presuming following set of tablespaces applies to specified Point-in-Time List of tablespaces expected to have UNDO […]