Perform this procedure in the maintenance window and when there are no incoming contacts entering the system.
Caution:
Post the procedure you cannot migrate any data from DC2 to DC1.
Perform this procedure on the target DC1.
Before you begin
Check the migration status for row count before breaking the link between source and target database.
Procedure
Log in to the Cluster Control Manager (CCM) console as the customer user.
To switch to the root user, type su and press Enter.
Run the following script:
ccm release orca-dbmgr migration2to5.sh
When prompted, provide the IP address and Port for the source warehouse analytics_db.
Note:
Here, you need to enter the IP address and port number which you noted after running HAsourcemigrate2to5.sh script on the source system.
Enter the postgres password for the source database.
The default system password for postgres user on the system is myflexuser01.
There is a prompt to enter mstr db password. Ignore it as the script will not work with mstr db as a source.
The following options are displayed on the screen:
1)migrate source to target
2)cleanup failed attempt
3)break link to source make target independent
4)check migration status
5)quit
Choose option to run: Options list:
Important:
Before disconnecting the source system, verify that the data is matching in the source system and the target system. You can verify this by running option Check Migration Status in another console. Before running Check Migration Status in another console, run command ccm release orca-dbmgr migration2to5.sh.
After running option Break link to source make target independent, the new data that comes in the source system is not available in the target system.
Type 3 for the Break link to source make target independent, enter the corresponding number.
This option notifies the target system to stop copying from source system. It disconnects the source database, which means data coming on the source system will not be synced with the target system.
Select Check Migration Status, enter the corresponding number.
This option performs row counts and database object counts to compare the source system and the target system. Run this option only after the Migrate source to target step is completed successfully.
