Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to solve the problem that the RFS process can not rise after dg synchronization". In the daily operation, I believe that many people have doubts about how to solve the problem that the RFS process can not rise after dg synchronization. The editor consulted all kinds of data and sorted out simple and easy-to-use methods of operation. I hope it will be helpful for everyone to answer the doubt that "how to solve the problem that the RFS process cannot rise after dg synchronization". Next, please follow the editor to study!

The RFS process cannot start after dg synchronization, which is attributed to ORA-00604 and ORA-16000.

SQL > set lines 1000SQL > select PROCESS,PID,STATUS, GROUP#, RESETLOG_ID,THREAD#,SEQUENCE# from v$managed_standby PROCESS PID STATUS GROUP# RESETLOG_ID THREAD# SEQUENCE# -ARCH 3965 CONNECTED N 0ARCH A 0 0 0ARCH 3969 CONNECTED N max A 0 0 0ARCH 3973 CONNECTED N/A 0 0 0ARCH 3977 CONNECTED N/A 0 0 0MRP0 6708 APPLYING_LOG N/A 918146907 1 107387

View the log

Errors in file / u01/app/oracle/diag/rdbms/yjzddbdg/yjzddb1/trace/yjzddb1_ora_4111.trc:ORA-00604: error occurred at recursive SQL level 1ORA-16000: database open for read-only access

Find out the hidden parameter _ system_trig_enabled, first make it ineffective, after resynchronizing, you can see that the RFS process starts.

SQL > alter system set "_ system_trig_enabled" = false;System altered.SQL > recover managed standby database cancel;Media recovery complete.SQL > recover managed standby database using current logfile disconnect;Media recovery complete.SQL > set lines 1000SQL > select PROCESS,PID,STATUS, GROUP#, RESETLOG_ID,THREAD#,SEQUENCE# from v$managed_standby PROCESS PID STATUS GROUP# RESETLOG_ID THREAD# SEQUENCE# -ARCH 3965 CONNECTED N 0ARCH A 0 0 0ARCH 3969 CONNECTED N max A 0 0 0ARCH 3973 CONNECTED N/A 0 0 0ARCH 3977 CONNECTED N/A 0 0 0MRP0 23687 APPLYING_LOG N/A 918146907 1 107401RFS 23964 IDLE N/A 0 0 0RFS 23960 IDLE N/A 0 0 0RFS 23968 IDLE N/A 0 0 0RFS 23955 IDLE 5 918146907 1 1074019 rows selected.

Do this on all nodes in rac, and remember to re-validate the hidden parameter on all nodes after the DG switch is complete.

SQL > alter system set "_ system_trig_enabled" = true; System altered. At this point, the study on "how to solve the problem that the RFS process can not rise after dg synchronization" is over. I hope to be able to solve everyone's doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.