Q309: Replication Cleanup in a Cloned Database
Tim Herring , Boise Inc. Biography
Objectives: | To Isolate Test from Production To Find Production Elements Left in the Clone Use Oracle’s Packages for Complete Cleanup |
Abstract: | Cloning a production database that participates in Master-Master replication necessitates cleanup / removal of the production replication pieces. Oracle’s suggested solution was to tear down replication before making the clone. This was not acceptable in a 24x7 production environment. Ideally, we would like to use the replication packages to dismantle the leftover production replication master groups. To accomplish this, data in the repcat$_repschema table needs to be updated. This session will show how to cleanup a cloned database. |
Audiernce Focus: | DBA |
Expertise: | Intermediate |
Track: | Database |
Date: | Monday, April 14, 2008 |
Time: | 11:45 AM - 12:15 PM |