ANIL VEJENDLA

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...

Table Recovery in Standard Edition: Tablespace Point in Time Recovery/Table Recovery  is not Possible in Standard Edition . I am not convinced with this statement and trying  to perform Table Recovery in Standard edition using RMAN. Created Tablespace Called "test1"  and Table called "test1". Taken Backup of Database and Archivelogs: RUN {   ALLOCATE CHANNEL ch11 TYPE DISK MAXPIECESIZE 10G;   BACKUP   FORMAT '/u06/odb/backup/%d_D_%T_%u_s%s_p%p'   DATABASE   PLUS ARCHIVELOG   FORMAT '/u06/odb/backup/%d_A_%T_%u_s%s_p%p';   RELEASE CHANNEL ch11; } Taken Current_scn from v$database: SQL>  select current_scn from v$database; CURRENT_SCN -----------     1655232 Dropped table test1.test1; Now Started working Restore/Recover Dropped Table test1.test1: Created Pfile for auxiliary Instance with following parameters: *************************************************** initialization para...