Oracle Flashback Settings

Replication Agent supports Oracle Flashback at the table and transaction levels.

Use Oracle Flashback to query historical data, perform change analysis, and perform self-service repair to recover from logical corruptions while the database is online. Oracle customers can use flashback to undo the previous data change thereby minimizing application outages caused by operator or user errors, such as accidental deletion of valuable data, deletion of the wrong data, and dropping the wrong table.

Replication Agent supports two kinds of flashback:

Flashback a dropped table. This replicates the flashback DDL commands like drop table, flashback table to before drop, and purge recyclebin to target Oracle. To replicate purge dba_recyclebin, use DCO 15.0 ESD#3 or later, and assign the sysdba privilege to the DDL user.
Flashback a table to a specific timestamp or SCN. This replicates the DML changes to the target Oracle database.

To flashback a table to a specific timestamp or SCN:

Use the pdb_setreptable command to mark the table which needs to be flashbacked to a specific state.

To replicate flashback DDL statements:

Enable recycle bin at both primary and replicate database:
```
alter system set recyclebin=on
```
When using ECDA, set the rep_sparse_parse parameter of the ECDA Option for Oracle to 1. The default value of this parameter is 0 when ECDA Option for Oracle 15.0 ESD #3 is used.
Enable DDL replication by using the pdb_setrepddl enable command.