rman整库备份还原

整库丢失1登录rmanrmantarget/备份数据库和归档文件backupdatabaseplusarchivelogall;产看备份情况listbackup;4模拟数据变化createtabletest31asselect*fromdba_users;altersystemswitchlogfile;createtabletest32asselect*fromdba_users;altersystemswitchlogfile;createtabletest33asselect*fromdba_users;5删除整个数据库cd/home/app/oracle/oradatarmrfora-bsishi-4.2$rrn-rfora-bash-4.21Is-bash-J.2$sqlplus/口三&ysdbaSQLftPlus:Release12.2.o.1.oPraductlomonwedMar2110：oi:29zoisCopyright:[£)1982,2016,Oracle.Allrightsireservi@d.coiinnectedto>:aracieDatabase12cEnterpriseEditionRelease.0-64bitProduct1onsql>sekecr*fromtests?;,,tinSP2-O734:uiniknDwinicammandbseginning"sekect'f・・，”-restof1imeigmored.5Qm>selectstatusfromvSinstance;STATUSOPEN£Q4selectQfromtest31;select0fromte5t31Rerrorat1irue1"0HA-01116:errorinopeningdatabasef11te1ORA-01110;daitafile1:'/Fonie/app/oracle/Dradata/ora/systeinCIl.dbfORA-27041:unabletoopenflicLinuM-xE6_6JError:2:NosuchfilsordirectoiryAdditionalinformsrion:3数据库已经损坏6根据数据库启动流程，首先恢复spfileviinitora.oradb_name='ora':wq-bash-4.2$sqlplus/assysdbashutimmediateforce;还原数据库找到备份文件-bash-1-.21cdorabak-tush-4.2S1sORA_158949B431_20_1_20180B22_1,bkpORAJL5B949343L_22_1_2C180322_1.bkpORA_L58949B431_21_1_20180B22_1,bkpORA_15B949343L_2^_L_2C180322_1.bkprmantarget/进入rman设置dbid为备份片的idsetdbid=1589493431RMAN>3etcb1d-1589493431executingcommand:setdbidRMAN>restoreconzrclfi1€fromautobackup;StarTingrestoreatZZ-NAR-L8usingtargetdatabasecontrnlf-i1eInsteadof-"ecoverycatalogallocatedchannel:ORA_DISK_1channelaRA_DI5K_L;5ID=13+devicetype=DI5Kchannel0RAJDISK_1：look-jngforautobackuponday:?0180322channelOftA_DISK_l_:AJUTOBACKUPfound:c-15894934il-201E0222-02channelOFtA_DISK_l：restarinqcontrolfilefromAUTOBACKUPc-1.589493431-20CLB022202channtlora_di5ilJ-:conurulfilerescortrrumautobackupcomplereoutputtileiame=/hame/'app/Dracl&/oradata/ora/control01.ctloutputfileniamt=/hame/app/oracle/oradata/ora/rontral02.ct1Finishedrestoreat22-MAR-1.8rman>alterdatabasemount;Statementprocessedreleasedcliannel;ORfl_Dl5K_l.RMAN>1istbackup:还原数据库恢复控制文件restorecontrolfilefromautobackup;设置数据库为mount状态alterdatabasemount;恢复数据库restoredatabase;recoverdatabase;Startingrecoverat22-MAR-18usingchannelORA_DISK_1startingmediarecoveryarchivedlogforthread1withsequence10isalreadyondiskasfile/home/archivelog/1_10_971265017.dbfarchivedlogforthread1withsequence11isalreadyondiskasfile/home/archivelog/1_11_971265017.dbfarchivedlogfilename=/home/archivelog/1_10_971265017.dbfthread=1sequence=10archivedlogfilename=/home/archivelog/1_11_971265017.dbfthread=1sequence=11unabletofindarchivedlogarchivedlogthread=1sequence=12RMAN-00571:RMAN-00569:===============ERRORMESSAGESTACKFOLLOWS===============RMAN-00571:RMAN-03002:failureofrecovercommandat03/22/201813:57:25RMAN-06054:mediarecoveryrequestingunknownarchivedlogforthread1withsequence12andstartingScnof1879455开始恢复在22-MAR-18使用通道ORA_DISK_1媒体开始复苏以序列10为线程1的归档日志已经在磁盘上作为文件/home/archivelog/1_10_971265017.dbf。以序列11为线程1的归档日志已经在磁盘上作为文件/home/archivelog/1_11_971265017.dbf。归档日志文件名称=/home/archivelog_10_971265017/1。dbf线程=1序列=10归档日志文件名称=/home/archivelog_11_971265017/1。dbf线程=1=11序列无法找到归档日志。归档日志线程=1序列=12rman-00571:===========================================================rman-00569:错误消息堆栈如下==========rman-00571:===========================

口乂人只-03002:故障恢复命令在03/22/201813:57:25。RMAN-06054:媒体恢复请求未知存档的线程1的归档日志，并使用序列12和启动SCN(1879455)。报错找不到归档日志，用已下命令手动回复归档catalogstartwith'/home/archivelog/';restoredatabase;与cartingrestorear22-MAR-iaallocatedchannel;0RA_DI5K_lskippingdatafi1e5;skippingdatafileskippinqdatafileS;CharirtelDRA_DI5K^lichannelqra_DI5K_1zchannelORA_DI5K_1:channelORA^DT5K_1;channelDRA_DiSK^lichannel0RA_D15K_lzchannelORA_DI：5K_1:channelORA^DTSK-l;channelORA_Di5K^lichannelORA_DISK_1]channelORA_DI：5K_1]channelORA^DT5K_1;channelDRA_Di5K^liskippingdatafi1e5;skippingdatafileskippinqdatafileS;CharirtelDRA_DI5K^lichannelqra_DI5K_1zchannelORA_DI5K_1:channelORA^DT5K_1;channelDRA_DiSK^lichannel0RA_D15K_lzchannelORA_DI：5K_1:channelORA^DTSK-l;channelORA_Di5K^lichannelORA_DISK_1]channelORA_DI：5K_1]channelORA^DT5K_1;channelDRA_Di5K^lichannelqra_DISK_1zchannel0RA_DI：5K_lzchannel。代工DTSIC_1;channeloRA_Di5K_lichannelQRA_DISK._12channel0RA_D15K_lz001rdbfalreadyrestoredtofilealreacfyrestoredtofilealreadyrestoredtofile/Tiome/app/Dracle/oridata/Dra/pdbseed/systennDLtdbf/tiDme/'.app/ora.c1e/ar-adata/Dra/pcIbseed/sysauxOl.dbf/hcni»e/app/oracle/aradata/Dra/pdbseed/undatbs&l,dbfsrarc1ngdarafilebackupierrestor*specifyingdaraf11efsjrorestorefrombacku|3setrestoringrestarinqreiroringres-toringrestoringrectorinqreirorlnqreadingtipiec-eFar-datafiIe00009todatafil£ODCHDtodaiafUe0DQ11TOdatafile□D01ZTQdatafiIsOOG13tDdataf-ilt00G14todatafile0DQ15TDrombackuppiecey-hoine/app/Drac1e/oradata./ora/orapdb/systemOludbf/hGuwe/app/oracle/aradata/ara/orapdb/sjraauxOl,dbf,■■hame/app/orac1e/oradara/ara/orapdb/undorb£Ol.dbf/home/app/Dracle/oradai:a/orVorapdb/us^rsQl-dbfyhoine/app/Dracle/product/lZ.2.0/dbhone_l/dbs/icit;/hQn»e/app/oracle/pri?duct/12.2.0/dbhQBe_l/dbs/icit/TiDme./orabak/0RA_15B94[93i1!31_20_l_2aiB0322OM-l934131_20_1_201B0322_1.bkptag=TArestoredbackuppiece1resroreconplece,elapsedr1ns:00i00^45startingdarafilebackupsetrestorespecifyingdatafi1e(s)torestorefrombackupsetrestarinqdataf11-e00016to/home/app/oracle/oradata/ara/orapdbl/systerrK)!.dbfresrorlngdataflie0DQ17xo.^honw/app/oracle/ciradaLai/cipa/cirapdbl/sysauisOl.dbfrestoringdatafile0001Sto/horfte/app/Dracle/oradat;a/ora/orapdbl/undatbs01.dbfres-toringdmcafllw0DQ19to/home/app/Dracle/producx/lZ.2.Q/dbhone_l/dhs/orapdbl/;arapdbl_channelORA_DiSK^lichannelqra_DI5K._1zchannelORA_DISK_1]channel口RLDT5忆1:charmelORA_Di5K^lichannelQRA_DI5HL12channelqra_DISK_1zchannelORA^DT5K_1;channelDRA_DiSK^lichannel0RA_D15K_lzchannelQRA_DISK._12channelORA^DTSK-l;channelORA_Di5K^lichannelDRA^DISICl:Finishedrestorearreadlnqfrombackuppiece/home/orafcak/oHA-l5.B543J451_21_l_2Q160322J.bkppiec«fiandle=/yiDn>e/orabak/ORA_l569493«131_Z1_1_2Q1BO322J.bkptag=TAG201BD322Tia4013restoredbackuppiece1restoreconplete3slappedti«e;00:00:25srarc1ngdarafiIsbackupierrestorespecifyingdarafile(s)rorestorefrombackupsetresronng-dai:afil^ODOOlto/home/app/oracle/oradara/ora/sysremOl.dbfrestarinqdatafile00003to/hQme/app/oracle/Qraclata/Qra/sysauxGl,dbfreiror1ngdacaflie0DQ04td/hani»/app/oracle/ara.dai:a/ara/undci.rb£01.dbf/home/app/Dracle/orada.ta/ora/users01-dbfreadingfrombackuppiecej-TiD[ne/orabak/ORA_15B9«1934!31_22_l_2ai0O322_lBbkppiecefiandle-/hon>e/orabak/OB.flJ55-94^3431_22_1_2O180522-1.bkpta^r-TAG201SO3.22T1CM013reiraredbackupp11res-rorin1datafileQD0Q7res.tareconplete.,elapsedtine:OD:OD:2522-MAR-ia京arcingrecoverar22-MAR-iausingcFiannelOPA_DISK_1srarrlngsied-larecoveryunabletafindarchivedlogarchivedIgrhread-Hsequent:e-lDRMAN-aO571：———————一^一^一一^—^一^——RMAN-Q0569j==========ERftOftWE5sAeE.STACKFQl_L04<5===============WW-00571；————————————————rman-02002ifailureafrecoverCQiftnandac03/22/201313:55s51hman-06054itwdlarecaweryreques-ringunkne^narMved1egfarthread1^ixhsequenceIDandsrardngscnoflE7fi762hman>caralogsr-arrwlih'/hDrUE/缶FEhlwelciq/';

