Dbvisit Standby must be run and scheduled separately on the primary and the standby server, but the commands are the same. Dbvisit Standby will detect on which server it is running automatically. It is recommended that Dbvisit Standby is run manually in the foreground on both the primary and standby server for the first few times before it is scheduled to run automatically in the background.
...
| Section |
|---|
| Column |
|---|
| | Panel |
|---|
| dbvisit w102n
=============================================================
Dbvisit Standby Database Technology
dbvisit.exe started on win2003se-01
=============================================================
First time Dbvisit runs, Dbvisit installation will be copied to win2003se-02...
Transferring dbv_functions to host win2003se-02:dbv_functions
Transferring dbvisit to host win2003se-02:dbvisit
Transferring dbvisit_setup to host win2003se-02:dbvisit_setup
Transferring dbv_oraStartStop to host win2003se-02:dbv_oraStartStop
Transferring dbv_w102n.env to host win2003se-02:dbv_w102n.env
Transferring dbv_ORACLE_SID.env to host win2003se-02:dbv_ORACLE_SID.env
Contacting Standby Database w102n on win2003se-02...
Last standby sequence obtained (20).
Log file(s) for w102n will be transferred from win2003se-01 to win2003se-02...
Transferring O1_MF_1_23_380BXLVT_.ARC.gz to host win2003se-02:O1_MF_1_23_380BXLVT_.ARC.gz
Transferring O1_MF_1_24_380C0PF5_.ARC.gz to host win2003se-02:O1_MF_1_24_380C0PF5_.ARC.gz
Transferring O1_MF_1_25_382Z7S3X_.ARC.gz to host win2003se-02:O1_MF_1_25_382Z7S3X_.ARC.gz
3 Log transfer(s) to win2003se-02 for w102n completed.
Last sequence was 25.
Starting Dbvisit Archive Management Module (AMM)...
Dbvisit Archive Management Module (AMM)
(Number to keep: 0) (Days to keep: 7) (Diskspace full threshold: 80%)
Total number of archive files : 9
Number of files deleted : 0
Current Disk percent full : 39%
=============================================================
dbvisit ended on win2003se-01
============================================================= |
Where w102n is the name of the database |
|
Home > Run > Run Interactive > Primary Server tab > select Database from drop-down menu > select Default from Run Action drop-down menu > Run
| Note |
|---|
|
- The first time that Dbvisit Standby executes, the Dbvisit Standby installation and configuration files will be copied over to the standby server. This is equivalent to running Dbvisit Standby with the -c option, or Copy Software from the Run Action menu on the Run Interactive web-based interface screen.
- The first time Dbvisit Standby executes, the standby database must be up and running because Dbvisit Standby has to determine which initial log is needed for the standby database. Subsequent times Dbvisit Standby executes on the primary server the standby database does not need to be up and available.
- In the examples the Dbvisit Standby Archive log Management Module (AMM) is turned on. This can be turned off by setting ARCHSOURCE_MANAGEMENT=N for the primary server and ARCHDEST_MANAGEMENT=N for the primary server in the DDC file, or by updating this parameter directly via the following menu path in the web-based interface: Home > Setup > Update Dbvisit > Update Dbvisit Configuration.
|
Subsequent times that Dbvisit Standby executes, the Dbvisit Standby installation will not be copied over to the standby server and Dbvisit Standby will NOT contact the standby database. The standby database does not have to be available to transfer the archive log files to the standby database.
...
| Section |
|---|
| Column |
|---|
| | Panel |
|---|
| dbvisit w102n
=============================================================
Dbvisit Standby Database Technology
dbvisit.exe started on win2003se-02
=============================================================
Log file(s) for w102n from win2003se-01 will be applied to win2003se-02...
200902271142 - Log seq 21 applied to standby database w102n.
200902271142 - Log seq 22 applied to standby database w102n.
200902271142 - Log seq 23 applied to standby database w102n.
200902271142 - Log seq 24 applied to standby database w102n.
200902271142 - Log seq 25 applied to standby database w102n.
Starting Dbvisit Archive Management Module (AMM)...
Dbvisit Archive Management Module (AMM)
(Number to keep: 0) (Days to keep: 8) (Diskspace full threshold: 80%)
Total number of archive files : 11
Number of files deleted : 0
Current Disk percent full : 39%
=============================================================
dbvisit ended on win2003se-02
============================================================= |
Where w102n is the name of the database |
|
Image ModifiedHome > Run > Run Interactive > Standby Server tab > select Database from drop-down menu > select Default from Run Action drop-down menu > Run
If there are no logs to be applied then Dbvisit Standby will indicate this.
...
| Section |
|---|
| Column |
|---|
| | Panel |
|---|
| dbvisit -c w102n ============================================================= Dbvisit Standby Database Technology dbvisit.exe started on win2003se-01 ============================================================= Transferring dbv_functions to host win2003se-02:dbv_functions Transferring dbvisit to host win2003se-02:dbvisit Transferring dbvisit_setup to host win2003se-02:dbvisit_setup Transferring dbv_oraStartStop to host win2003se-02:dbv_oraStartStop Transferring dbv_w102n.env to host win2003se-02:dbv_w102n.env Transferring dbv_ORACLE_SID.env to host win2003se-02:dbv_ORACLE_SID.env ============================================================= dbvisit ended on win2003se-01 ============================================================= |
Where w102n is the name of the database |
|
Image ModifiedHome > Run > Run Interactive > Primary Server tab > select Database from drop-down menu > select Copy Software from Run Action drop-down menu > Run
| Note |
|---|
If configuration changes are made to the database Configuration file (DDC), Dbvisit Standby will automatically detect this and update the standby server (next time Dbvisit Standby executes on the primary server), if setting SYNCH_DBVISIT_INSTALL=Y. This is the default setting. |
...
| Section |
|---|
| Column |
|---|
| | Panel |
|---|
| dbvisit -r 27 w102n
=============================================================
Dbvisit Standby Database Technology
dbvisit.exe started on win2003se-01
=============================================================
Performing Oracle Checkpoint.
Waiting for 3 seconds for checkpoint completion...
Checking Dbvisit configurational differences between win2003se-01 and win2003se-
02...
No Dbvisit configurational differences found between win2003se-01 and win2003se-
02.
Log file(s) for w102n will be transferred from win2003se-01 to win2003se-02...
Transferring O1_MF_1_27_3839D3YR_.ARC.gz to host win2003se-02:O1_MF_1_27_3839D3YR_.ARC.gz
Transferring O1_MF_1_28_3839JCMK_.ARC.gz to host win2003se-02:O1_MF_1_28_3839JCMK_.ARC.gz
Transferring O1_MF_1_29_3839OYTC_.ARC.gz to host win2003se-02:O1_MF_1_29_3839OYTC_.ARC.gz
200902271152 - 3 Log transfer(s) to win2003se-02 for w102n completed.
Last sequence was 29.
Starting Dbvisit Archive Management Module (AMM)...
Dbvisit Archive Management Module (AMM)
(Number to keep: 0) (Days to keep: 7) (Diskspace full threshold: 80%)
Total number of archive files : 12
Number of files deleted : 0
Current Disk percent full : 39%
=============================================================
dbvisit ended on win2003se-01
============================================================= |
Where w102n is the name of the database |
|
Image ModifiedHome > Run > Run Interactive > Primary Server tab > select Database from drop-down menu > select Resend Sequence from Run Action drop-down menu > Run
Enter a sequence number.
6. Resynchronise with the standby database. This is used when the standby database has been rebuilt or Dbvisit Standby is not transferring the correct archive log sequence for the standby database.
...
| Section |
|---|
| Column |
|---|
| | Panel |
|---|
| dbvisit -R w102n
=============================================================
Dbvisit Standby Database Technology
dbvisit.exe started on win2003se-01
=============================================================
Performing Oracle Checkpoint.
Waiting for 3 seconds for checkpoint completion...
Resynch option given. Dbvisit installation will be copied to win2003se-02...
Transferring dbv_functions to host win2003se-02:dbv_functions
Transferring dbvisit to host win2003se-02:dbvisit
Transferring dbvisit_setup to host win2003se-02:dbvisit_setup
Transferring dbv_oraStartStop to host win2003se-02:dbv_oraStartStop
Transferring dbv_w102n.env to host win2003se-02:dbv_w102n.env
Transferring dbv_ORACLE_SID.env to host win2003se-02:dbv_ORACLE_SID.env
Contacting Standby Database w102n on win2003se-02...
Last standby sequence obtained (26).
Log file(s) for w102n will be transferred from win2003se-01 to win2003se-02...
Transferring O1_MF_1_26_383922G5_.ARC.gz to host win2003se-02:O1_MF_1_26_383922G5_.ARC.gz
Transferring O1_MF_1_27_3839D3YR_.ARC.gz to host win2003se-02:O1_MF_1_27_3839D3YR_.ARC.gz
Transferring O1_MF_1_28_3839JCMK_.ARC.gz to host win2003se-02:O1_MF_1_28_3839JCMK_.ARC.gz
Transferring O1_MF_1_29_3839OYTC_.ARC.gz to host win2003se-02:O1_MF_1_29_3839OYTC_.ARC.gz
Transferring O1_MF_1_30_3838NWTC_.ARC.gz to host win2003se-02:O1_MF_1_30_3838NWTC_.ARC.gz
200901271134 - 5 Log transfer(s) to win2003se-02 for w102n completed.
Last sequence was 30.
Starting Dbvisit Archive Management Module (AMM)...
Dbvisit Archive Management Module (AMM)
(Number to keep: 0) (Days to keep: 7) (Diskspace full threshold: 80%)
Total number of archive files : 13
Number of files deleted : 0
Current Disk percent full : 39%
=============================================================
dbvisit ended on win2003se-01
============================================================= |
Where w102n is the name of the database |
|
Image ModifiedHome > Run > Run Interactive > Primary Server tab > select Database from drop-down menu > select Resynchronize from Run Action drop-down menu > Run
7. To determine the archive log gap, and the transfer log gap, run Dbvisit Standby with the Inspect option.
...
| Section |
|---|
| Column |
|---|
| | Panel |
|---|
| dbvisit -i w102n
=============================================================
Dbvisit Standby Database Technology
dbvisit.exe started on win2003se-01
=============================================================
Contacting Standby Database w102n on win2003se-02...
Last standby sequence obtained (26).
Dbvisit report:
-------------------------------
Standby database on win2003se-02 is at sequence: 26
Primary database on win2003se-01 is at log sequence: 29
Primary database on win2003se-01 is at archived log sequence: 28
Dbvisit last transfer log sequence: 28
Archive log gap: 2
Transfer log gap: 0
=============================================================
dbvisit.exe ended on win2003se-01
============================================================= |
Where w102n is the name of the database |
|
Image ModifiedHome > Run > Run Interactive > Primary Server tab > select Database from drop-down menu > select Log Gap Report from Run Action drop-down menu > Run
8. To view or set the Dbvisit Standby license.
dbvisit -lic <DDC>
Where DDC is the name of the Dbvisit Database Configuration. In most cases this is the same as the database name. The DDC refers to the DDC file name which is in the form: dbv_DDC.env and contains the Dbvisit Standby settings for a
For more information see the Setting and viewing the Dbvisit Standby license key section.
Image ModifiedHome > Setup > Register
9. Help and copyright information is available if Dbvisit Standby is run without parameters or options.
...
| Section |
|---|
| Column |
|---|
| | Panel |
|---|
| dbv_oraStartStop start w102n
======================================================
Dbvisit Standby Database technology
dbv_oraStartStop started on dbvisit11
======================================================
Starting regular Database w102n...
Regular Database w102n started.
======================================================
dbv_oraStartStop ended on dbvisit11
====================================================== |
Wherew102n is the name of the database. |
|
Image ModifiedHome > Run > Run Interactive > Primary Server tab > select Database from drop-down menu > select Start Database from Run Action drop-down menu > Run
To start the standby database, choose the Standby Server tab.
It is recommended to use Dbvisit Standby to start the databases (primary and standby) automatically at boot time. Dbvisit Standby will start the databases automatically, and ensure that the primary and standby databases are started correctly. For Windows it is recommended to set the Windows services of the databases on both the primary and standby servers to manual. Please see Starting Databases automatically - Windows section for more information.
...
| Section |
|---|
| Column |
|---|
| | Panel |
|---|
| dbv_oraStartStop stop w102n
======================================================
Dbvisit Standby Database technology
dbv_oraStartStop started on dbvisit11
======================================================
Shutting down regular Database w102n...
Regular Database w102n shutdown successfully.
======================================================
dbv_oraStartStop ended on dbvisit11
====================================================== |
Where w102n is the name of the database. |
|
Home > Run > Run Interactive > Primary Server tab > select Database from drop-down menu > select Stop Database from Run Action drop-down menu > Run
To stop the standby database, choose the Standby Server tab.
...
| Section |
|---|
| Column |
|---|
| | Panel |
|---|
| dbv_oraStartStop restart w102n
======================================================
Dbvisit Standby Database technology
dbv_oraStartStop started on dbvisit11
======================================================
Shutting down regular Database w102n...
Regular Database w102n shutdown successfully.
Starting regular Database w102n...
Regular Database w102n started.
======================================================
dbv_oraStartStop ended on dbvisit11
====================================================== |
Where w102n is the name of the database. |
|
Image ModifiedHome > Run > Run Interactive > Primary Server tab > select Database from drop-down menu > select Restart Database from Run Action drop-down menu > Run
To restart the standby database, choose the Standby Server tab.
...
| Section |
|---|
| Column |
|---|
| | Panel |
|---|
| dbv_oraStartStop status w102n
======================================================
Dbvisit Standby Database technology
dbv_oraStartStop started on dbvisit12
======================================================
Standby Database w102n on dbvisit12 is up.
======================================================
dbv_oraStartStop ended on dbvisit12
====================================================== |
Where w102n is the name of the database. |
|
Image ModifiedHome > Run > Run Interactive > Primary Server tab > select Database from drop-down menu > select Database Status from Run Action drop-down menu > Run
To show the status of the standby database, choose the Standby Server tab.
...
| Section |
|---|
| Column |
|---|
| | Panel |
|---|
| dbv_oraStartStop open w102n
======================================================
Dbvisit Standby Database technology
dbv_oraStartStop started on dbvisit12
======================================================
Open standby Database w102n in READ ONLY mode.
Standby Database w102n opened in READ ONLY mode.
Log files cannot be applied to Database while in sync mode.
======================================================
dbv_oraStartStop ended on dbvisit12
====================================================== |
Where w102n is the name of the database. |
|
Image ModifiedHome > Run > Run Interactive > Standby Server tab > select Database from drop-down menu > select Open Read-Only from Run Action drop-down menu > Run
When the standby database is in READ ONLY mode, the log files cannot be applied to the standby database. This means the standby database will not be in synch with the primary database.
To return to normal standby database mode for applying log files, the standby database needs to be restarted:
...
| Section |
|---|
| Column |
|---|
| | Panel |
|---|
| =============================================================
Dbvisit Standby Database Technology
dbv_oraStartStop started on dbvisit12
=============================================================
Activating means this database will become a Primary Database.
It will no longer be a Standby Database for w102n on dbvisit12.
Activation cannot be reversed.
=>Activate Standby Database on dbvisit12? <Yes/No> [No]: y
Are you sure? <Yes/No> [No]: y
Activating now...
Activate Standby Database w102n...
Standby Database w102n activated.
Shutting down standby Database w102n...
Standby Database w102n shutdown successfully.
Starting activated Standby Database w102n...
Activated Standby Database w102n started.
Dbvisit Database configuration (DDC) file dbv_w120n.env has been updated and
variables have been reversed between primary and standby server.
SOURCE=dbvisit12 DESTINATION=dbvisit11.
Activation complete. Please ensure a backup of this Database is made.
If the Dbvisit process is to be reversed, then
Database on dbvisit11 will need to be rebuilt as a Standby Database.
=============================================================
dbv_oraStartStop ended on dbvisit12
============================================================= |
Where w102n is the name of the database. |
|
Image ModifiedHome > Run > Run Interactive > Standby Server tab > select Database from drop-down menu > select Activate from Run Action drop-down menu > Run
Graceful Switchover
16. To initial Graceful Switchover
...
| Section |
|---|
| Column |
|---|
| | Panel |
|---|
| dbv_oraStartStop switchover dbvsun92 |
Where dbvsun92 is the name of the database |
|
Image ModifiedHome > Run > Run Interactive > Primary Server tab > select Database from drop-down menu > select Graceful Switchover from Run Action drop-down menu > Run
Enter Unique Key. This can be any number, but it has to be the same number as entered on the Standby Server tab.
Image ModifiedHome > Run > Run Interactive > Standby Server tab > select Database from drop-down menu > select Graceful Switchover from Run Action drop-down menu > Run
Enter Unique Key. This can be any number and it has to be the same number as entered on the Primary Server tab
.