19c ADG 报错启动实时应用报错
ORA-64356: in-memory area out of space
2022-05-13T18:08:32.147926+08:00 ARC1 (PID:98258): Archived Log entry 92 added for T-1.S-2838 ID 0x697f52ce LAD:1 2022-05-13T18:09:37.238082+08:00 Slave exiting with ORA-64356 exception 2022-05-13T18:09:37.238273+08:00 Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_pr2p_174848.trc: ORA-64356: in-memory area out of space 2022-05-13T18:09:37.240236+08:00 Slave exiting with ORA-64356 exception 2022-05-13T18:09:37.240315+08:00 Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_pr16_174637.trc: ORA-64356: in-memory area out of space 2022-05-13T18:09:37.241130+08:00 Slave exiting with ORA-64356 exception 2022-05-13T18:09:37.241209+08:00 Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_pr1b_174647.trc: ORA-64356: in-memory area out of space 2022-05-13T18:09:37.347325+08:00 Recovery Slave PR2P previously exited with exception 64356 2022-05-13T18:09:38.170298+08:00 PR00 (PID:174544): MRP0: Background Media Recovery terminated with error 448 2022-05-13T18:09:38.170423+08:00 Errors in file /u01/app/oracle/diag/rdbms/orcl /orcl 1/trace/orcl 1_pr00_174544.trc: ORA-00448: normal completion of background process 2022-05-13T18:09:38.171632+08:00 .... (PID:95485): Managed Standby Recovery not using Real Time Apply 2022-05-13T18:09:38.195932+08:00 Recovery interrupted! 2022-05-13T18:09:59.913875+08:00 IM on ADG: Start of Empty Journal
解决方案:
当前是一个bug,还没有补丁,是由于在备库使用了inmemory所导致,临时解决方案。
在备库执行:
alter system set inmemory_adg_enabled=false scope=spfile sid='';
alter system reset inmemory_size scope=spfile sid='';