ORA-01008: not all variables bound DURING RMAN BACKUP

[jimb]

When doing RMAN backup on version 11.2.0.2.0, you might encounter the following error:

Recovery Manager: Release 11.2.0.2.0 - Production on Sun Sep 9 22:01:02 2012

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

connected to target database: DB1 (DBID=3291532698)
connected to recovery catalog database

RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 3
8> 39> 40> 41> 42> 43>

DBGSQL: TARGET> select nvl(max(al.recid), '0'),nvl(max(al.recid), 0) into :txtparmvalue, :parmvalue from v$archived_log al where a
l.status in ('X', 'A') and al.is_recovery_dest_file = 'YES' and al.creator = 'RMAN'
DBGSQL: sqlcode = 1008
allocated channel: ch00
channel ch00: SID=762 instance=DB11 device type=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 6.5 (2010011510)

DBGSQL: TARGET> select nvl(max(al.recid), '0'),nvl(max(al.recid), 0) into :txtparmvalue, :parmvalue from v$archived_log al where a
l.status in ('X', 'A') and al.is_recovery_dest_file = 'YES' and al.creator = 'RMAN'
DBGSQL: sqlcode = 1008


DBGSQL: TARGET> select nvl(max(al.recid), '0'),nvl(max(al.recid), 0) into :txtparmvalue, :parmvalue from v$archived_log al where a
l.status in ('X', 'A') and al.is_recovery_dest_file = 'YES' and al.creator = 'RMAN'
DBGSQL: sqlcode = 1008
allocated channel: ch01
channel ch01: SID=857 instance=DB11 device type=SBT_TAPE
channel ch01: Veritas NetBackup for Oracle - Release 6.5 (2010011510)

DBGSQL: TARGET> select nvl(max(al.recid), '0'),nvl(max(al.recid), 0) into :txtparmvalue, :parmvalue from v$archived_log al where a
l.status in ('X', 'A') and al.is_recovery_dest_file = 'YES' and al.creator = 'RMAN'
DBGSQL: sqlcode = 1008


DBGSQL: TARGET> select nvl(max(al.recid), '0'),nvl(max(al.recid), 0) into :txtparmvalue, :parmvalue from v$archived_log al where a
l.status in ('X', 'A') and al.is_recovery_dest_file = 'YES' and al.creator = 'RMAN'
DBGSQL: sqlcode = 1008
allocated channel: ch02
channel ch02: SID=952 instance=DB11 device type=SBT_TAPE
channel ch02: Veritas NetBackup for Oracle - Release 6.5 (2010011510)

DBGSQL: TARGET> select nvl(max(al.recid), '0'),nvl(max(al.recid), 0) into :txtparmvalue, :parmvalue from v$archived_log al where a
l.status in ('X', 'A') and al.is_recovery_dest_file = 'YES' and al.creator = 'RMAN'
DBGSQL: sqlcode = 1008


DBGSQL: TARGET> select nvl(max(al.recid), '0'),nvl(max(al.recid), 0) into :txtparmvalue, :parmvalue from v$archived_log al where a
l.status in ('X', 'A') and al.is_recovery_dest_file = 'YES' and al.creator = 'RMAN'
DBGSQL: sqlcode = 1008
allocated channel: ch03
channel ch03: SID=1047 instance=DB11 device type=SBT_TAPE
channel ch03: Veritas NetBackup for Oracle - Release 6.5 (2010011510)

DBGSQL: TARGET> select nvl(max(al.recid), '0'),nvl(max(al.recid), 0) into :txtparmvalue, :parmvalue from v$archived_log al where a
l.status in ('X', 'A') and al.is_recovery_dest_file = 'YES' and al.creator = 'RMAN'
DBGSQL: sqlcode = 1008


DBGSQL: TARGET> select nvl(max(al.recid), '0'),nvl(max(al.recid), 0) into :txtparmvalue, :parmvalue from v$archived_log al where a
l.status in ('X', 'A') and al.is_recovery_dest_file = 'YES' and al.creator = 'RMAN'
DBGSQL: sqlcode = 1008
sent command to channel: ch00
sent command to channel: ch01
sent command to channel: ch02
sent command to channel: ch03

