Oracle-adg ORA-64356 in-memory area out of space

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='
';

posted @ 2022-05-20 18:21  lizhao01  阅读(312)  评论(0编辑  收藏  举报