RMAN-06429: TARGET database is not compatible with this version of RMAN
FranklinFaces.com
FranklinFaces.com - Oracle & SQL Server Database Forums for all IT Professionals
Home       Members    Calendar    Who's On
Welcome Guest ( Login | Register )
        



RMAN-06429: TARGET database is not compatible... Expand / Collapse
Author
Message
Posted 12/17/2009 3:02:56 AM


Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Administrators
Last Login: 1/26/2010 1:58:14 PM
Posts: 131, Visits: 377
Hi,

My archive log destination directory was getting filled up and i got alert that thresholds had been reached. I didn't know why until i looked at the archive log script backup log.   This is what it showed in the log:

RMAN-06003: ORACLE error from target database:
ORA-04031: unable to allocate 41152 bytes of shared memory ("shared pool","DBMS_RCVMAN","PL/SQL MPCODE","BAMIMA: Bam Buffer")
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_RCVMAN"

RMAN-06438: error executing package DBMS_RCVMAN in TARGET database
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06429: TARGET database is not compatible with this version of RMAN


 

I tried to login to rman manually to see what was going on and got the same error:


# rman

Recovery Manager: Release 10.2.0.3.0 - Production on Thu Dec 17 00:36:09 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

RMAN> connect target /

ORACLE error from target database:
ORA-04031: unable to allocate 41152 bytes of shared memory ("shared pool","DBMS_RCVMAN","PL/SQL MPCODE","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-06429: TARGET database is not compatible with this version of RMAN

RMAN> exit

I then logged into sqlplus to check the rman packages to see because there was no recent upgrades of any kind.

# sqlplus '/ as sysdba'

SQL*Plus: Release 10.2.0.3.0 - Production on Thu Dec 17 00:36:31 2009

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> SQL> select dbms_rcvman.getpackageversion from dual;
select dbms_rcvman.getpackageversion from dual
                                          *
ERROR at line 1:
ORA-04031: unable to allocate 41152 bytes of shared memory ("shared
pool","DBMS_RCVMAN","PL/SQL MPCODE","BAMIMA: Bam Buffer")

I tried flushing my shared_pool and then checked to see how large my shared_pool was:


SQL> alter system flush shared_pool;

System altered.

SQL> select dbms_rcvman.getpackageversion from dual;
select dbms_rcvman.getpackageversion from dual
                                          *
ERROR at line 1:
ORA-04031: unable to allocate 41152 bytes of shared memory ("shared
pool","DBMS_RCVMAN","PL/SQL MPCODE","BAMIMA: Bam Buffer")


SQL> show parameter shared_pool


NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
shared_pool_reserved_size            big integer 10M
shared_pool_size                     big integer 200M

Shared_pool size was small .. so i increased it and that fixed the problem:

 

SQL> alter system set shared_pool_size=300m;

System altered.

SQL> select dbms_rcvman.getpackageversion from dual;

GETPACKAGEVERSION
--------------------------------------------------------------------------------
08.00.04.00

backup is now running ok.

Hope this helps.

Post #171
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 1 (1 guest, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: silencer

Permissions Expand / Collapse

All times are GMT -5:00, Time now is 7:03am

Powered By InstantForum.NET v4.1.4 © 2010
Execution: 0.141. 7 queries. Compression Disabled.