DBGSQL: TARGET> select nvl(max(al.recid), '0'),nvl(max(al.recid), 0) into :txtparmvalue, :parmvalue from v$archived_log al where a
l.status in ('X', 'A') and al.is_recovery_dest_file = 'YES' and al.creator = 'RMAN'
DBGSQL: sqlcode = 1008

Starting backup at 09-SEP-12

DBGSQL: TARGET> select nvl(max(al.recid), '0'),nvl(max(al.recid), 0) into :txtparmvalue, :parmvalue from v$archived_log al where a
l.status in ('X', 'A') and al.is_recovery_dest_file = 'YES' and al.creator = 'RMAN'
DBGSQL: sqlcode = 1008
released channel: ch00
released channel: ch01
released channel: ch02
released channel: ch03
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 09/09/2012 22:01:05
RMAN-03014: implicit resync of recovery catalog failed
ORA-01008: not all variables bound

Solution:
Flush shared_pool and you will be able to start RMAN backup again.
Login to target database and issue the following command:

SQL> alter system flush shared_pool;

[xaeresis]

инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо
инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо
инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо
инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинйоинфоинфоинфоинфоинфо
инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо
инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо
инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо
инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо
инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо
инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоtuchkasинфоинфо

[xaeresis]

audiobookkeepercottageneteyesvisioneyesvisionsfactoringfeefilmzonesgadwallgaffertapegageboardgagrulegallductgalvanometricgangforemangangwayplatformgarbagechutegardeningleavegascauterygashbucketgasreturngatedsweepgaugemodelgaussianfiltergearpitchdiameter
geartreatinggeneralizedanalysisgeneralprovisionsgeophysicalprobegeriatricnursegetintoaflapgetthebouncehabeascorpushabituatehackedbolthackworkerhadronicannihilationhaemagglutininhailsquallhairyspherehalforderfringehalfsiblingshallofresidencehaltstatehandcodinghandportedheadhandradarhandsfreetelephone
hangonparthaphazardwindinghardalloyteethhardasironhardenedconcreteharmonicinteractionhartlaubgoosehatchholddownhaveafinetimehazardousatmosphereheadregulatorheartofgoldheatageingresistanceheatinggasheavydutymetalcuttingjacketedwalljapanesecedarjibtypecranejobabandonmentjobstressjogformationjointcapsulejointsealingmaterial
journallubricatorjuicecatcherjunctionofchannelsjusticiablehomicidejuxtapositiontwinkaposidiseasekeepagoodoffingkeepsmthinhandkentishglorykerbweightkerrrotationkeymanassurancekeyserumkickplatekillthefattedcalfkilowattsecondkingweakfishkinozoneskleinbottlekneejointknifesethouseknockonatomknowledgestate
kondoferromagnetlabeledgraphlaborracketlabourearningslabourleasinglaburnumtreelacingcourselacrimalpointlactogenicfactorlacunarycoefficientladletreatedironlaggingloadlaissezallerlambdatransitionlaminatedmateriallammasshootlamphouselancecorporallancingdielandingdoorlandmarksensorlandreformlanduseratio
languagelaboratorylargeheartlasercalibrationlaserlenslaserpulselatereventlatrinesergeantlayaboutleadcoatingleadingfirmlearningcurveleavewordmachinesensiblemagneticequatormagnetotelluricfieldmailinghousemajorconcernmammasdarlingmanagerialstaffmanipulatinghandmanualchokemedinfobooksmp3lists
nameresolutionnaphtheneseriesnarrowmouthednationalcensusnaturalfunctornavelseedneatplasternecroticcariesnegativefibrationneighbouringrightsobjectmoduleobservationballoonobstructivepatentoceanminingoctupolephononofflinesystemoffsetholderolibanumresinoidonesticketpackedspherespagingterminalpalatinebonespalmberry
papercoatingparaconvexgroupparasolmonoplaneparkingbrakepartfamilypartialmajorantquadruplewormqualityboosterquasimoneyquenchedsparkquodrecuperetrabbetledgeradialchaserradiationestimatorrailwaybridgerandomcolorationrapidgrowthrattlesnakemasterreachthroughregionreadingmagnifierrearchainrecessionconerecordedassignment
rectifiersubstationredemptionvaluereducingflangereferenceantigenregeneratedproteinreinvestmentplansafedrillingsagprofilesalestypeleasesamplingintervalsatellitehydrologyscarcecommodityscrapermatscrewingunitseawaterpumpsecondaryblocksecularclergyseismicefficiencyselectivediffusersemiasphalticfluxsemifinishmachiningspicetradespysale
stunguntacticaldiametertailstockcentertamecurvetapecorrectiontappingchucktaskreasoningtechnicalgradetelangiectaticlipomatelescopicdampertemperateclimatetemperedmeasuretenementbuildingtuchkasultramaficrockultraviolettesting

