Table Recovery in 12c Enterprise Edition
RMAN> RECOVER TABLE 'TEST1'.'TEST1' UNTIL SCN 3785709 AUXILIARY DESTINATION '/u06/aux'; Starting recover at 30-DEC-16 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=130 device type=DISK RMAN-05026: WARNING: presuming following set of tablespaces applies to specified Point-in-Time List of tablespaces expected to have UNDO segments Tablespace SYSTEM Tablespace UNDOTBS1 Creating automatic instance, with SID='flAE' initialization parameters used for automatic instance: db_name=TEST db_unique_name=flAE_pitr_TEST compatible=12.1.0.2.0 db_block_size=8192 db_files=200 diagnostic_dest=/u01/app/oracle _system_trig_enabled=FALSE sga_target=2560M processes=200 db_create_file_dest=/u06/aux log_archive_dest_1='location=/u06/aux' #No auxiliary parameter file used starting up automatic instance TEST Oracle instance started Total System Global Area...