Generic guidelines for Shareplex when upgrading an application.
The following are generic guidelines for Shareplex when upgrading an application. The specific steps can be different from environment to environment.
1. Shutdown application on source and target.
2. Wait all queues are empty then shutdown Shareplex on source and target.
3. Perform cold backup on both databases.
4. Turn off archivelog mode on databases.
5. Upgrade application.
6. Turn on archivelog mode on both database.
7. Run ora_cleansp on both source and target.
8. Start sp_cop on both source and target.
9. Activate config..
10. Perform full backup on both databases.
Durging upgrade, any DDL changes (such as ALTER TABLE ... occur on both source and target) affecting on tables defined in the config should be taken care when activating config becasue Shareplex will analyze all objects defined in config. In case of creating new tables, you need to add new table names in the config before activating the config. In case of dropping tables which exists in the config already, you can remove them from the config before activating the config.
