RE: RMAN errors
- From: Michael Dinh <mdinh@xxxxxxxxx>
- To: Michael Dinh <mdinh@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 9 Jan 2011 08:53:43 -0800
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
