• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 707
  • Last Modified:

How To Disable DataGuard and Open Standby database

How do I disable DataGuard (Physical DataGuard Setup) and open Standby database for read write access? This is Oracle 10g version.
0
Omega002
Asked:
Omega002
1 Solution
 
k3paCommented:
Hi,

Yous scenario is covered in this section. This step-by-step manual will let you to resynchronyze the dataguard again.

12.6 Using a Physical Standby Database for Read/Write Testing and Reporting
URL -> http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/scenarios.htm#CIHIABDH



Anyway, if you intend to convert your physical dataguard to the primary you should perform a failover:

7.2.2 Failovers Involving a Physical Standby Database
http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/role_management.htm#i1026398


Regards
0
 
Omega002Author Commented:
No
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now