/
Create standby database on the fly using CLI

Create standby database on the fly using CLI

Jan 21, 2013

The example below shows how to create standby database on the fly (by direct transfer to the standby server). Creating a standby database is performed on the primary server (primary node).
For a complete overview of creating the standby database, please see Creating Standby Databases automatically with Dbvisit Standby.

1. Go to the Dbvisit Standby install directory. Start the Dbvisit Standby setup utility.

2. To create a standby database, choose option 7.

3. Choose the primary database to create a standby for. Only Dbvisit Standby configured databases will be shown :

4. The primary database must be up and running for the setup to proceed. Total size of the primary database is calculated and displayed. The Dbvisit Standby installation files are also copied to the standby server initially. If uncompleted creation of the standby database is detected, a restart option will be available. Standby database can also be created using a saved template:

5. An ASM (for Oracle version 10.2 or higher) or normal file system standby database can be created:

6. It is possible to transfer datafiles directly to the standby server, but only if both primary and standby databases are filesystem, and the primary database does not contain Oracle Managed Files (OMF):

7. It is possible to use secure shell (SSH) compression "on the fly" during transfer of the database files. Using SSH compression may speed up the transfer if the network is slow, however it may take additional CPU cycles:

8. It is possible to create missing filesystem directories on the standby server automatically:

9. Oracle database parameters for the standby database can be customised:

To edit spfile parameter on standby database, select option 2 and enter full-name of the parameter and then associated new value.


10. It is possible to specify the locations of standby datafiles, redo logs and tempfiles different as primary, or alternatively keep the same structure for the standby database as primary:

11. Provided answers can be stored as a template for future use (re-running creating of a standby database):

12. The standby database will now be created. Once completed the next steps to take will be shown:

13. The standby database has been created. The Dbvisit Standby setup menu will be redisplayed:

14. Exit out of the main menu and run Dbvisit Standby as normal.

15. Dbvisit Standby can now be run on completion of the standby database creation. To run Dbvisit Standby go to section Dbvisit Standby commands (running or executing Dbvisit Standby).