Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Contacting The proper way to contacting Dbvisit Support is via the servicedesk: http://support.dbvisit.com

We request that you only log one ticket per issue.
You may also want to check  the  Dbvisit Replicate knowledge base first if it is a question and not an error.

Dbvisit Support is the single point of contact for all Dbvisit products. To help collect all the information needed by the support team, Dbvisit Replicate contains a built-in trace file packaging facility. This will typically be the first item that a Dbvisit support technician will ask for. Use the command SUPPORT PACKAGE process_type to create a zip file containing the files for the specified process, running this command in turn on fetcherFETCHER, mine MINE and apply servers.

No Format
bgColorCCC
$ dbvrep --ddcfile ORCL-MINE.ddc support package MINE
Initializing.....done
DDC loaded from database (124 variables).
Dbvisit Replicate version 
DDC file LINA.ddc loaded.
Packaging into ZIP file: dbvisit_support_dbvrep_MINE.7IPy.zip 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
bgColorCCC
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.

 

For APPLY, ensure the command console is run from the Apply server so that the Apply logs and plogs can be found:

No Format
bgColorCCC
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
bgColorCCC
$ dbvrep --ddcfile ORCL-APPLY.ddc support package APPLY

 

2-way replication

For 2-way replication 4 support packages can be created (MINE, APPLY, MINE1, APPLY1).

On the source server:

No Format
bgColorCCC
dbvrep --ddcfile ORCL-MINE.ddc support package MINE
dbvrep --ddcfile ORCL-APPLY1.ddc support package APPLY1

 

On the target server:

...

bgColorCCC

...

APPLY servers.  More details on support packages can be found here:  Creating Support packages