备份遇到错误:
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.
问题解决。