ADG主库上归档丢失恢复备库测试模拟了下在主库上丢失归档导致备库出现gap,无需重建恢复备库的情况1制造gap主库ALTER system SET log_archive_dest_state_2 = 'defer';一些dml操作alter system switch logfile;备库此时的mrp是等待log状态SQL> select process,client_process
Oracle ADG宕机:LGWR进程报错4021 故障现象原因分析 故障现象 现象:ADG备库宕机。 数据库告警日志内容如下: Wed Mar 27 16:15:27 2024Errors in file /oracle/app/diag/rdbms/orcldb_0/orcldb/trace/orcldb_pmon_287591.trc:ORA-03170: dead
1.主库切换备库 SQL> select name,open_mode,switchover_status from v$database;NAME OPEN_MODE SWITCHOVER_STATUS--------- -------------------- --------------------PROD1 READ WRITE TO STANDBYSQL> alter system
--1、主库检查 检查修改主库的force logging 模式 sqlplus / as sysdba SQL>select FORCE_LOGGING from v$database; alter database force logging; --主库remote_login_passwordfile 为EXCLUSIVE show parameter remote_login_
rac->单机的ADG同步,搭建好之后,开启实时应用发现报错: RFS[1]: No standby redo logfiles available for thread 1 RFS[1]: Opened log for thread 1 sequence 900 dbid 1911584814 branch 1038507374 Fri Jun 05 13:20:22 2020 Archi