...
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.
| No Format | ||
|---|---|---|
| ||
dbvrep> shutdown all |
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.
...
| 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]: |
...