Once the Dbvisit Standby software is installed, Dbvisit Standby can be configured (or setup) for a specific database and the standby database can be created.
Dbvisit Standby can be configured and run through a command line interface (CLI) or a web-based interface (GUI). The CLI commands are indicated with a "
" and the web based or GUI commands are indicated with a "
"
Dbvisit Standby is configured for each database using a menu based, command line, setup utility. This utility is called dbvisit_setup 
The following applies to configuring Dbvisit Standby for a specific database:
- dbvisit_setup only needs to be run on the primary server. Not on the standby server.
- Dbvisit Standby will as much as possible determine the values for you. The default values will be shown in square brackets [ ]. If the default value is acceptable, nothing needs to be entered, just press return.
- After each entered variable, a confirmation will be given to ensure it is correctly entered.
- At the end of the setup process, an overview will be given for all variables entered, and any variable entered incorrectly can be altered.
Dbvisit Standby is configured for each database using a web-based menu. Specify the address of the primary server in the URL with the correct port (default 8081).
The following applies to configuring Dbvisit Standby GUI for a specific database:
1.Login to the Dbvisit Standby GUI interface by specifying the user name and password (default is admin/admin)
2.Choose Setup from the main menu.
3.Choose New Dbvisit Setup from the sub menu.
4.Setup only needs to be run on the primary server. Not on the standby server.
Configuration Outcome
The results of configuring Dbvisit Standby for a specific database are:
- The Dbvisit Standby Database Configuration (DDC) file is created. This is a text file equivalent to the init.ora and contains all the settings to enable Dbvisit Standby to keep the standby database up to date.
- Optionally, the Dbvisit Standby Archive log Management Module (AMM) is configured. The settings for AMM are also contained in the DDC file.
- The Dbvisit Standby Database Repository (DDR) is created. This is a small repository created in the database to keep track of Dbvisit Standby processing.
RAC environment setup
In an Oracle RAC environment, dbvisit_setup is run on every primary node of the Oracle RAC cluster.
However during dbvisit_setup:
- Choose option 1a in the main dbvisit_setup menu.
- Choose the name of the instance as the ORACLE_SID and not the database name.
Please ensure the following prerequisites are met for RAC:
- The archive destination for the primary RAC nodes must a shared location that is accessible by all primary RAC nodes.
- If the standby is also a RAC cluster, then the archive destination location on the standby node must be accessible by all standby nodes in the RAC cluster.
- Choose the same ARCHDEST destination where Dbvisit Standby will transfer the (archive) log files to on standby server when running dbvisit_setup for all primary RAC nodes.
- The Dbvisit Standby Database Configuration file (DDC), created during the setup, on each node will have the (name of the instance and not the database (dbv_oracle_instance.env). If the database is called RACDB and has the following instances RACDB1 and RACDB2, the Dbvisit Standby Database Configuration files (DDC) will be called:
dbv_RACDB1.env
dbv_RACBD2.env
Dbvisit Standby needs to be scheduled separately on each node. The name of the instance is used when installing and running Dbvisit Standby, not the name of the database. Example, to run Dbvisit Standby on one of the primary nodes:
dbvisit RACDB1
- With a single instance standby database, Dbvisit Standby is scheduled on the standby server using the instance name from one of the primary nodes. Example if the RAC configuration has 2 instances called RACDB1 and RACDB2 and the standby database is called RACDB, then Dbvisit Standby is executed on the standby server using the command: dbvisit RACDB1
Primary server (or primary RAC node) setup for CLI
Starting dbvisit_setup
1. Start the Dbvisit Standby command console from the Start Menu > Programs > Dbvisit > Standby. Note: this step is not necessary if dbvisit_setup is started as part of the initial Dbvisit Standby installation.
C:\Program Files\Dbvisit> dbvisit_setup
3. Confirm that this is the primary server.
=>dbvisit_setup only needs to be run on the primary server.
Is this the primary server? <Yes/No> [Yes]:
4. For a new database setup choose option 1: (for RAC choose option 1a)
=========================================================
Dbvisit Standby Database technology
http://www.dbvisit.com
Dbvisit Database setup
Default values will be shown in []
Options:
1) New Database setup (combines options 2,3,4)
1a) New RAC Instance setup (combines options 2,3,4)
2) New Dbvisit Database configuration (DDC) file setup
3) New Dbvisit Archive Management Module (AMM) setup
4) New Dbvisit Database repository (DDR) setup
5) Manage Dbvisit Database repository (DDR)
6) Update Dbvisit Database configuration (DDC) file
7) Create Standby Database
9) Uninstall Dbvisit Database repository (DDR)
E) Exit
=========================================================
Please enter choice : 1
5.The Dbvisit Standby setup will begin. It is recommended to do a quick setup. Only the settings for the quick setup will be shown here. Dbvisit Standby will choose defaults for the settings that are not displayed. At the end of the setup all settings will be displayed for review.
Would you like to do a quick setup?=>Accept Defaults
Or would you like Dbvisit to prompt you for all settings and suggest defaults?
Values are Yes or No
Yes = Quick setup (let Dbvisit choose defaults for settings that are not displayed).
No = Dbvisit will prompt for all settings and suggest defaults.
All settings will be displayed at the end of the configuration for review.
Quick setup? [Yes]:
=>Dbvisit will do a quick setup: Yes
Is this correct? <Yes/No> [Yes]:
RAC configuration only
The following will be displayed only if a RAC setup is chosen.
6. Specify if this is the first node that Dbvisit Standby is configured for. Only on the first node will the Dbvisit Standby Database Repository (DDR) be created as this repository is shared by all instances.
Please specify if this is the first RAC node in the Dbvisit configuration or not.
Values are Yes or No
Yes = First RAC node that Dbvisit is configured for.
No = Dbvisit has been already configured on another node in this RAC configuration.
First Dbvisit RAC node?
Is this correct? <Yes/No> [Yes]:
End RAC configuration only
7.Temporary directory. Dbvisit Standby needs to know the temporary directory that it can use for temporary and trace files.
=========================================================
Dbvisit setup begins.
=========================================================
-----------------------------------------------------------------------------------------------------------------
=>TMP
Please enter temporary directory for Dbvisit to use.
This directory is used to hold the Dbvisit temporary and trace files.
This directory must exist on the primary and standby servers.
Dbvisit Temporary directory is [C:\windows\temp]:
=>Dbvisit Temporary directory will be: C:\windows\temp
Is this correct? <Yes/No> [Yes]:
8. Path. Dbvisit Standby will suggest the default environment path. The path to the cmd.exe command and other Windows utilities is required.
=>PATH
Please set the environment PATH for Dbvisit to use.
Do not include the ORACLE_HOME in the path.
Dbvisit PATH is [C:\WINDOWS;C:\WINDOWS\system32]:
=>PATH will be: C:\WINDOWS;C:\WINDOWS\system32
Is this correct? <Yes/No> [Yes]:
9. Database or instance. Please choose the database (or instance for RAC) for which you want to configure Dbvisit Standby. If the database or instance that you want to configure Dbvisit Standby for is not displayed, please enter your own ORACLE_SID and ORACLE_HOME.
Please specify for which Oracle database you would like to configure Dbvisit.
The following Oracle database(s) have been found on this server:
SID ORACLE_HOME
=== ===========
1) w920n C:\oracle\product\9.2.1
2) w102n C:\oracle\product\10.2.0\db_1
3) Enter own ORACLE_SID and ORACLE_HOME
Please enter choice : 2
Is this correct? <Yes/No> [Yes]:
10. Owner. Enter the account with which Dbvisit Standby will be run. This is the Windows account name. This account must be part of the Oracle DBA group and have sufficient privileges to log onto the database as sysdba. We suggest that this user is the same user that installed the Oracle software and owns the databases.
=>OWNER
Please enter the account owner that will be used to run Dbvisit.
It is recommended that this be the same user as the Oracle Database owner.
This user should belong to a DBA group.
This user must also exist on the standby database server.
Account that will run Dbvisit is [oracle]:
=>Account owner will be: oracle
Is this correct? <Yes/No> [Yes]:
11. Transfer method. This is used to securely transfer the logs from the primary server to the standby server. Dbvisit Standby comes bundled with Bitvise Tunnelier (www.bitvise.com) as the default secure transfer method. Choose option 1 to select Bitvise Tunnelier scp.
=>CP (copy or transfer method)
Dbvisit comes pre-installed with Bitvise Tunnelier scp as the secure transfer (copy) method.
If this secure transfer method is not acceptable, please enter alternative method (this must also exist on the standby server).
The following methods have been found on this server:
1) C:\Program Files\Bitvise Tunnelier\sftpc.exe
2) Enter own method
Please enter choice : 1
12. Secure remote shell method. This is used to manage the transfer from the primary server to the standby server. Dbvisit Standby comes bundled with Bitvise Tunnelier (www.bitvise.com) as the default secure shell method. Choose option 1 to select Bitvise Tunnelier sexec.
=>RSH (remote shell method)
Dbvisit comes pre-installed with Bitvise Tunnelier sexec as the secure shell method (ssh).
If this secure shell method is not acceptable, please enter alternative ssh method (this must also exist on the standby server).
The following methods have been found on this server:
1) C:\Program Files\Bitvise Tunnelier\sexec.exe
2) Enter own method
Please enter choice : 1
13. Compress method. This determines if the (archive) log files will be compressed before transferring to the standby server and how they are compressed.
The following options are available:
- Dbvisit Standby internal compression. This uses the zlib compression library. Dbvisit Standby will compress the archives on disk first before transferring to the standby server. This will leave the files on the server in a compressed state.
- SSH compression. This uses the zlib compression library to compress the files as they are being transferred to the standby server. This option is only available if SSH (secure shell) is being used for the transfer method. This will leave the files uncompressed on the server.
- No compression. This turns compression off. Use this option if the network speed is sufficiently fast to transfer uncompressed (archive) log files and disk space is sufficient to hold uncompressed files.
If you are unsure, choose "Dbvisit internal compression".
=>COMPRESS
Please enter compression method.
It is recommended to disable any other compression routines used to compress the Oracle (archive) log files for this database.
If you are unsure, choose option 1.
The following compression methods are available:
1) Dbvisit internal compression (files will be left compressed on server)
2) SSH compression (files will not be left compressed on server)
3) No compression
Please enter choice :
14. Source. This is the name of the current primary server.
=>SOURCE
Please enter primary server [win2003se-01]
Primary server is [win2003se-01]:
=>Primary server will be: win2003se-01
Is this correct? <Yes/No> [Yes]:
15. Enter the Oracle Base location (optional). The ORACLE_BASE is only used by Dbvisit Standby during setup to determine the location of the admin directories of the database.
=>ORACLE_BASE
Please enter ORACLE_BASE directory.
ORACLE_BASE is the admin directory for the Databases.
Dbvisit does not use the ORACLE_BASE directly, but it is useful for determining
where the log directory of Dbvisit should be.
Entering an ORACLE_BASE is optional.
ORACLE_BASE is [c:\oracle\orabase]:
=>ORACLE_BASE will be: c:\oracle\orabase
Is this correct? <Yes/No> [Yes]:
16. Enter the log directory for Dbvisit Standby. The default will be under the ORACLE_BASE/admin/ORACLE_SID structure. The default log directory under this structure will be called dbvisit. If this directory does not exist then it will be created.
=>LOGDIR
Please enter log directory for dbvisit.
This is the directory where the log file for dbvisit will be kept.
Dbvisit will attempt to create this directory first time it executes if it does
not exist.
Dbvisit log dir is [C:\oracle\product\10.2.0\admin\w102n\dbvisit]:
=>Dbvisit log dir will be: C:\oracle\product\10.2.0\admin\w102n\dbvisit
Is this correct? <Yes/No> [Yes]:
17. Enter the Oracle database user (or schema) that will own the Dbvisit Standby database repository (DDR) in the database. This Oracle user will be created in the database. Also enter the password for this user. This Oracle user will be given specific privileges it requires to perform the Dbvisit Standby tasks.
=>DBUSER
Please enter the Oracle database user that will be used to log onto the
database w102n.
This user will also own the Dbvisit Database repository (DDR) [dbvisit].
(This user will be created as part of this setup/configuration).
Dbvisit Oracle user is [dbvisit]:
=>Dbvisit Oracle user will be: dbvisit
Is this correct? <Yes/No> [Yes]:
RAC configuration only
The following will be displayed only if a RAC configuration is chosen.
18. Specify the instance name that Dbvisit Standby processing should take over if that instance is unavailable. The instance name must be different to the current instance name.
=>RAC_TAKEOVER_SID
Specify the instance name that Dbvisit processing should take over if that instance is unavailable.
The instance name must be different to the current instance name (RACDB1).
The standby database may not be kept up to date if an instance is not available
and Dbvisit processing is not taken over by another instance.
RAC Takeover SID is []: RACDB2
=>RAC Takeover SID will be: RACDB2
Is this correct? <Yes/No> [Yes]:
End RAC configuration only
Standby Server setup
All information for the primary server has now been collected. Please enter setup information for the standby server. Note that values entered during setup cannot be verified on the standby server. Please ensure they are correct.
19. Enter the name of the standby server.
=>DESTINATION
Please enter name of standby server.
(Primary server is win2003se-01)
Standby server is []: win2003se-02
=>Standby server will be: win2003se-02
Is this correct? <Yes/No> [Yes]:
20. Enter the ORACLE_SID on the standby server. This can be different to the ORACLE_SID on the primary server. The default is the same as the ORACLE_SID on the primary server. The ORACLE_SID must exist on the standby server.
=>ORACLE_SID_DEST
If the ORACLE_SID on the standby server win2003se-02 is different than the
ORACLE_SID on the primary server, then it can be specified here.
Default is the same as ORACLE_SID: [w102n]
Please enter database on standby server win2003se-02.
Oracle database on standby server is [w102n]:
=>Oracle database on standby server will be: w102n
Is this correct? <Yes/No> [Yes]:
21. Enter the ORACLE_BASE directory on the standby server.
=>ORACLE_BASE_DR
Please enter ORACLE_BASE directory for the standby server win2003se-02.
ORACLE_BASE is the admin directory for the Databases.
Dbvisit does not use the ORACLE_BASE directly, but it is useful for determining
where the log directory of Dbvisit should be on the standby server.
Entering an ORACLE_BASE for the standby server is optional.
ORACLE_BASE for standby server is [c:\oracle\orabase]:
=>ORACLE_BASE for standby server will be: c:\oracle\orabase
Is this correct? <Yes/No> [Yes]:
22. Enter the directory where the Dbvisit Standby software is installed on the standby server. Normally, this is the same as on the primary server.
=>BINDIR_DR
Please enter the directory for the dbvisit installation location on the standby
server.
This is the directory where the Dbvisit executables will be kept.
This directory must exist on the standby server.
Default location is the same as the on the primary server.
Dbvisit installation dir on the standby server is [C:/Program Files/Dbvisit]:
=>Dbvisit installation dir on the standby server will be: C:/Program
Files/Dbvisit
Is this correct? <Yes/No> [Yes]:
23. Enter the directory where the archives should go to on the standby server. Note: this may be different to the log_archive_dest parameter. In a RACenvironment, this location must be shared by all standby nodes.
=>ARCHDEST
Please enter the directory where Dbvisit will transfer the (archive) log files to on standby server win2003se-02.
This directory should ONLY contain (archive) log files related to this database. It should not contain any other (non archive log) files.
Please ensure that this directory exists on win2003se-02 as this cannot be verified.
It is advisable to also create this directory on the primary server win2003se-01 for graceful switchover to work.
Archive log dir on the standby server is [C:\oracle\oraarch\w102n]:
=>Archive log dir on the standby server will be: C:\oracle\oraarch\w102n
Is this correct? <Yes/No> [Yes]:
24. Enter the number of times that Dbvisit Standby should attempt to apply a missing archive before raising an alert. Every configuration may be different, but a good starting point number is 4. This variable sets the alerting threshold.
=>MAX_TIMES_TRIED
Please specify the number of times that Dbvisit should attempt to apply the missing log file before raising an error.
Note this number is also used to raise an error if the Dbvisit cannot be started because a previous scheduled Dbvisit is still running.
Ensure that this number is not too low and not too high.
If you are not sure, set to 4
Maximum attempts before raising error when log file is not there is 4
=>Maximum attempts before raising error when log file is not there will be: 4
Is this correct? <Yes/No> [Yes]:
E-Mail setup
Dbvisit Standby uses email to send notifications. These notifications can be information messages or error messages. Dbvisit Standby comes with a default internal mail client.
25. Enter the mail client. Default is to use the Dbvisit Standby internal mail client.
=>MAILCFG_MAIL_CLIENT
Please enter mail client. Default is to use internal Dbvisit mail client.
Other mail client can be specified. Example: mail, sendmail or javamail.
Full path of mail client must be given.
Mail client is [Dbvisit]:
=>Mail client will be: Dbvisit
Is this correct? <Yes/No> [Yes]:
26. Enter the email address that will receive the emails from Dbvisit Standby. Multiple email addresses can be specified.
=>ADMINS
Please enter the administrator email address(es) who will be emailed upon success or failure of the Dbvisit. Multiple emails should be separated with a comma (,).
Sample:
support@mycompnay.com,dba@mycompany.com
Administrators email is [oracle@win2003se-01]: support@mycompany.com
=>Administrators email will be: support@mycompany.com
Is this correct? <Yes/No> [Yes]:
27. Specify the FROM email address that will be used to identify the sender of the email from the primaryserver.
=>MAILCFG_FROM
Please enter the FROM mail address of this server (optional).
if this is not specified, the emails may not arrive.
Mail FROM address is [oracle@win2003se-01.com]: oracle@win2003se-01.com
=>Mail FROM address will be:oracle@win2003se-01.com
Is this correct? <Yes/No> [Yes]
28. Specify the FROM email address that will be used to identify the sender of the email from the standbyserver.
=>MAILCFG_FROM_DR
Please enter the FROM mail address of the standby server (optional).
If this is not specified, the emails may not arrive.
Mail FROM_DR address is [oracle@win2003se-01.com]:
=>Mail FROM_DR address will be:oracle@win2003se-01.com
Is this correct? <Yes/No> [Yes]:
29. Specify the SMTP server to send the email to.
=>MAILCFG_SMTP_SERVER
Please enter the smtp mail server to send the email to.
Sample:
- mail.<your company name>.com
- smtp.<your company name>.com
SMTP server is [mail.yourdomain.com]: mail.<your company name>.com
=>SMTP server will be: mail.<your company name>.com
Is this correct? <Yes/No> [Yes]:
30. Specify the optional SMTP server for the standby server. This is only required if the smtp mail server for the standby server differs from the main smtp mail server.
=>MAILCFG_SMTP_SERVER_DR
Optional smtp mail server for the standby server.
Only used if smtp mail server for the standby server differs from the main smtp mail server (MAILCFG_SMTP_SERVER).
Sample:
- mail.<your company name>.com
- smtp.<your company name>.com
SMTP mail server for standby server is (optional) []:
=>SMTP mail server for standby server will be:
Is this correct? <Yes/No> [Yes]:
Dbvisit Standby Archive log Management Module (AMM) setup
The Dbvisit Standby Archive log Management Module fully automates the management and monitoring of the Oracle archive log space on either the primary, standby, or both servers. Please see the Dbvisit Standby Archive log Management Module (AMM)section for more information.
AMM primary server setup
31. Specify if you want to setup AMM on the primary server.
=========================================================
Primary Archive log Management Module Settings (AMM)
=========================================================
=>ARCHSOURCE_MANAGEMENT
Do you want to setup (archive) log file management on the primary server?
This is used to manage the Oracle logs on the primary server.
- Alerts when certain thresholds have been reached.
- Can delete Oracle archives logs after a set number of days.
- Can keep a constant number of Oracle archive logs on the system.
Values are Yes or no
Yes = Setup and use AMM on primary server.
No = do not use AMM on primary server.
If you are not sure, set to Yes.
Should Dbvisit Archive Log Management Module be used on primary server? [Yes]:
=>Dbvisit Archive Log Management Module on primary server will used: Yes
Is this correct? <Yes/No> [Yes]:
32. Specify the number of days to keep the Oracle (archive) log files on disk. After this period they will be removed. To disable this setting, set to 0.
=>DAYS_TO_KEEP_ARCHSOURCE
Please specify the number of days you want to keep the Oracle log files on the primary server?
After this the log files will be removed from the server.
To disable this setting, set to 0.
If you are not sure, set to 7
Number of days to keep log files on disk is [7]:
=>Number of days to keep log files on disk will be: 7
Is this correct? <Yes/No> [Yes]:
33. Specify the number of (archive) log files to keep on the server. Log files greater than this number will be removed (oldest first). To disable this setting, set to 0.
=>NUM_ARCHSOURCE_TO_KEEP
Please specify the number of Archive log files to keep on the primary server?
Log files greater than this number will be removed (oldest first).
To disable this setting, set to 0.
If you are not sure, set to 0 (disable).
Number of log files to keep on disk is [0]:
=>Number of log files to keep on disk will be: 0
Is this correct? <Yes/No> [Yes]:
34. Specify the threshold in a percentage of how much disk space may be used up by the (archive) log files before raising an alert.
=>THRESHOLD_ARCHSOURCE
Please specify the threshold in percentage (%) of how much disk space may be
taken up by the Oracle log files on disk before an alert is triggered on the
primary server.
80 means at 80% disk space full an alert will be triggered.
Please specify threshold as an integer.
If you are not sure, set to 80.
Threshold for log file management is [80]:
=>Threshold for log file management will be: 80
Is this correct? <Yes/No> [Yes]:
35. Specify if (archive) log files should be deleted once the threshold on the primary server is reached.
=>DELETE_ARCHSOURCE
Please specify if (archive) log files should be deleted once the threshold (THRESHOLD_ARCHSOURCE) on the primary server is reached.
Once the percentage threshold is reached oldest (archive) log files are deleted first.
The log files WILL have been transferred to the standby server.
(There is no verification that these log files have been backed up).
Values are Yes or No
Yes = Let Dbvisit delete (archive) log files once percentage threshold is met.
No = Dbvisit will only alert once percentage threshold (no log files will be deleted).
If you are not sure, set to No.
Should Dbvisit Archive Log Management Module delete log files once percentage threshold is met? [No]:
=> Dbvisit Archive Log Management Module will delete log files once percentage threshold is met: No
Is this correct? <Yes/No> [Yes]:
AMM standby server setup
36. Specify if you want to setup AMM on the standby server.
=========================================================
Standby Archive log Management Module Settings (AMM)
=========================================================
=>ARCHDEST_MANAGEMENT
Do you want to setup (archive) log file management on the standby server?
This is used to manage the Oracle logs on the standby server.
- Alerts when certain thresholds have been reached.
- Can delete Oracle archives logs after a set number of days.
- Can keep a constant number of Oracle archive logs on the system.
Values are Yes or no
Yes = Setup and use AMM on standby server.
No = do not use AMM on standby server.
If you are not sure, set to Yes.
Should Dbvisit Archive Log Management Module be used on standby server? [Yes]:
=>Dbvisit Archive Log Management Module on standby server will used: Yes
Is this correct? <Yes/No> [Yes]:
37. Specify the number of days to keep the Oracle (archive) log files on disk. After this period they will be removed. To disable this setting, set to 0.
=>DAYS_TO_KEEP_ARCHDEST
Please specify the number of days you want to keep the Oracle log files on the
standby server?
After this the log files will be removed from the server.
To disable this setting, set to 0.
If you are not sure, set to 7
Number of days to keep log files on disk is [7]:
=>Number of days to keep log files on disk will be: 7
Is this correct? <Yes/No> [Yes]:
38. Specify the number of (archive) log files to keep on the server. Log files greater than this number will be removed (oldest first). To disable this setting, set to 0.
=>NUM_ARCHDEST_TO_KEEP
Please specify the number of Archive log files to keep on the standby server?
Log files greater than this number will be removed (oldest first).
To disable this setting, set to 0.
If you are not sure, set to 0 (disable).
Number of log files to keep on disk is [0]:
=>Number of log files to keep on disk will be: 0
Is this correct? <Yes/No> [Yes]:
39. Specify the threshold in a percentage of how much disk space may be used up by the (archive) log files before raising an alert.
=>THRESHOLD_ARCHDEST
Please specify the threshold in percentage (%) of how much disk space may be
taken up by the Oracle log files on disk before an alert is triggered on the standby server.
80 means at 80% disk space full an alert will be triggered.
Please specify threshold as an integer.
If you are not sure, set to 80.
Threshold for log file management is [80]:
=>Threshold for log file management will be: 80
Is this correct? <Yes/No> [Yes]:
40. Specify if (archive) log files should be deleted once the threshold on the primary server is reached.
=>DELETE_ARCHDEST
Please specify if (archive) log files should be deleted once the threshold (THRESHOLD_ARCHDEST) on the standby server is reached.
Once the percentage threshold is reached oldest (archive) log files are deleted first.
The log files WILL have been applied to the standby database.
(There is no verification that these log files have been backed up).
Values are Yes or No
Yes = Let Dbvisit delete (archive) log files once percentage threshold is met.
No = Dbvisit will only alert once percentage threshold (no log files will be deleted).
Should Dbvisit Archive Log Management Module delete log files once percentage threshold is met? [No]:
=> Dbvisit Archive Log Management Module will delete log files once percentage threshold is met: No
Is this correct? <Yes/No> [Yes]:
Review settings
The main setup for the database is now complete. All settings will be shown, not just the quick settings shown above.
If any changes are required, then this can be done now.
Would you like to review all the variables? <Yes/No> [Yes]:
=====10 Generic Settings=====
1) TMP=C:\windows\temp
2) PATH=C:\WINDOWS;C:\WINDOWS\system32
3) ORACLE_SID=w102n
4) ORACLE_HOME=C:\oracle\product\10.2.0\db_1
5) OWNER=oracle
6) CP=C:\Program Files\Bitvise Tunnelier\sftpc.exe
7) RSH=C:\Program Files\Bitvise Tunnelier\sexec.exe
8) COMPRESS=dbvisit
9) UNCOMPRESS=dbvisit
10) ZIP_EXTENSION=.gz
11) SEND_HEARTBEAT_TIME24=0700
=====15 RAC Settings=====
12) RAC=N
=====20 Primary Server Settings=====
13) SOURCE=win2003se-01
14) ORACLE_BASE=c:\oracle\orabase
15) LOGDIR=C:\oracle\product\10.2.0\admin\w102n\dbvisit
Are these variables correct? <Yes/No> [Yes]:
=====20 Primary Server Settings=====
16) DBUSER=dbvisit
17) DBPASSWD=dbvisitpasswd
18) LEAVE_COMPRESS_SOURCE=Yes
19) SYNCH_DBVISIT_INSTALL=Yes
20) LOGSWITCH=No
=====30 Standby Server Settings=====
21) DESTINATION=win2003se-02
22) ORACLE_SID_DEST=w102n
23) ORACLE_BASE_DR=c:\oracle\orabase
24) BINDIR_DR=C:/Program Files/Dbvisit
25) LOGDIR_DR=C:\oracle\product\10.2.0\admin\w102n\dbvisit
26) ARCHDEST=C:\oracle\oraarch\w102n
27) LEAVE_COMPRESS_DEST=Yes
28) MAX_TIMES_TRIED=4
29) ADD_DATAFILE=Yes
=====40 Mail Settings=====
30) MAILCFG_MAIL_CLIENT=Dbvisit
31) ADMINS=support@mycompany.com
=====40 Mail Settings=====
32) MAILCFG FROM=oracle@win2003se-01.com
33) MAILCFG_FROM_DR=oracle@win2003se-02.com
34) SUCCESSMAIL=Yes
35) MAILCFG_SMTP_SERVER=mail.<your company name>.com
=====50 Primary Archive Log Management Settings=====
36) ARCHSOURCE_MANAGEMENT=Yes
37) DAYS_TO_KEEP_ARCHSOURCE=7
38) NUM_ARCHSOURCE_TO_KEEP=0
39) THRESHOLD_ARCHSOURCE=80
40) DELETE_ARCHSOURCE=No
=====60 Standby Archive Log Management Settings=====
41) ARCHDEST_MANAGEMENT=Yes
42) DAYS_TO_KEEP_ARCHDEST=7
43) NUM_ARCHDEST_TO_KEEP=0
44) THRESHOLD_ARCHDEST=80
45) DELETE_ARCHDEST=No
Dbvisit Standby Database Configuration (DDC) file
The Dbvisit Standby Database Configuration (DDC) file will now be created. If the configuration file already exists, you will be prompted to overwrite the current configuration file.
=>Dbvisit Database configuration file dbv_w102n.env created.
The DDC file:
- Is a text file that contains all the settings for each database. There will be a DDC file for each database or instance that has Dbvisit Standby installed. It is the equivalent init.ora file for Dbvisit Standby.
- Contains the configuration for the optional Dbvisit Standby Archive log Management Module (AMM).
- The name of the DDC file is dbv_oracle_sid.env
- For RAC, the name of the DDC file is dbv_instance_name.env
- The location of the DDC file is the Dbvisit Standby install directory.
- Contains all the necessary configuration information to keep the standby database up to date.
- Can be modified with any text editor, or can be modified through the dbvisit_setup utility.
- Will be automatically copied over to the standby server the first time Dbvisit Standby executes.
- Any changes should always be done on the primary server. Dbvisit Standby will detect that changes have been made and will transfer the DDC to the standby server.
Dbvisit Standby Database Repository (DDR) setup for CLI
The Dbvisit Standby Database Repository (DDR) will now be created using information from the DDC file that has just been created in the previous step.
=>Creating Dbvisit Database repository (DDR).
Database w102n is up.
41. Select the default tablespace to install the Dbvisit Standby database repository (DDR). A list of tablespaces will be displayed.
Please select the default tablespace to install the Dbvisit Database repository (DDR).
The following tablespaces are available:
Tablespace
===========
1) SYSTEM
2) UNDOTBS1
3) SYSAUX
4) TEMP
5) USERS
6) Refresh list
Please enter choice : 5
The default tablespace will be: USERS
Is this correct? <Yes/No> [Yes]:
42. Select the temporary tablespace to install the Dbvisit Standby Database Repository (DDR). A list of tablespaces will be displayed.
Please select the temp tablespace to install the Dbvisit Database repository (DDR).
The following tablespaces are available:
Tablespace
===========
1) SYSTEM
2) UNDOTBS1
3) SYSAUX
4) TEMP
5) USERS
6) Refresh list
Please enter choice : 4
The temp tablespace will be: TEMP
Is this correct? <Yes/No> [Yes]:
43. The Dbvisit Standby Database Repository (DDR) will now be created.
Dbvisit will now create the Dbvisit Database repository (DDR). Continue (Yes) or return to the
menu? <Yes/Return> [Yes]:
User dbvisit created.
Grants to user dbvisit completed.
Creating repository for dbvisit.
Repository for dbvisit created.
Dbvisit Standby setup completed for CLI
The Dbvisit Standby setup is complete.
44. Dbvisit Standby setup is now complete. Ensure the tasks listed are completed on the standby server. A "what is next" message is also displayed.
=========================================================
Dbvisit configuration completed.
IMPORTANT!
Ensure the following directories are setup on
standby server win2003se-02 with the correct permissions:
1) c:\oracle\orabase
2) C:\oracle\oraarch\w102n
Next steps:
Create standby database using option in main menu:
7) Create Standby Database
=========================================================
Please press <Enter> to return to main menu...
45. Press enter to return to the main menu.
46. The main menu will be redisplayed.
=========================================================
Dbvisit Standby Database technology
http://www.dbvisit.com/
Dbvisit Database setup
Default values will be shown in []
Options:
1) New Database setup (combines options 2,3,4)
1a) New RAC Instance setup (combines options 2,3,4)
2) New Dbvisit Database configuration (DDC) file setup
3) New Dbvisit Archive Management Module (AMM) setup
4) New Dbvisit Database repository (DDR) setup
5) Manage Dbvisit Database repository (DDR)
6) Update Dbvisit Database configuration (DDC) file
7) Create Standby Database
9) Uninstall Dbvisit Database repository (DDR)
E) Exit
=========================================================
Please enter choice :
Primary server (or primary RAC node) setup for GUI
The setup through the browser is very fast and efficient. Dbvisit Standby will specify all the defaults and will alert if a setting is not correct. This setup is only required on the primary server and noton the standby server.
1.Specify the address of the primary server in the URL with the correct port (default 8081).
2. Login to the Dbvisit Standby GUI interface by specifying the user name and password (default is admin/admin)
3. Choose Setup from the main menu.
4. Choose New Dbvisit Setup from the sub menu.
5. The Dbvisit setup process is a seven-step process, where each step corresponds to a different configuration category. The categories are "Primary Server", "Standby Server", "RAC", "Mail", "Primary AMM", "Standby AMM" and "Finish". Dbvisit Standby will specify all the defaults and will alert if a setting is not correct.
6. Setup the Primary server settings. The Oracle databases available on the server are available in the drop down box. Click Next.
7. Setup the Standby server settings. Note the standby server name must be set. Click Next.
8. If RAC parameters need to be set, enter them here. Then click Next
9. Specify Mail parameters. Then click Next.
10. Specify the settings for managing the archive log files on the primary server. Then click Next.
11. Specify the settings for managing the archive log files on the standby server. Then click Next.
12. The Dbvisit Database Configuration (DDC) file has been created. Choose the default and temp tablespace to create the Dbvisit Database Repository (DDR). Click on Finish.
Dbvisit Standby setup completed for GUI
The Dbvisit Standby setup is complete.
13. Dbvisit Standby has now been configured for this database.
14. To create a standby database click on Create Standby DB. To run Dbvisit Standby, click on Run Dbvisit Standby