I just wanted to share a RMAN bug that I have encountered, just in case you get infected as well.
The OS is
> uname -an SunOS 5.10 Generic_142909-17 sun4u sparc SUNW,SPARC-Enterprise > rman Recovery Manager: Release 220.127.116.11.0 - Production on Sat Jan 8 07:28:19 2011 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. RMAN> connect target / DBGSQL: TARGET> select count(*) into :dbstate from v$parameter where lower(name) = '_dummy_instance' and upper(value) = 'TRUE' DBGSQL: sqlcode = 1008 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== ORA-01008: not all variables bound RMAN>
Bug 10306699: ORA-1008 DURNING RMAN BACKUP AFTER UPGRADING TO 18.104.22.168.0
Suggested solution was to set cursor_sharing=EXACT
Also, it helps to flush the shared pool before connecting to target.
As Gerrit has stated in the comment, there is a patch available.
Have not seen the issue since then.
Patch 9877980 : applied on Sun Aug 21 20:12:30 PDT 2011 Unique Patch ID: 13349636 Created on 19 Jan 2011, 18:34:07 hrs PST8PDT Bugs fixed: 9877980