白木耳 2024-11-11 09:45 采纳率: 76.5%
浏览 3

9I RMAN backup

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

  • 写回答

1条回答 默认 最新

  • 嵌入式小企鹅 2024-11-11 11:39
    关注
    
    -- 查看当前 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;
    
    评论

报告相同问题?

问题事件

  • 创建了问题 11月11日