Creating Support packages

Support packages can be created automatically by the process or the user can create the support package. There are two separate ways to create support packages.  The result is the same.  The name of the file will be dbvisit_support_dbvrep_<process_type>.unique_id.zip.  
 

Creating the MINE support package from command line.

You will run the dbvrep executable and point it to the correct ddcfile while running the command as shown below.

$ dbvrep --ddcfile ORCL-MINE.ddc support package MINE
Initializing.....done
DDC loaded from database (124 variables).
Dbvisit Replicate version 
DDC file ORCL-MINE.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 MINE support package from dbvrep 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:

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.

Use the NODB option for creating a support package if creating the support package fails to connect to either the Mine or Apply database

dbvrep> support package MINE NODB

On the Windows operating system, the default location for the support package is in start folder of the application, when start-console is run as a Windows Administrator the default folder will be %WINDOWS%\System32. This is feature of Windows not Dbvisit Replicate.

Creating the APPLY support package from command line.

You will run the dbvrep executable and point it to the correct ddcfile while running the command as shown below. 

$ dbvrep --ddcfile ORCL-APPLY.ddc support package APPLY

Use the NODB option for creating a support package if creating the support package fails to connect to either the Mine or Apply database

dbvrep> support package APPLY NODB

Creating the APPLY support package from dbvrep console

For APPLY, ensure the command console is run from the APPLY server so that the APPLY logs and PLOGs can be found.  If you run the support package from the SOURCE server (where most people typically run dbvrep) it will NOT include the log file and the PLOG.  Please get the log file and the PLOG from the target server.
Or you can install the ./start_console.sh script on the target server, run the dbvrep console from there as show below.

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.

 

2-way replication

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

On the source server:

dbvrep --ddcfile ORCL-MINE.ddc support package MINE
dbvrep --ddcfile ORCL-APPLY1.ddc support package APPLY1

 

On the target server:

dbvrep --ddcfile ORCL-MINE1.ddc support package MINE1
dbvrep --ddcfile ORCL-APPLY.ddc support package APPLY