RE: RMAN errors

Once again, oracle-l prevails!

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@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] On Behalf 
Of Michael Dinh [mdinh@xxxxxxxxx]
Sent: Saturday, January 08, 2011 4:52 PM
To: oracle-l@xxxxxxxxxxxxx
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@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@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

Other related posts: