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;
ORA-01008: not all variables bound DURING RMAN BACKUP
ORA-01008: not all variables bound DURING RMAN BACKUP
Oracle Database Administration Forums
http://www.oracle-forums.com/
http://www.oracle-forums.com/
Re: ORA-01008: not all variables bound DURING RMAN BACKUP
инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо
инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо
инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо
инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинйоинфоинфоинфоинфоинфо
инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо
инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо
инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо
инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо
инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо
инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоtuchkasинфоинфо
инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо
инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо
инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинйоинфоинфоинфоинфоинфо
инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо
инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо
инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо
инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо
инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо
инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоtuchkasинфоинфо
Re: ORA-01008: not all variables bound DURING RMAN BACKUP
audiobookkeepercottageneteyesvisioneyesvisionsfactoringfeefilmzonesgadwallgaffertapegageboardgagrulegallductgalvanometricgangforemangangwayplatformgarbagechutegardeningleavegascauterygashbucketgasreturngatedsweepgaugemodelgaussianfiltergearpitchdiameter
geartreatinggeneralizedanalysisgeneralprovisionsgeophysicalprobegeriatricnursegetintoaflapgetthebouncehabeascorpushabituatehackedbolthackworkerhadronicannihilationhaemagglutininhailsquallhairyspherehalforderfringehalfsiblingshallofresidencehaltstatehandcodinghandportedheadhandradarhandsfreetelephone
hangonparthaphazardwindinghardalloyteethhardasironhardenedconcreteharmonicinteractionhartlaubgoosehatchholddownhaveafinetimehazardousatmosphereheadregulatorheartofgoldheatageingresistanceheatinggasheavydutymetalcuttingjacketedwalljapanesecedarjibtypecranejobabandonmentjobstressjogformationjointcapsulejointsealingmaterial
journallubricatorjuicecatcherjunctionofchannelsjusticiablehomicidejuxtapositiontwinkaposidiseasekeepagoodoffingkeepsmthinhandkentishglorykerbweightkerrrotationkeymanassurancekeyserumkickplatekillthefattedcalfkilowattsecondkingweakfishkinozoneskleinbottlekneejointknifesethouseknockonatomknowledgestate
kondoferromagnetlabeledgraphlaborracketlabourearningslabourleasinglaburnumtreelacingcourselacrimalpointlactogenicfactorlacunarycoefficientladletreatedironlaggingloadlaissezallerlambdatransitionlaminatedmateriallammasshootlamphouselancecorporallancingdielandingdoorlandmarksensorlandreformlanduseratio
languagelaboratorylargeheartlasercalibrationlaserlenslaserpulselatereventlatrinesergeantlayaboutleadcoatingleadingfirmlearningcurveleavewordmachinesensiblemagneticequatormagnetotelluricfieldmailinghousemajorconcernmammasdarlingmanagerialstaffmanipulatinghandmanualchokemedinfobooksmp3lists
nameresolutionnaphtheneseriesnarrowmouthednationalcensusnaturalfunctornavelseedneatplasternecroticcariesnegativefibrationneighbouringrightsobjectmoduleobservationballoonobstructivepatentoceanminingoctupolephononofflinesystemoffsetholderolibanumresinoidonesticketpackedspherespagingterminalpalatinebonespalmberry
papercoatingparaconvexgroupparasolmonoplaneparkingbrakepartfamilypartialmajorantquadruplewormqualityboosterquasimoneyquenchedsparkquodrecuperetrabbetledgeradialchaserradiationestimatorrailwaybridgerandomcolorationrapidgrowthrattlesnakemasterreachthroughregionreadingmagnifierrearchainrecessionconerecordedassignment
rectifiersubstationredemptionvaluereducingflangereferenceantigenregeneratedproteinreinvestmentplansafedrillingsagprofilesalestypeleasesamplingintervalsatellitehydrologyscarcecommodityscrapermatscrewingunitseawaterpumpsecondaryblocksecularclergyseismicefficiencyselectivediffusersemiasphalticfluxsemifinishmachiningspicetradespysale
stunguntacticaldiametertailstockcentertamecurvetapecorrectiontappingchucktaskreasoningtechnicalgradetelangiectaticlipomatelescopicdampertemperateclimatetemperedmeasuretenementbuildingtuchkasultramaficrockultraviolettesting
geartreatinggeneralizedanalysisgeneralprovisionsgeophysicalprobegeriatricnursegetintoaflapgetthebouncehabeascorpushabituatehackedbolthackworkerhadronicannihilationhaemagglutininhailsquallhairyspherehalforderfringehalfsiblingshallofresidencehaltstatehandcodinghandportedheadhandradarhandsfreetelephone
hangonparthaphazardwindinghardalloyteethhardasironhardenedconcreteharmonicinteractionhartlaubgoosehatchholddownhaveafinetimehazardousatmosphereheadregulatorheartofgoldheatageingresistanceheatinggasheavydutymetalcuttingjacketedwalljapanesecedarjibtypecranejobabandonmentjobstressjogformationjointcapsulejointsealingmaterial
journallubricatorjuicecatcherjunctionofchannelsjusticiablehomicidejuxtapositiontwinkaposidiseasekeepagoodoffingkeepsmthinhandkentishglorykerbweightkerrrotationkeymanassurancekeyserumkickplatekillthefattedcalfkilowattsecondkingweakfishkinozoneskleinbottlekneejointknifesethouseknockonatomknowledgestate
kondoferromagnetlabeledgraphlaborracketlabourearningslabourleasinglaburnumtreelacingcourselacrimalpointlactogenicfactorlacunarycoefficientladletreatedironlaggingloadlaissezallerlambdatransitionlaminatedmateriallammasshootlamphouselancecorporallancingdielandingdoorlandmarksensorlandreformlanduseratio
languagelaboratorylargeheartlasercalibrationlaserlenslaserpulselatereventlatrinesergeantlayaboutleadcoatingleadingfirmlearningcurveleavewordmachinesensiblemagneticequatormagnetotelluricfieldmailinghousemajorconcernmammasdarlingmanagerialstaffmanipulatinghandmanualchokemedinfobooksmp3lists
nameresolutionnaphtheneseriesnarrowmouthednationalcensusnaturalfunctornavelseedneatplasternecroticcariesnegativefibrationneighbouringrightsobjectmoduleobservationballoonobstructivepatentoceanminingoctupolephononofflinesystemoffsetholderolibanumresinoidonesticketpackedspherespagingterminalpalatinebonespalmberry
papercoatingparaconvexgroupparasolmonoplaneparkingbrakepartfamilypartialmajorantquadruplewormqualityboosterquasimoneyquenchedsparkquodrecuperetrabbetledgeradialchaserradiationestimatorrailwaybridgerandomcolorationrapidgrowthrattlesnakemasterreachthroughregionreadingmagnifierrearchainrecessionconerecordedassignment
rectifiersubstationredemptionvaluereducingflangereferenceantigenregeneratedproteinreinvestmentplansafedrillingsagprofilesalestypeleasesamplingintervalsatellitehydrologyscarcecommodityscrapermatscrewingunitseawaterpumpsecondaryblocksecularclergyseismicefficiencyselectivediffusersemiasphalticfluxsemifinishmachiningspicetradespysale
stunguntacticaldiametertailstockcentertamecurvetapecorrectiontappingchucktaskreasoningtechnicalgradetelangiectaticlipomatelescopicdampertemperateclimatetemperedmeasuretenementbuildingtuchkasultramaficrockultraviolettesting
Re: ORA-01008: not all variables bound DURING RMAN BACKUP
обла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
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
Re: ORA-01008: not all variables bound DURING RMAN BACKUP
побе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ЗасоГорд
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ЗасоГорд