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 and v8

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
  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. If you are using Dbvisit Standby version 8, follow this guide - https://dbvisit.atlassian.net/wiki/pages/viewpage.action?pageId=104431673
  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/DS8QSG/Dbvisit+Standby+Scheduling
Have more questions? Submit a request

Comments