REAN>recoverdatabase：srarrlnqrecoverar22-kar-16usingchannel]OR^_DISK_1startingmediar-ecaveryunabletofindarchived1Dgarchived1oqthrcad-1sequence-lORmN-OD5711RM.AN-O05W；ERRORMESSAGESTACKFOLLOWS-RKAN-OD5711————————————————————RFAN-03002sfailureofrecovercoirmand■Q3/22/Z01BJ.业55:51.rnlan-06054:mediarecoveryrequestingunknain*rch1vedlogTorThread1囚innsequence10artdsrarrlrgscnat1B7S762rfanacatalogsr-arriwlrhk/hDiie/arch1ve.l0g/hssearchingforallfilies,rharHarchrheparrern/home/archi^elog/LiarafFilesunfcn口啪ro(henarabaseFileNarpe;/hofie/iarchivelDg/l-lOJ?12e5017.dbfFileMame:,-'ho*e/aKchivelog/i_ll_971ZS5017.dbfdoyoureallywantrecacalagrheabovefiles(emeryesornd)?yescaralogingfi1esn..cdcalogingdoneListofCatalogedFilesFileNan>e;/hofie/archivelog/l_10J712^5017.dbfFileName:/hotie;archilvelog/UUJl265017.dbfrklan>recouerdazabaseStartingrecoverar2Z-MAR-1EusingcRanneTOR^_DISK_1startingmediarecovery.archived1ogforThread1wixhsequence10isalreadyondiskasfllw/lione/archivelog/l_10_971265017.cbfarchived1agfarthread1withaequence11iisa.1readyandiskas-file/hone/archiiwclogli,,l_ll_9712fi5017.dbfarchived1ogfil-enaine=/liDnfre/arc:hivelo<|/l_10_971265017.dbfT：hread=lsequence=lQarchived1ogfilename-yTiofwe/archixrelDg/l_ll_^712^5017Bdbfthread-1sequence-lLurablerofindarchived1ogarchived1oqthr-ead-1sequ纪门cw-12rmn-00571:"===一======-=====一===—===============一======一=====REAN-OD569：===========ERRORIME55BESTACKFOLLOWS==========RKAN-OD571：■■■■■■■■■■■■―REAN-03002sfailureofrecovercorrniiand■03/22/201B13s57：25RM.an-O6O5^;mediarecov-eryrequestinqunknownarchivedlogforthread1withsequence12andstartingsenoflfi-94.55RKLANyexitRecoveryManager匚口mpl电七七」-bash-4,21sqlplus/a5sysdba5QL*Plus;Releas-e.0Praduction口口ThuM/2214;00;132018rnan>recoverdatabase;srarrimgrecoverat22-KjiK-iaus"IngchannelaftA_DiSK_lstart!ngmediarecoveryunablet&findarchivedlogarchivedlugthread=ls€quence=10-R^AN-QO571：===========================================================胪AN-0055gl========ERRORIME5SA石ESTACKFOLLOWS========R^AN-QO5F1：=======================================R^AN-O3OD-2sfailureofrecovercammardar03/22/2D1E5-5:51R^AN-06054suMsdimrecov-eryrequestingunknownarchivedlogforthread1withs€quenc-e10andstartingSCN&f1S78762_'catalogstartwith'./home/arctiivelag/";searchingforal1filesthatmatchthepattern/home/archive1og/ListofFilesunknowntatheDatabaseFileName;/home/arcliiv-elag/l_10_3712C5017.dbfFi1eNa.me;/hQ«/archiv«lQg/l_lU712€5017,dbfDoyoureally*vanttocatalogtheabovefiles(enterYESnno”yes匚3131口。1「用files,cataloglriigdone：LlsrofcatalogedFilesf1lehiam白:/toifte/arclilvelaq/l_10_971265D17.dbfFllehianie:/luoifte/arclilvelag/l_ll_971265D17.dbfrnanvrecoverdacabaiseStaifTingrecoverau22-KJUl-iausingchannelora^diskJstarx：!ngmediarecoveryarchivedlogforthread1withsequ-enceIDisalreadycodiska与file/home/arcliivelog/UD_971265017udbfarchived1ogforthread1withsegu-ertce11isalreadyondiska与file/home/archivelog/Ul_971265017udbfarchived1ogfileRame=/hon}e.<ar€li~ivelog/1_1D_971265D171dbfThr€ad=lsequ€nce=LQ'archived1ogf1leRarfte=/honfre/archivelog/l_il_971265D17.dbfThr-ead=lsequence=]llunableto-findarchivedlog"archivedlogt.hread=lsequence=12Q057[g=============~二二二=二============================RPAN-0G56g：===============ERRORMESSAGESTOZKFOLLanS===========Rf^AN-"00'5".a'1z———————————————————————————R^.AN-0300-2;failureofrecovercommandat03/22/201811;S7;2SRP.AN-06054;mediarecoveryrequestingunknownarchivedlogforthread1withsequence12andstarting5cMuf187纲55-'RWAN>exit刷新数据库日志SQL>alterdatabaseopenresetlogs;Databasealtered.SQL>selectstatusfromv$instance;STATUSOPEN查看原来创建的test313233回复回来没有了完成数据库恢复下面是一些报错的记录RMAN>recoverdatabase;Startingrecoverat22-MAR-18usingchannelORA_DISK_1startingmediarecoveryunabletofindarchivedlogarchivedlogthread=1sequence=10RMAN-00571:RMAN-00569:===============ERRORMESSAGESTACKFOLLOWSRMAN-00571:RMAN-03002:failureofrecovercommandat03/22/201813:55:51RMAN-06054:mediarecoveryrequestingunk