Oracle RMAN-06429: TARGET database is not compatible with this version of RMAN

备份遇到错误:

RMAN-06429: TARGET database is not compatible with this version of RMAN

检查软件版本

opatch lspatches

实例数据字典中版本

SQL> select * from v$version;

SQL> set lines 200 pages 1000
SQL> col COMMENTS for a40
SQL> select ACTION_TIME, ACTION, COMMENTS from sys.DBA_REGISTRY_HISTORY;

没有问题

export ORACLE_SID=xxxxx

rman target /

Recovery Manager: Release 18.0.0.0.0 - Production on Mon Aug 2 19:54:49 2021
Version 18.5.0.0.0

Copyright (c) 1982, 2018, Oracle and/or its affiliates.  All rights reserved.

Oracle error from target database: 
ORA-04031: unable to allocate 20936 bytes of shared memory ("shared pool","DBMS_RCVMAN","PLMCD^6554d3d3","BAMIMA: Bam Buffer")
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_RCVMAN"

error executing package DBMS_RCVMAN in TARGET database
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-06429: TARGET database is not compatible with this version of RMAN

看alert日志发现:---------->>>>出现很多4031

DDE: Problem Key 'ORA 4031' was completely flood controlled (0x6)
Further messages for this problem key will be suppressed for up to 10 minutes

So, 问题在于share pool 小了,继续

show parameter shared_pool_size;

show parameter sga_max_size;

show parameter db_cache_size;

sga max = db cache + shared pool + other

对于RAC,处理办法:

这里由于内存限制,将db_cache缩小一点,可以扩大一点share pool

SQL> alter system set db_cache_size=???M scope=both sid='sid1';
System altered.

SQL> alter system set shared_pool_size=??G scope=both sid='sid1';

System altered.

问题解决。

  • 2
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值