Migrating Classic Extract To and From an ADG Database

You must have your parameter files, checkpoint files, bounded recovery files, and trail files stored in shared storage or copied to the ADG database before attempting to migrate a classic Extract to or from an ADG database. Additionally, you must ensure that there has not been any intervening role change or Extract will mine the same branch of redo.

Use the following steps to move to an ADG database:

1. Edit the parameter file ext1.prm to add the following parameters:

   DBLOGIN USERID userid@ADG PASSWORD password
   TRANLOGOPTIONS MINEFROMACTIVEDG
   

2. Start Extract by issuing the START EXTRACT ext1 command.

Use the following steps to move from an ADG database:

1. Edit the parameter file ext1.prm to remove the following parameters:

   DBLOGIN USERID userid@ADG PASSWORD password
   TRANLOGOPTIONS MINEFROMACTIVEDG
   

2. Start Extract by issuing the START EXTRACT ext1 command.