Synchronise Standby Database via GUI

Owned by Anton Els (Deactivated)
Last updated: Jan 10, 2014
2 min read

One of the additional options provided by Dbvisit Standby is the option to roll your standby database forward when you have an un-recoverable archive log gap.

This option can also be used if no-logging operations were performed on your primary database and you need to fix logical corruption on the standby database.

This option is available from both the CLI and GUI interfaces. Behind the scenes this process is making use of RMAN incremental backups to bring the standby database up to date with the primary.

The two screens below show you an overview of the Synchronise Standby Database option in the GUI:

 

  1.  Navigate to the "SETUP" -> "Synchronise Standby" Menu
  2. Accept that you want to synchronise the standby database using this method
  3. Specify the TEMP location where the incremental backup files will be stored
    1. Note the backup will be made on the primary server, and once the backups are complete will be transferred to the Standby server to the TMP location specified there.
    2. Make sure there is sufficient disk space in this location to hold the backup, which in most cases should be small, depending on the difference between the primary and standby

 

Note that this incremental backup and "Synchronising" process can take time as RMAN will be doing a full scan of the database files. If you have extremely large files this can take time, especially the backup. The restore process will be much faster.

In some cases the backup process (step 2 in second image below) can take the same time as a normal full RMAN backup, but remember only the required blocks (changes) are backed up and the restore process will be substantially faster.

 

 

 

 

 

 

Â