RE: RMAN errors

Thank you to Yong Huang for providing the information on

Bug 10306699: ORA-1008 DURNING RMAN BACKUP AFTER UPGRADING TO 11.2.0.2.0

According to
https://supporthtml.oracle.com/ep/faces/secure/km/BugDisplay.jspx?id=10306699&bugProductSource=Oracle&h=Y

You can flush shared pool or use a different version of rman client or set cursor_sharing=exact.

-- 

Oracle had me going on a wild goose chase.

It was frustrating because the RMAN failed all of a sudden and a snapshot we had 1 day ago works perfectly.

Since I was doing MW, restarting the database solved the issue temporarily at least, but it's nice to know the root cause.



________________________________________
From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] On Behalf Of Michael Dinh [mdinh_at_XIFIN.Com]
Sent: Saturday, January 08, 2011 4:52 PM
To: oracle-l_at_freelists.org
Subject: RMAN errors

Hello,

Has anyone experience the following errors?  I currently have a open SR with Oracle support and has been very difficult.

Thanks.

oracle_at_proddb06:db06:/oracle


> rman target /


Recovery Manager: Release 11.2.0.2.0 - Production on Sat Jan 8 16:52:19 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.


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: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-06003: ORACLE error from target database:
ORA-01008: not all variables bound

oracle_at_proddb06:db06:/oracle


> rman


Recovery Manager: Release 11.2.0.2.0 - Production on Sat Jan 8 16:52:23 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>

Michael Dinh : XIFIN

NOTICE OF CONFIDENTIALITY - This material is intended for the use of the individual or entity to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable laws.  BE FURTHER ADVISED THAT THIS EMAIL MAY CONTAIN PROTECTED HEALTH INFORMATION (PHI). BY ACCEPTING THIS MESSAGE, YOU ACKNOWLEDGE THE FOREGOING, AND AGREE AS FOLLOWS: YOU AGREE TO NOT DISCLOSE TO ANY THIRD PARTY ANY PHI CONTAINED HEREIN, EXCEPT AS EXPRESSLY PERMITTED AND ONLY TO THE EXTENT NECESSARY TO PERFORM YOUR OBLIGATIONS RELATING TO THE RECEIPT OF THIS MESSAGE.  If the reader of this email (and attachments) is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. Please notify the sender of the error and delete the e-mail you received. Thank you.
--
http://www.freelists.org/webpage/oracle-l