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.
...
Once the "Pre-Flight Check" completes, the Create Standby Database (CSD) process start. Detail
Detail output of the Standby Creation is displayed:
Step 15:
The standby database has been created. The Dbvisit Standby setup menu will be redisplayed:
Step 16:
...
| No Format |
|---|
>>> Backing up primary database...
Backing up datafile 1... - done.
Backing up datafile 2... - done.
Backing up datafile 3... - done.
Backing up datafile 4... - done.
>>> Creating standby control file... - done.
Backup of primary database completed.
>>> Transferring backup from dbvlin101 to dbvlin102...
> Transferring 'dbv_proddb_csd_dbf_1_0jov5bt8_1_1.rman' to server dbvlin102:7890
Progress: 0%...20%...40%...60%...80%...100% [9398 KB/s] - done.
> Transferring 'dbv_proddb_csd_dbf_1_0kov5bul_1_1.rman' to server dbvlin102:7890
Progress: 0%...20%...40%...60%...80%...100% [10659 KB/s] - done.
> Transferring 'dbv_proddb_csd_dbf_2_0lov5bur_1_1.rman' to server dbvlin102:7890
Progress: 0%...20%...40%...60%...80%...100% [10537 KB/s] - done.
> Transferring 'dbv_proddb_csd_dbf_3_0mov5bvp_1_1.rman' to server dbvlin102:7890
Progress: 0%...20%...40%...60%...80%...100% [10644 KB/s] - done.
> Transferring 'dbv_proddb_csd_dbf_4_0nov5c04_1_1.rman' to server dbvlin102:7890
Progress: 0%...20%...40%...60%...80%...100% [10379 KB/s] - done.
>>> Restoring standby control files... - done.
>>> Starting standby database proddb on dbvlin102 mount... - done.
>>> Restoring datafiles on dbvlin102...
Restoring datafile 1 - done.
Restoring datafile 2 - done.
Restoring datafile 3 - done.
Restoring datafile 4 - done.
>>> Renaming standby redo logs and tempfiles on dbvlin102... - done.
>>> Performing checkpoint and archiving logs... - done.
>>> Finishing standby database creation... - done.
Standby database created.
To complete creating standby database please run Dbvisit on the primary server first,
then on the standby server, to ensure the standby database is in sync with the primary
database.
Please press <Enter> to continue...
|
Step 15:
The standby database has been created, the next steps are highlighted, which is to run dbvisit standby on the primary server, followed by running it on the standby server. This is done by running the "dbvisit <DDC>" command first on primary then the standby.
| No Format |
|---|
=========================================================
Standby Database creation on dbvlin102 completed.
Next steps:
1) Exit out of dbvisit_setup.
2) Run Dbvisit on this server with command:
dbvisit database_name
3) Run Dbvisit on standby server with command:
dbvisit database_name
Once Dbvisit has been tested, schedule Dbvisit on primary and standby servers
using cron or other scheduling tool.
=========================================================
Please press <Enter> to continue... |
Step 16:
The Dbvisit Standby Setup menu is displayed. Press "E" to exit the menu.
| No Format |
|---|
=========================================================
Dbvisit Standby Database Technology (7.0.04.11726)
http://www.dbvisit.com
Dbvisit Database setup
Default values will be shown in []
Options:
1) New Dbvisit Database setup (combines options 2,3,4)
1a) New Dbvisit 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 (and template)
8) Synchronize Standby Database
9) Uninstall Dbvisit Database repository (DDR)
E) Exit
=========================================================
Please enter choice : |
Step 17:
Run Dbvisit first on the primary server as normal. On first run you will get an error message "No License Key Found", similar as to the one below indicating that you need to apply your license key:
| No Format |
|---|
=============================================================
Dbvisit Standby Database Technology (7.0.04.11735) (pid 11239)
dbvisit started on dbvlin101: Mon Jan 27 22:44:06 2014 ()
=============================================================
201401272244 - No license key found for Dbvisit Standby version: . Please contact Dbvisit Standby (www.dbvisit.com) to obtain a current license. Run the Dbvisit Standby license command (dbvisit -lic) to update the license.
Dbvisit Standby terminated.
Return code = 2006
(Tracefile required if contacting Dbvisit Standby support: /usr/dbvisit/standby/trace/11239_dbvisit_proddb_201401272244.trc (server:dbvlin101))
No Mail sent as SEND_MAIL_FLAG = N |
Apply your license key (or the demo licence key provided on software download), example: