Recycle bin setup

The Oracle flashback feature added in Oracle 10g is not supported in Mirror Replication Agent for Oracle. Mirror Replication Agent requires that you disable the recycle bin. To disable the recycle bin (which requires sysdba privileges):

purge dba_recyclebin;
ALTER SYSTEM SET recyclebin = OFF;

NoteIf you are using Oracle RAC, you must disable the recycle bin for each instance in the cluster.

To view the contents of the recycle bin:

select * from dba_recyclebin;

To view the current recycle bin configuration:

select inst_id, value from gv$parameter