Running Dbvisit (Sending and Applying Logs)

Executing (run) the default Dbvisit Standby commands from the command line can be done by running the following:

./dbvisit <DDC>

This command is the same for Sending and Applying logs. Dbvisit Standby will know what operation to perform depending on which environment is it executed from. Below are two examples, showing the sending and the applying of logs. In this example the database is called “proddb” and this is also the name of the DDC. The DDC file name is:

dbv_proddb.env

Sending Logs (Primary Server):

oracle@dbvlin501[/usr/dbvisit/standby]: ./dbvisit proddb
=============================================================
Dbvisit Standby Database Technology (7.0.01.11254) (pid 10632)
dbvisit started on dbvlin501: Thu Aug 22 23:12:11 2013 ()
=============================================================

>>> Obtaining information from standby database (RUN_INSPECT=Y)...

>>> Checking Dbvisit Standby for configurational differences between dbvlin501 and
    dbvlin502...

    No configurational differences found between dbvlin501 and dbvlin502.

>>> Log file(s) for proddb will be transferred from dbvlin501 to dbvlin502...

  > Transferring 'o1_mf_1_5437_91fnr2k9_.arc.gz' to server dbvlin502:7890
    Progress: 0%...20%...40%...60%...80%...100% [2725 KB/s] - done.
  > Transferring 'o1_mf_1_5438_91fnr2yf_.arc.gz' to server dbvlin502:7890
    Progress: 0%...20%...40%...60%...80%...100% [1513 KB/s] - done.
  > Transferring 'o1_mf_1_5439_91fnr3bw_.arc.gz' to server dbvlin502:7890
    Progress: 0%...20%...40%...60%...80%...100% [1708 KB/s] - done.

    3 archive log transfers to dbvlin502 for proddb completed.
    Last sequence was 5439.

>>> Dbvisit Archive Management Module (AMM)

    Config: number of archives to keep      = 0
    Config: number of days to keep archives = 7
    Config: archive backup count            = 0
    Config: diskspace full threshold        = 80%

    Current disk percent full (/u01/app/oracle/flash_recovery_area) = 24%

    Current disk percent full (FRA) = 76%

    Number of archive logs deleted = 0

=============================================================
dbvisit ended on dbvlin501: Thu Aug 22 23:12:27 2013
=============================================================

Applying Logs (Standby Server):

oracle@dbvlin502[/usr/dbvisit/standby]: ./dbvisit proddb
=============================================================
Dbvisit Standby Database Technology (7.0.01.11254) (pid 7358)
dbvisit started on dbvlin502: Fri Aug 23 11:15:53 2013 ()
=============================================================

>>> Log file(s) for proddb from dbvlin501 will be applied to dbvlin502
201308231115 - Log seq 5436 thread 1 applied to standby database proddb.
201308231115 - Log seq 5437 thread 1 applied to standby database proddb.
201308231115 - Log seq 5438 thread 1 applied to standby database proddb.
201308231115 - Log seq 5439 thread 1 applied to standby database proddb.

>>> Dbvisit Archive Management Module (AMM)

    Config: number of archives to keep      = 0
    Config: number of days to keep archives = 7
    Config: diskspace full threshold        = 80%

Processing /u01/app/oracle/archive/proddb...
    Archive log dir: /u01/app/oracle/archive/proddb
    Total number of archive files   : 22
    Number of archive logs deleted = 0
    Current Disk percent full       : 22%

=============================================================
dbvisit ended on dbvlin502: Fri Aug 23 11:16:05 2013
=============================================================