Bringing Back The Database to Previous State after Importing a schema Using Flashback Technology
Step 1 : Firstly we should enable flashback on the database.
Dataguard environment with Logical standby.
DATABASE – ORACLE 11gR2 18.104.22.168.0
PRIMARY DATABASE – PRODDB
It is a new feature in Oracle 11g where cloning is done from one database to another database without any outage or downtime of the primary database.
Earlier we use to clone the database using cold back or rman backup. But RMAN Active duplication feature allows a database to be duplicated directly from its live source database instead of using its backup.
INSTANCE – ASM