This section will show you an example of creating a standby database. This Create Standby Database process (setup) is also referred to as CSD.
...
Windows only:
Start the "Dbvisit Standby command console" from the Start Menu ->Programs -> Dbvisit -> Standby.
This will start a Command Line with your session already in the DBVISIT_BASE/standby directory.
...
Apply your license key (or the demo licence key provided on software download), example:
| No Format |
|---|
oracle@dbvlin101[/usr/dbvisit/standby]: ./dbvisit -lic proddb EB57I-DYK7K-9PI2V-1SH0D-AAWGR-2WEDY-ZJJ0F
=============================================================
Dbvisit Standby Database Technology (7.0.04.11735) (pid 11331)
dbvisit started on dbvlin101: Mon Jan 27 22:46:59 2014 ()
=============================================================
Dbvisit Standby license information for: proddb
customer_seq=1
customer_key_seq=0
license_type=DEMO (0)
expiry_date=2014-02-10
=>Update with license key: EB57I-DYK7K-9PI2V-1SH0D-AAWGR-2WEDY-ZJJ0F? <Yes/No> [Yes]: Yes
License updated.
Status: Valid
=============================================================
dbvisit ended on dbvlin101: Mon Jan 27 22:47:03 2014
============================================================= |
Note the key above is just an example/demo key.
Now that the license key is applied on the primary, run Dbvisit Standby as normal:
| No Format |
|---|
oracle@dbvlin101[/usr/dbvisit/standby]: ./dbvisit proddb
=============================================================
Dbvisit Standby Database Technology (7.0.04.11735) (pid 11392)
dbvisit started on dbvlin101: Mon Jan 27 22:47:56 2014 ()
=============================================================
>>> Obtaining information from standby database (RUN_INSPECT=Y)...
>>> Sending heartbeat message... - done.
>>> Checking Dbvisit Standby for configurational differences between dbvlin101 and
dbvlin102...
No configurational differences found between dbvlin101 and dbvlin102.
>>> Log file(s) for proddb will be transferred from dbvlin101 to dbvlin102...
> Transferring 'o1_mf_1_35_9gdb7647_.arc.gz' to server dbvlin102:7890
Progress: 0%...20%...40%...60%...80%...100% [7551 KB/s] - done.
1 archive log transfer to dbvlin102 for proddb completed.
Last sequence was 35.
No Mail sent as SEND_MAIL_FLAG = N
>>> 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/fast_recovery_area) = 67%
Number of archive logs deleted = 0
=============================================================
dbvisit ended on dbvlin101: Mon Jan 27 22:48:32 2014
============================================================= |
Step 18:
The second to last step is to run Dbvisit Standby on the standby server, example:
| No Format |
|---|
oracle@dbvlin102[/usr/dbvisit/standby]: ./dbvisit proddb
=============================================================
Dbvisit Standby Database Technology (7.0.04.11735) (pid 31798)
dbvisit started on dbvlin102: Mon Jan 27 22:50:11 2014 ()
=============================================================
>>> Sending heartbeat message... - done.
>>> Log file(s) for proddb from dbvlin101 will be applied to dbvlin102
201401272250 - Log seq 35 thread 1 applied to standby database proddb.
No Mail sent as SEND_MAIL_FLAG_DR = N
>>> 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 : 7
Number of archive logs deleted = 1
Current Disk percent full : 63%
=============================================================
dbvisit ended on dbvlin102: Mon Jan 27 22:50:18 2014
=============================================================
|
Step 19:
Schedule Dbvisit Standby to run on a regular basis on the primary and standby server.
The options available for scheduling are:
- Using Unix CRON schedule
- Using Windows Schedular
- Using Dbvserver (Web Based Interface) Built in Schedular