Disable Active Dataguard in 11g
Need to modify hidden parameter "_query_on_physical" to false to disable active dataguard. Query to check parameter value: SET PAUSE ON SET PAUSE 'Press Return to Continue' SET PAGESIZE 60 SET LINESIZE 300 COLUMN ksppinm FORMAT A50 COLUMN ksppstvl FORMAT A50 SELECT ksppinm, ksppstvl FROM x$ksppi a, x$ksppsv b WHERE a.indx=b.indx AND substr(ksppinm,1,1) = '_' and a.ksppinm like '_%physical%'; ORDER BY ksppinm / KSPPINM ,KSPPSTVL --------------------------------------------------,-------------------------------------------------- _query_on_physical ,TRUE SQL> alter system set "_query_on_physical"=False scope=spfile; SQL> SQL> SQL> shut immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup; ORACLE instance started. Total System Global Area, 422670336,bytes Fixed Size , 1336960,bytes Variable Size