High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

how to prevent services from starting on active dataguard database

How can I prevent someone from starting services on an active dataguard database? we are using 19.23 DB. We want to prevent any service from starting either automatically or accidentally by someone starting a service on the cluster.

I know you can set -role in the service creation but this only starts the service based on PRIMARY, PHYSICAL_STANDBY, etc. but it does not prevent startup on a database that does not match the role.

I would like an automatic foolproof way to prevent service startup. we don't want to drop/recreate services, etc. I also don't want a procedural fix as this is also prone to human error. we need to ensure that no service starts on the read-only standby.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center