9I RMAN backup

Question

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on d1 channel at 11/10/2024 21:02:47
RMAN-10015: error compiling PL/SQL program
RMAN-10033: error during compilation of job step 3: ORA-00603: ORACLE server session terminated by fatal error
ORA-04030: out of process memory when trying to allocate 2504 bytes (PL/SQL MPCODE,pl/sql DS pg)

RMAN 备份出现这个错误
实体记忆体:16G
sga_max_size big 8601448992

Answer 1

-- 查看当前 PGA 设置
SHOW PARAMETER PGA_AGGREGATE_TARGET;

-- 增加 PGA 设置
ALTER SYSTEM SET PGA_AGGREGATE_TARGET = 8G SCOPE=BOTH;

-- 查看当前 SGA 设置
SHOW PARAMETER SGA;

-- 增加 SGA 设置
ALTER SYSTEM SET SGA_TARGET = 4G SCOPE=BOTH;