Oracle 11.2.0.2
OS AIX 6.1 64bit

Recently I came across ORA-01008. As per metalink its a bug in 11.2.0.2.

10/29/12 06:22:25: RmanArcBackup() :         CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 28 DAYS;
10/29/12 06:22:25: RmanArcBackup() :         SQL 'alter system archive log current';
10/29/12 06:22:25: RmanArcBackup() :         SQL 'alter system switch logfile';
10/29/12 06:22:25: RmanArcBackup() :         RUN
10/29/12 06:22:25: RmanArcBackup() :         {
allocate channel tsm1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo_ORCL.opt)';
allocate channel tsm2 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo_ORCL.opt)';
allocate channel tsm3 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo_ORCL.opt)';
10/29/12 06:22:25: RmanArcBackup() :         backup archivelog all not backed up 1 times tag='ORCL_29_10_2012_0622_Level';
10/29/12 06:22:25: RmanArcBackup() :         backup current controlfile tag='ORCL_29_10_2012_0622_Level';
10/29/12 06:22:25: RmanArcBackup() :         resync catalog;
release channel tsm1;
release channel tsm2;
release channel tsm3;
10/29/12 06:22:25: RmanArcBackup() :         }
10/29/12 06:22:25: RmanArcBackup() :         Executing RMAN Archive Backup. Please Wait...

Recovery Manager: Release 11.2.0.2.0 - Production on Mon Oct 29 06:22:25 2012

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
10/29/12 06:22:26: RmanArcBackup() :         RMAN Archive Backup Completed
10/29/12 06:22:26: RmanArcBackup() :         The RMAN Archive Backup Completed with RMAN-, ORA- Errors
10/29/12 06:22:26: ExitProcess() :           Sending mail on Script Failure...

* Bug 14186565 : RMAN FAILS WITH RMAN-571, RMAN-569 AND ORA-1008

A workaround for this can be, just flush shared_pool area and then you are good to go.

host:ORCL:/ORCL/u00/app/oracle/admin/ORCL/logs>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Mon Oct 29 07:03:56 2012

Copyright (c) 1982, 2010, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> alter system flush shared_pool;

System altered.

SQL> exit

Lets start with the RMAN backup.

RmanArcCmdWoStdby1() : backup archivelog all not backed up 1 times tag='ORCL_29_10_2012_0704_Level';
RmanArcCmdWoStdby1() : backup current controlfile tag='ORCL_29_10_2012_0704_Level';
RmanArcBackup() : CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 28 DAYS;
RmanArcBackup() : SQL 'alter system archive log current';
RmanArcBackup() : SQL 'alter system switch logfile';
RmanArcBackup() : RUN
RmanArcBackup() : {
allocate channel tsm1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo_ORCL.opt)';
allocate channel tsm2 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo_ORCL.opt)';
allocate channel tsm3 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo_ORCL.opt)';
RmanArcBackup() : backup archivelog all not backed up 1 times tag='ORCL_29_10_2012_0704_Level';
RmanArcBackup() : backup current controlfile tag='ORCL_29_10_2012_0704_Level';
RmanArcBackup() : resync catalog;
release channel tsm1;
release channel tsm2;
release channel tsm3;
RmanArcBackup() : }
RmanArcBackup() : Executing RMAN Archive Backup. Please Wait...
RmanArcBackup() : RMAN Archive Backup Completed
RmanArcBackup() : The RMAN Archive Backup Completed Successfully
ExitProcess() : The Script ran successfully

Advertisements