...
Variable | Variable Description |
---|---|
CSD_PREFLIGHT_CHECK | If set to Y, Dbvisit will create a standby spfile and attempt to start up the standby instance prior to backing up the primary database, when creating the standby database. Dbvisit will report any invalid standby database parameters, and any errors can be fixed straight away. Default value Y (YES) highly recommended
|
DBV_POST_PROC | If a different named script should be called, then this variable can be set. If no path name is given the Dbvisit Standby install directory is assumed. Default value Windows: dbv_post_processing.cmd Default value Non Windows: dbv_post_processing.sh See the Pre- and post-processing section for more information. Example: DBV_POST_PROC = post_procs_all.cmd
|
DBV_PRE_POST_PROC | The name of the pre- and post- processing script. If a different named script should be called, then this variable can be set. If no path name is given the Dbvisit Standby install directory is assumed. Default value Windows: dbv_pre_post_processing.cmd Default value Non Windows: dbv_pre_post_processing.sh See the Pre- and post-processing section for more information. Example: DBV_PRE_POST_PROC = rman_backup.cmd
|
DBV_PRE_PROC | The name of the pre-processing script. If a different named script should be called, then this variable can be set. If no path name is given the Dbvisit Standby install directory is assumed. Default value Windows: dbv_pre_processing.cmd Default value Non Windows: dbv_pre_processing.sh See the Pre- and post-processing section for more information. Example: DBV_PRE_PROC = rman_backup.cmd
|
ORACLE_HOME_ASM | Default: ORACLE_SID_ASM = +ASM
|
ORACLE_SID_ASM | The ASM instance name and the ORACLE_HOME for the ASM instance name.
|
SSH_SKIP_OUTPUT | If the ssh connection contains an ssh banner, then Dbvisit Standby will not be able to interpret the data correctly. This setting can be used to tell Dbvisit Standby to ignore the ssh banner. For example if the ssh banner is as follows: *************************************************************************** It is for authorized use only. Users (authorized or unauthorized) Then the following can be set to ignore this: Example: SSH_SKIP_OUTPUT=*** This will skip the output lines beginning with *** and ending with ***
|
SSH_SKIP_OUTPUT_LINES | By setting this parameter to a number value, that number of lines will be ignored during ssh connections. Example: If your ssh banner is 5 lines, you can specify: SSH_SKIP_OUTPUT_LINES=5
The first 5 lines of ssh output (which will include the banner) will be skipped.
|
STANDBY_ARCHIVELOG_NAME_EXTENSION | Filename extension for archive logs transferred to the standby. Default .arc Dbvisit uses name convention %t_%s[_%r]STANDBY_ARCHIVELOG_NAME_EXTENSION, for example: 1_120_123456.arc Example: STANDBY_ARCHIVELOG_NAME_EXTENSION = .log
|
USE_ARCHTMP_TO_COMPRESS | Note: This parameter applies to environments where ASM storage is NOT used for the Oracle Archive Destination (or recovery area) Default value N (NO) If this value is set to Y (Yes) Dbvisit Standby will compress the archive logs in ARCHTMP instead of the default location where the archive logs are stored (Oracle Archive Destination / Oracle Recovery Area). This parameter is especially useful and recommended to be set when Multiple Standby Databases are used, or when RMAN backup is scheduled on the primary
|
WIN_SERVICE_WAIT | How long in seconds to wait for the Windows Oracle service to start or stop before starting or stopping the database. Default value: 10 Example: WIN_SERVICE_WAIT=10
|
LOG, TRACE and TMP Directory Locations
Note |
---|
Even though these parameters are available, the default locations should be sufficient for most environments. If the parameters are not set in the DDC file, the default locations will be used. |
The following parameters are specific to the Dbvisit Standby LOG, TRACE and TMP Directory Locations.
In some cases it might be required to move the default LOG, TRACE and TMP locations for the Dbvisit Standby log, trace and temp files.
The default location should be sufficient for most environments, but if you do want to move these directories to a different location, you can use the LOGDIR, TRCDIR and TMPDIR directory parameters in the DDC file.
There are also standby equivalent parameters with the _DR at the end (LOGDIR_DR, TRCDIR_DR and TMPDIR_DR).
The following parameters can be set in the DDC file to overwrite the default locations of these directories inside DBVISIT_BASE/standby:
No Format |
---|
LOGDIR=/your_primary_log_dir_location
TRCDIR=/your_primary_trace_dir_location
TMPDIR=/your_primary_temp_dir_location
LOGDIR_DR=/your_standby_server_log_location
TRCDIR_DR=/your_standby_server_trace_location
TMPDIR_DR=/your_standby_server_temp_location |