Hendry's "Oracle and SQL Server DBA Stuff"

Oracle and SQL Server Database Solutions for DBA's please visit http://hendrydba.com for the latest posts. Thanks

Rman: Ora-01008 When Connecting To Target in 11.2.0.2

Posted by Hendry chinnapparaj on August 15, 2011

Rman: Ora-01008 When Connecting To Target in 11.2.0.2 [ID 1280447.1]

Problem:

The RMAN Backup job failed with the error

RMAN> backup archivelog all;

Starting backup at 15-08-2011 14:40:29

DBGSQL:     TARGET> select  nvl(max(al.recid), ‘0’),nvl(max(al.recid), 0)   into  :txtparmvalue, :parmvalue   from  v$archived_log al  where  al.status in (‘X’, ‘A’)    and  al.is_recovery_dest_file = ‘YES’    and  al.creator = ‘RMAN’
DBGSQL:        sqlcode = 1008
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 08/15/2011 14:40:29
RMAN-03014: implicit resync of recovery catalog failed
ORA-01008: not all variables bound

RMAN> exit

This is a bug for  11.2.0.2 databases or so says Metalink note 1280447.1

To fix the issue – alter system  flush shared_pool ;

Cause
This issue is discussed in Bug#10414993 which has been closed as a duplicate of (non-published)
Bug# 9877980 which in turn will be fixed in the 11.2.0.3 Patch Set Release.

Solution
As a workaround you can flush the shared pool.

SQL> alter system flush shared_pool;

This will allow you to connect with rman.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: