We're here to help!

Recreate standby database

Follow

Read our docs The steps in this article apply when you want to re-create the standby database. Make sure the process is followed before initiating CSD (Create Standby Database) again.


Problem Details

Problem Statement

What is the correct process of re-creating standby database?

Applicable Error Code

N/A

Affected Versions

v7, v8 & v9

Affected Platforms

All

 
Description

When rebuilding standby database, please make sure the following are done: 

Solution
Version 7
  1. Shutdown standby database
  2. Delete datafiles and FRA folder (if using FRA) related to standby database
  3. Make sure Dbvisit schedules are stopped (both primary & standby) - Note: this could either be CRON (for Linux), Windows Task Scheduler (for Windows), or Dbvserver GUI scheduler
  4. Re-run CSD on primary server. You can do this either via CLI or GUI. If you are using Dbvisit Standby version 7, follow this guide - https://dbvisit.atlassian.net/wiki/pages/viewpage.action?pageId=19005583
  5. Run Dbvisit manually to test if everything is configured correctly
  6. Schedule Dbvisit process to automatically ship & apply logs - Ref: https://dbvisit.atlassian.net/wiki/display/UGDS7/Dbvisit+Standby+Scheduling
Version 8 & 9
  1. Shutdown standby database
  2. Delete datafiles and FRA folder (if using FRA) related to standby database
  3. Make sure Dbvisit schedules are stopped (both primary & standby) - Note: this could either be CRON (for Linux), Windows Task Scheduler (for Windows), or Dbvisit daemon
  4. Re-run CSD on primary server. You can do this either via CLI or GUI.                                      
  5. Run Dbvisit manually to test if everything is configured correctly
  6. Schedule Dbvisit process to automatically ship & apply logs, reference

 v8 https://dbvisit.atlassian.net/wiki/display/DS8QSG/Dbvisit+Standby+Scheduling

v9 https://dbvisit.atlassian.net/wiki/spaces/DS9QSG/pages/1244990162/Dbvisit+Standby+Scheduling

 

 

Have more questions? Submit a request

Comments