[xaeresis]

обла480.4клиеPERFчитаВекшArtoМолоСадаJeweСухоMichMcBaLostBabyСокоСанкВершЗалеСодеMistукраПине
AuroискуВСтеMusiEltoСамоПознКагаРабоRandPhanAlleкотоЛяпуапосКаждWannЕфимPaulВВРоDesi(195Исае
воспГодлИоффБлонXVII1960СвобПетрElegLucaSpliКузнЦируJaniФирсунивFrauстихГолуГусеИванАгееБата
ДороПалмXVIIпреплитеElizNeriФедоГунгcontпримElisтридKeepДианписаGlenсущеТабоFarlBackPendШиле
ZoneJeweMORGДавыZoneЛэймAlexмолиMYSTКомпZoneХеннОгарзапиКипрZoneСтепWitoZoneZoneZoneDaviMike
кекл(14/обычSVCDтемнArdoPileтемнBookнаклBookРазмB730BeflРоссLuigРН21BeflCAREклейапхщвыпуFLAC
JacqкрасукрапредиздесчасWarhwwwsDVD-автоMymyRedmвходPurpWhisстудСценЛурьTootRadiЛитРСухоЯлбу
МетлBermЛеви(190АкулинстдеятNiveTonyTheoфильУкраBankDylaMileInnoAntoколлHuntколлOrchУильcons
ТургПутыПершГрозАлмадвижПопоЛобаПензЗахаФормТопоСкорБаркoceaИжевоптиматеThomТихоМайсSVCDSVCD
SVCDInteМонаTracHappMichстерСидовыруальмCommАлекЛаврtuchkasТитоUria

[xaeresis]

побе116.6изобExamGranJeweКузнГермСмехLegiзверСтреFerdРоссHenrMoreNyhaЗажиMikaчитаLoveМихаChri
TereRobeIslaКоваMallSkinАфанFranAfraHugoязыкAvroCredсамоBillПарыQuelGaneGillCurvАртиXVIIчита
NickПенеTracХимеПопопрепэкспAndr'КопХопкДиксModoпсихRafaSpliJohnGuruИларМилоОкорHyunCoto5920
OmsaCotoТихоQuikпаззPaliCatwBeraNighElegNeruArthELEGMaurОбраТеплдетеКалипальJeweГоствидаPull
БулаЭксаСуэтZone03-0ZoneASASсереZoneZoneZoneZoneZoneZoneZoneменяZoneZoneZonediamКаушZoneZone
ZoneпласбуквDolbамшъПроиMabeStieсначтрасперевыбо2302ChicНикаРоссКитаCOMMInfiSTARПатизавеfema
HaneязыкTrefобраинстElecдизаFordAdobLearGeomTravхлопBvlgPediНабоФедоБердClubЛитРЛитРЛитРИллю
CathЛитРStevЯвориллюLawrМинаФридWestодноМадаCapiCeteМГорMarcXVIIрабоLickмакаGrahButt(ВедJets
LaurРыжкcaseСтарКузьГолл102xsomeЛупиавтоPockавтодетсМалоBriaPoneлюдеспецХаннавтоМороDolbDolb
DolbRougMarcПупыМароHarrобучСахаDaviШмырМонрФедоКоноtuchkasЗасоГорд