...
Contacting Dbvisit Support servicedesk: http://
...
...
Dbvisit Replicate knowledge base
Dbvisit Support is the single point of contact for all Dbvisit products. To help collect all the information needed by the support, Dbvisit Replicate contains a built-in trace file packaging facility. Use command SUPPORT PACKAGE process to create a zip file containing the files for the specified process, running this command in turn on
...
FETCHER,
...
MINE and
...
APPLY servers.
| Section |
|---|
| Column | ||
|---|---|---|
| ||
|
| width | 95% |
|---|
| bgColor | CCC |
|---|
$ ./dbvrep --ddcfile LINAORCL-MINE.ddc support package MINE
Initializing.....done
DDC loaded from database (124 variables).
Dbvisit Replicate version2.0.01.740
Copyright (C) Avisit Solutions Limited and Dbvisit Software Limited. All
rights
reserved.DDC file LINA.ddc loaded.Packaging into ZIP file:
dbvisit_support_dbvrep_MINE.7IPy.zipfor
for process MINE, addinfo []
Trying retrieving +DATA/src/onlinelog/group_1.276.748600819 from ASM.
If this fails, restart with NOASM added to the SUPPORT command.
Packaging data from database. If this fails, restart SUPPORT PACKAGE with NODB option.
====> If instructed by support, run as SYSDBA the script get_logtrace.jTZ4.sql
and upload the generated tracefile (script will show the name) to Dbvisit Support as well.
The created file includes the process name and a unique identifier, so multiple runs of the packaging command won't overwrite past zip files.
The command can take further arguments, forcing it to skip some files – use it only if packaging otherwise fails.
Creating support package from command console
The support package command can also be run from the Command Console:
For MINE, ensure the command console is run from the MINE server so that the MINE logs and PLOGs can be found:
| No Format | ||
|---|---|---|
| ||
dbvrep> support package MINE
Packaging into ZIP file: ./dbvisit_support_dbvrep_d112f_mine.PNR_.zip for process mine, addinfo []
Packaging data from database. If this fails, restart SUPPORT PACKAGE with NODB option.
====> If instructed by support, run as SYSDBA the script get_logtrace.jsKz.sql and upload the generated tracefile (script will show the name) to Dbvisit Support as well. |
| Note | ||
|---|---|---|
Use the --nocheckdb option for creating a support package if creating the support package fails to connect to either the Mine or Apply database
|
For APPLY, ensure the command console is run from the APPLY server so that the APPLY logs and PLOGs can be found:
| No Format | ||
|---|---|---|
| ||
dbvrep> support package APPLY
Packaging into ZIP file: ./dbvisit_support_dbvrep_d112f_apply.z9sJ.zip for process apply, addinfo []
Failed to open logfile /home/oracle/d112f/log/dbvrep_APPLY_d112f.log
Packaging data from database. If this fails, restart SUPPORT PACKAGE with NODB option.
====> If instructed by support, run as SYSDBA the script get_logtrace.jsKz.sql and upload the generated tracefile (script will show the name) to Dbvisit Support as well. |
Or the command support package can be created with one command:
| No Format | ||
|---|---|---|
| ||
$ dbvrep --ddcfile ORCL-APPLY.ddc support package APPLY |
| Note | ||
|---|---|---|
Use the --nocheckdb option for creating a support package if creating the support package fails to connect to either the Mine or Apply database
|
2-way replication
For 2-way replication 4 support packages can be created (MINE, APPLY, MINE1, APPLY1).
On the source server:
| No Format | ||
|---|---|---|
| ||
dbvrep --ddcfile ORCL-MINE.ddc support package MINE
dbvrep --ddcfile ORCL-APPLY1.ddc support package APPLY1 |
On the target server:
| No Format | ||
|---|---|---|
| ||
dbvrep --ddcfile ORCL-MINE1.ddc support package MINE1
dbvrep --ddcfile ORCL-APPLY.ddc support package APPLY |