...
| Note |
|---|
The existing configurations are kept during upgrading of Dbvisit Replicate. |
| Info |
|---|
Below steps are applicable for RPM build only. If you have installed Replicate using .tar/.zip file then extract the Replicate directory from the .zip build and replace it with the old directory. |
Upgrading Dbvisit Replicate involves the following steps:
...
Before shutting down you may want to see if MINE/APPLY are going to go back in time. Starting in Replicate 2.8, when you request to shutdown a process information will be displayed about how far back that process must go if it is shutdown.
| No Format | ||
|---|---|---|
| ||
dbvrep> list obsolete redo dbvrep> list transactions transactions |
This is to make sure that the MINE process does not need old redo/archive logs, and for APPLY that it is in the middle of a long transaction. Consider doing the upgrade when MINE/APPLY don't have far to go back.
| No Format | ||
|---|---|---|
| ||
dbvrep> shutdown all
Upon restart MINE will go back to redolog 5901 (thread 1), going back 4 logs.
Upon restart APPLY will go back to plog 5901, going back 4 plogs.
Are you sure you want to shutdown? (Yes/No) [No] yes
Dbvisit Replicate MINE process shutting down. |
1a. (Optional) You may wish to perform a backup of all the directories. Also consider backup up the dbvrep schema on both the source and the target. This is for fallback purposes.
2. Install the Dbvisit Replicate software. This is the same as a new install of the software. After installation, there is no need to reconfigure Dbvisit Replicate.
| Note |
|---|
For zip/tar files, unzip the file, untar the file and then extract the Replicate directory from the .zip build and replace it with the old directory. Basically this is a reinstall directly on top of the old installation. |
| Note |
|---|
For RPM, please ensure the old RPM is removed before installing the new RPM. The old RPM can be uninstalled by running command: rpm -e `rpm -qa | grep dbvisit_replicate` |
Optional Step 2a. You may wish to perform a backup of all the directories. Also consider backup up the dbvrep schema on both the source and the target. This is for fallback purposes.
3. Restart the replication, by running the start scripts.
...
| Note |
|---|
UPGRADE REPOSITORY command is required to be executed only once. It upgrades both MINE and APPLY. |
Example:
Follwing The following example shows the repository error message and its solution using the replication "reptest1" which was configured in 2.6 and later upgraded to 2.7.
...
| No Format |
|---|
oracle@dbvlin203[/home/oracle/reptest1]: ./reptest1-run-dbvlin203.sh Initializing......done 1 records in DDCDB updated to use new variable names. DDC loaded from database (291 variables). Dbvisit Replicate version 2.78 Copyright (C) Dbvisit Software Limited. All rights reserved. DDC file /home/oracle/reptest1/reptest1-MINE.ddc loaded. Starting process MINE...ERR-10: Your Dbvisit Replicate dictionary version 2.67 is not supported by this executable, 2.78.00 is required. Please run "upgrade repository". FATAL-9214: Not starting MINE, could not connect to database. |
...
| No Format |
|---|
oracle@dbvlin203[/home/oracle/reptest1]: ./start-console.sh --silent upgrade repository MINE: Your Dbvisit Replicate dictionary version 2.67 is not supported by this executable, 2.78.00 is required. Please run "upgrade repository". APPLY: Your Dbvisit Replicate dictionary version 2.67 is not supported by this executable, 2.78.00 is required. Please run "upgrade repository". Upgrade to 2.7.008 done. MINE: Upgrade done. Upgrade to 2.7.008 done. APPLY: Upgrade done. OK-0: Completed successfully. oracle@dbvlin203[/home/oracle/reptest1]: |
...