Clean up the test environment

Use the following procedure to clean up and remove the replication test environment that you created in the previous sections.

StepsTo clean up and remove the replication test environment

  1. Log in to the Mirror Replication Agent administration port using isql (or another query processor).

  2. Use the following command to suspend the Mirror Replication Agent instance:

    suspend
    
  3. Use the following command to remove the Mirror Replication Agent transaction log and unmark the test primary table (rax_test) in the Oracle database:

    ra_deinit, force
    
  4. Edit the oracle_drop_rs_db_sub.sql and oracle_drop_rs_standby_connection.sql scripts, changing “{pds}.{pdb}” to “MRO.TEST” and '”{rds}.{rdb}” to “ecdaconn.ecdaconn,” where “edcdaconn” is the name of the connection string you defined to ECDA to connect to the replicate Oracle database.Use isql or another query processor to log in to the replicate Replication Server, and execute the edited oracle_drop_rs_db_sub.sql script followed by the oracle_drop_rs_standby_connection.sql script to remove the Replication Server connection to the replicate database.

  5. Log in to the replicate data server, and execute the script to drop the test replicate table:

    oracle_drop_test_primary_table.sql
    
  6. Use your Oracle database access tool (such as sqlplus) to log in to the Oracle data server, and execute the oracle_drop_test_primary_table.sql script to drop the test primary table.