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

Posted by Hendry chinnapparaj on August 15, 2011

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


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 databases or so says Metalink note 1280447.1

To fix the issue – alter system  flush shared_pool ;

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 Patch Set Release.

As a workaround you can flush the shared pool.

SQL> alter system flush shared_pool;

This will allow you to connect with rman.

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s

%d bloggers like this: