Table Recovery in Standard Edition
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...