/
Create Standby Database using Dbvisit Standby create standby wizard

Create Standby Database using Dbvisit Standby create standby wizard

Nov 30, 2012

This example shows how to create an ASM standby database with different structure as primary ASM database. Creating a standby database is performed on the primary server (primary node).

Windows only:
Start the Dbvisit Standby command console from the Start Menu ->Programs -> Dbvisit -> Standby. 

Linux/Unix only:
Go to the Dbvisit Standby install directory. Start the Dbvisit Standby setup utility.

Linux/UNIX and Windows:

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


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

3. 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:

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

5. 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):

6. It is possible to compress datafiles before transferring:

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

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

9. It is possible to use TRANSPORTABLE MEDIA for very large databases or slow networks:

10. To create an ASM standby database temporary locations on both primary and standby server must be specified, to hold a database backup:

11. The process of creating a standby database can be broken into two steps:

12. It is possible to specify the locations of standby datafiles, redo logs and tempfiles different as primary:

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

14. The standby database will now be created. Once completed the next stepsto take will be shown:

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

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