No risk to activate Active Data Guard by mistake with SQL Developer SQLcl

Franck Pachot
Jul 16 · 3 min read

Risk with sqlplus “startup”

alter system set "_query_on_physical"=false scope=spfile;

No problem with SQLcl

ORA-16003: standby database is restricted to read-only access
ORACLE_SID=CDB1B sql / as sysdbaSQLcl: Release 19.1 Production on Tue Jul 16 18:15:34 2019Copyright (c) 1982, 2019, Oracle.  All rights reserved.Connected to an idle instance.SQL> startup
ORACLE instance started.
ORA-16003: standby database is restricted to read-only access

Update 17-JUL-2019

Franck Pachot

Written by

https://twitter.com/FranckPachot DBA at CERN, Oracle OCM 12c, Oracle ACE Director, Oak Table member. My 499 posts at dbi-services: http://blog.dbi.pachot.net

Welcome to a place where words matter. On Medium, smart voices and original ideas take center stage - with no ads in sight. Watch
Follow all the topics you care about, and we’ll deliver the best stories for you to your homepage and inbox. Explore
Get unlimited access to the best stories on Medium — and support writers while you’re at it. Just $5/month. Upgrade