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 Oracle 10g recycle bin (which requires sysdba privileges), enter the following command, and then restart Oracle:

purge dba_recyclebin;
alter system set recyclebin=OFF scope=spfile;

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

To view the contents of the recycle bin, enter the following:

select * from dba_recyclebin;

To view the current recycle bin configuration, enter the following:

select inst_id, value from gv$parameter