This section will show you an example on how to Create Standby database using Transportable Media option using Dbvisit Command Line Interface:
...
| No Format |
|---|
On Primary:
oracle@dbvlin803[/usr/local/dbvisit/standby]: ./dbvisit_setup
=========================================================
Dbvisit Standby Database Technology (6.0.60.11060)
http://www.dbvisit.com
=========================================================
=>dbvisit_setup only needs to be run on the primary server.
Is this the primary server? <Yes/No> [Yes]:
=========================================================
Dbvisit Standby Database Technology (6.0.60.11060)
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 : 7
------------------------------------------------------------------------------
=>Creating Standby Database.
Primary database will NOT be shutdown.
Choose database:
The following Oracle database(s) have a Dbvisit Database configuration (DDC)
file on this server:
DDC
===
1) testdb
2) Return to menu
Please enter choice : 1
Is this correct? <Yes/No> [Yes]:
Database testdb is up.
Checking Dbvisit Standby configurational differences between dbvlin803 and dbvlin804...
No Dbvisit Standby configurational differences found between dbvlin803 and dbvlin804.
Checking Oracle installation on dbvlin804 in
/u01/app/oracle/product/11.2.0/db_1/bin/oracle...
Total database size for testdb is 2.00GB
What would you like to do:
1 - Create standby database (and optionally save settings in template)
2 - Restart the uncompleted creation of standby database
3 - Create standby database using existing template (previously saved)
4 - Help
5 - Terminate processing
Please enter your choice [2]: 2
What would you like to do:
1 - Restart the uncompleted creation of standby database
2 - View status of the uncompleted creation of standby database
3 - Return to the previous menu
Please enter your choice [1]: 1
Creating standby database...
Shutting down standby database on dbvlin804...
Standby database testdb on dbvlin804 shutdown.
Remote spfile /u01/app/oracle/product/11.2.0/db_1/dbs/spfiletestdb.ora backed
as /u01/app/oracle/product/11.2.0/db_1/dbs/spfiletestdb.ora.201407091402.
Remote spfile /u01/app/oracle/product/11.2.0/db_1/dbs/spfiletestdb.ora deleted.
Spfile created on remote server.
Restoring standby control files...
Standby control files restored.
Starting Standby Database testdb...
Standby Database testdb started .
Standby database testdb on dbvlin804 mounted.
Restore datafile 1...
Restore datafile 2...
Restore datafile 3...
Restore datafile 4...
Restore datafile 5...
Restore datafile 6...
Performing Oracle Checkpoint.
Waiting 3 seconds for log switch completion...
Standby database created.
To complete creating standby database, run dbvisit on the primary server, then
on the standby, to ensure the standby database is in sync with primary.
Please press <Enter> to continue...
=========================================================
Standby Database creation on dbvlin804 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:
(cd /usr/local/dbvisit/standby)
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... |
...