Zero Downtime Installation Guide for Oracle

10.3

Back Next

Removing ZDT Replication

To remove the ZDT replication, use the following procedure:

Clean up the event queue in Oracle on the source and target schemas:

SQL> delete from c_repos_zdt_event_queue;
Commit;

Connect to GGSCI and issue the following commands:

DBLOGIN USERID [orsuser | proxyuser] PASSWORD “[password]”
STOP *
DELETE * and answer Y when prompted
STOP MGR

Connect to ORS user and run the following command:

BEGIN
    FOR s IN ( SELECT *
              FROM   user_log_groups ) LOOP
        EXECUTE IMMEDIATE 'alter table ' || s.table_name
                 || ' drop SUPPLEMENTAL LOG GROUP "' || s.log_group_name || '"';
    END LOOP;
END;
/

This is required only on the source schema. However, you can execute it on the target as well.

Connect to SYSTEM and issue the following command to globally disable supplemental logging:

ALTER DATABASE DROP SUPPLEMENTAL LOG DATA;

Rename Saved Search

Table of Contents

Zero Downtime Installation Guide for Oracle

Zero Downtime Installation Guide for Oracle

Removing ZDT Replication

Removing ZDT Replication