Thursday, 27 August 2015

Disable Active DataGuard


How to disable the active dataguard in the database, I know if we use active dataguard we have to pay extra license but sometimes if we start the physical standby db with "startup"command then inadvertently active dataguard feature gets enabled.

Solution

The active data guard would be enabled automatically when starting a physical standby and the DG broker is used. 

There is an unofficially way to disable using a hidden parameter, which is _query_on_physical=false

Since it is a underscore parameter, you will have to contact Oracle Support before using it. 

No comments:

Post a Comment