RMAN如何实现完全恢复错误
这篇文章主要为大家展示了“RMAN如何实现完全恢复错误”,内容简而易懂,条理清晰,希望能够帮助大家解决疑惑,下面让小编带领大家一起研究并学习一下“RMAN如何实现完全恢复错误”这篇文章吧。
RMAN恢复案例:
用户在做rman的恢复时遇到以下错误:
RMAN> restore database from tag='TAG20140923T160003';
Startingrestoreat24-SEP-14allocatedchannel:ORA_DISK_1channelORA_DISK_1:sid=156devtype=DISKallocatedchannel:ORA_DISK_2channelORA_DISK_2:sid=147devtype=DISKchannelORA_DISK_2:startingdatafilebackupsetrestorechannelORA_DISK_2:specifyingdatafile(s)torestorefrombackupsetrestoringdatafile00001to/u01/app/oracle/oradata/prod/system01.dbfrestoringdatafile00004to/u01/app/oracle/oradata/prod/users01.dbfchannelORA_DISK_2:readingfrombackuppiece/backup/rman_bak/lv0_PROD_111_859046404.bakchannelORA_DISK_1:startingdatafilebackupsetrestorechannelORA_DISK_1:specifyingdatafile(s)torestorefrombackupsetrestoringdatafile00002to/u01/app/oracle/oradata/prod/undotbs01.dbfrestoringdatafile00003to/u01/app/oracle/oradata/prod/sysaux01.dbfrestoringdatafile00005to/u01/app/oracle/oradata/prod/example01.dbfchannelORA_DISK_1:readingfrombackuppiece/backup/rman_bak/lv0_PROD_112_859046404.bakchannelORA_DISK_1:restoredbackuppiece1piecehandle=/backup/rman_bak/lv0_PROD_112_859046404.baktag=TAG20140923T160003channelORA_DISK_1:restorecomplete,elapsedtime:00:00:35channelORA_DISK_2:restoredbackuppiece1piecehandle=/backup/rman_bak/lv0_PROD_111_859046404.baktag=TAG20140923T160003channelORA_DISK_2:restorecomplete,elapsedtime:00:00:35Finishedrestoreat24-SEP-14
RMAN> recover database;
Startingrecoverat24-SEP-14usingchannelORA_DISK_1usingchannelORA_DISK_2channelORA_DISK_1:startingincrementaldatafilebackupsetrestorechannelORA_DISK_1:specifyingdatafile(s)torestorefrombackupsetdestinationforrestoreofdatafile00001:/u01/app/oracle/oradata/prod/system01.dbfdestinationforrestoreofdatafile00004:/u01/app/oracle/oradata/prod/users01.dbfchannelORA_DISK_1:readingfrombackuppiece/backup/rman_bak/lvl1_PROD_118_859047306.bakchannelORA_DISK_2:startingincrementaldatafilebackupsetrestorechannelORA_DISK_2:specifyingdatafile(s)torestorefrombackupsetdestinationforrestoreofdatafile00002:/u01/app/oracle/oradata/prod/undotbs01.dbfdestinationforrestoreofdatafile00003:/u01/app/oracle/oradata/prod/sysaux01.dbfdestinationforrestoreofdatafile00005:/u01/app/oracle/oradata/prod/example01.dbfchannelORA_DISK_2:readingfrombackuppiece/backup/rman_bak/lvl1_PROD_119_859047306.bakchannelORA_DISK_1:restoredbackuppiece1piecehandle=/backup/rman_bak/lvl1_PROD_118_859047306.baktag=TAG20140923T161506channelORA_DISK_1:restorecomplete,elapsedtime:00:00:01channelORA_DISK_1:startingincrementaldatafilebackupsetrestorechannelORA_DISK_1:specifyingdatafile(s)torestorefrombackupsetdestinationforrestoreofdatafile00001:/u01/app/oracle/oradata/prod/system01.dbfdestinationforrestoreofdatafile00004:/u01/app/oracle/oradata/prod/users01.dbfchannelORA_DISK_1:readingfrombackuppiece/backup/rman_bak/lvl1_PROD_125_859048203.bakchannelORA_DISK_1:restoredbackuppiece1piecehandle=/backup/rman_bak/lvl1_PROD_125_859048203.baktag=TAG20140923T163003channelORA_DISK_1:restorecomplete,elapsedtime:00:00:01channelORA_DISK_2:restoredbackuppiece1piecehandle=/backup/rman_bak/lvl1_PROD_119_859047306.baktag=TAG20140923T161506channelORA_DISK_2:restorecomplete,elapsedtime:00:00:03channelORA_DISK_1:startingincrementaldatafilebackupsetrestorechannelORA_DISK_1:specifyingdatafile(s)torestorefrombackupsetdestinationforrestoreofdatafile00001:/u01/app/oracle/oradata/prod/system01.dbfdestinationforrestoreofdatafile00004:/u01/app/oracle/oradata/prod/users01.dbfchannelORA_DISK_1:readingfrombackuppiece/backup/rman_bak/lvl1_PROD_132_859049103.bakchannelORA_DISK_2:startingincrementaldatafilebackupsetrestorechannelORA_DISK_2:specifyingdatafile(s)torestorefrombackupsetdestinationforrestoreofdatafile00002:/u01/app/oracle/oradata/prod/undotbs01.dbfdestinationforrestoreofdatafile00003:/u01/app/oracle/oradata/prod/sysaux01.dbfdestinationforrestoreofdatafile00005:/u01/app/oracle/oradata/prod/example01.dbfchannelORA_DISK_2:readingfrombackuppiece/backup/rman_bak/lvl1_PROD_126_859048203.bakchannelORA_DISK_1:restoredbackuppiece1piecehandle=/backup/rman_bak/lvl1_PROD_132_859049103.baktag=TAG20140923T164503channelORA_DISK_1:restorecomplete,elapsedtime:00:00:01channelORA_DISK_2:restoredbackuppiece1piecehandle=/backup/rman_bak/lvl1_PROD_126_859048203.baktag=TAG20140923T163003channelORA_DISK_2:restorecomplete,elapsedtime:00:00:01channelORA_DISK_1:startingincrementaldatafilebackupsetrestorechannelORA_DISK_1:specifyingdatafile(s)torestorefrombackupsetdestinationforrestoreofdatafile00002:/u01/app/oracle/oradata/prod/undotbs01.dbfdestinationforrestoreofdatafile00003:/u01/app/oracle/oradata/prod/sysaux01.dbfdestinationforrestoreofdatafile00005:/u01/app/oracle/oradata/prod/example01.dbfchannelORA_DISK_1:readingfrombackuppiece/backup/rman_bak/lvl1_PROD_133_859049103.bakchannelORA_DISK_1:restoredbackuppiece1piecehandle=/backup/rman_bak/lvl1_PROD_133_859049103.baktag=TAG20140923T164503channelORA_DISK_1:restorecomplete,elapsedtime:00:00:01startingmediarecoveryarchivelogthread1sequence90isalreadyondiskasfile/arch/1_90_858969934.dbfarchivelogthread1sequence91isalreadyondiskasfile/arch/1_91_858969934.dbfarchivelogthread1sequence92isalreadyondiskasfile/disk1/prod/redo01.logarchivelogthread1sequence93isalreadyondiskasfile/disk1/prod/redo02.logOracleError:ORA-01547:warning:RECOVERsucceededbutOPENRESETLOGSwouldgeterrorbelowORA-01152:file2wasnotrestoredfromasufficientlyoldbackupORA-01110:datafile2:'/u01/app/oracle/oradata/prod/undotbs01.dbf'RMAN-00571:===========================================================RMAN-00569:===============ERRORMESSAGESTACKFOLLOWS===============RMAN-00571:===========================================================RMAN-03002:failureofrecovercommandat09/24/201417:34:18RMAN-06053:unabletoperformmediarecoverybecauseofmissinglogRMAN-06025:nobackupoflogthread1seq89lowscn647354foundtorestoreRMAN-06025:nobackupoflogthread1seq88lowscn647258foundtorestoreRMAN-06025:nobackupoflogthread1seq87lowscn647242foundtorestoreRMAN-06025:nobackupoflogthread1seq86lowscn646972foundtorestoreRMAN-06025:nobackupoflogthread1seq85lowscn646637foundtorestoreRMAN-06025:nobackupoflogthread1seq84lowscn646623foundtorestoreRMAN-06025:nobackupoflogthread1seq83lowscn646593foundtorestoreRMAN-06025:nobackupoflogthread1seq82lowscn645884foundtorestoreRMAN-06025:nobackupoflogthread1seq81lowscn645864foundtorestoreRMAN-06025:nobackupoflogthread1seq80lowscn645835foundtorestoreRMAN-06025:nobackupoflogthread1seq79lowscn645431foundtorestoreRMAN-06025:nobackupoflogthread1seq78lowscn645415foundtorestore
恢复失败,提示undo tablespace recover failure!
查看告警日志:
Theinputbackuppiece/backup/rman_bak/lv0_PROD_111_859046404.bakisincompressedformat.WedSep2417:32:412014Theinputbackuppiece/backup/rman_bak/lv0_PROD_112_859046404.bakisincompressedformat.WedSep2417:32:422014Fullrestorecompleteofdatafile4/u01/app/oracle/oradata/prod/users01.dbf.Elapsedtime:0:00:01checkpointis642397WedSep2417:32:482014Fullrestorecompleteofdatafile2/u01/app/oracle/oradata/prod/undotbs01.dbf.Elapsedtime:0:00:07checkpointis642399WedSep2417:33:022014Fullrestorecompleteofdatafile5/u01/app/oracle/oradata/prod/example01.dbf.Elapsedtime:0:00:20checkpointis642399Fullrestorecompleteofdatafile3/u01/app/oracle/oradata/prod/sysaux01.dbf.Elapsedtime:0:00:25checkpointis642399WedSep2417:33:142014Fullrestorecompleteofdatafile1/u01/app/oracle/oradata/prod/system01.dbf.Elapsedtime:0:00:33checkpointis642397WedSep2417:34:122014Theinputbackuppiece/backup/rman_bak/lvl1_PROD_118_859047306.bakisincompressedformat.WedSep2417:34:122014Theinputbackuppiece/backup/rman_bak/lvl1_PROD_119_859047306.bakisincompressedformat.WedSep2417:34:132014Incrementalrestorecompleteofdatafile4/u01/app/oracle/oradata/prod/users01.dbfcheckpointis642881WedSep2417:34:132014Incrementalrestorecompleteofdatafile5/u01/app/oracle/oradata/prod/example01.dbfcheckpointis642883WedSep2417:34:132014Incrementalrestorecompleteofdatafile1/u01/app/oracle/oradata/prod/system01.dbfcheckpointis642881WedSep2417:34:132014Incrementalrestorecompleteofdatafile2/u01/app/oracle/oradata/prod/undotbs01.dbfcheckpointis642883WedSep2417:34:142014Theinputbackuppiece/backup/rman_bak/lvl1_PROD_125_859048203.bakisincompressedformat.Incrementalrestorecompleteofdatafile4/u01/app/oracle/oradata/prod/users01.dbfcheckpointis643340WedSep2417:34:142014Incrementalrestorecompleteofdatafile3/u01/app/oracle/oradata/prod/sysaux01.dbfcheckpointis642883WedSep2417:34:142014Incrementalrestorecompleteofdatafile1/u01/app/oracle/oradata/prod/system01.dbfcheckpointis643340Theinputbackuppiece/backup/rman_bak/lvl1_PROD_132_859049103.bakisincompressedformat.WedSep2417:34:152014Theinputbackuppiece/backup/rman_bak/lvl1_PROD_126_859048203.bakisincompressedformat.WedSep2417:34:152014Incrementalrestorecompleteofdatafile4/u01/app/oracle/oradata/prod/users01.dbfcheckpointis643737WedSep2417:34:152014Incrementalrestorecompleteofdatafile5/u01/app/oracle/oradata/prod/example01.dbfcheckpointis643342WedSep2417:34:152014Incrementalrestorecompleteofdatafile1/u01/app/oracle/oradata/prod/system01.dbfcheckpointis643737WedSep2417:34:152014Incrementalrestorecompleteofdatafile3/u01/app/oracle/oradata/prod/sysaux01.dbfcheckpointis643342Incrementalrestorecompleteofdatafile2/u01/app/oracle/oradata/prod/undotbs01.dbfcheckpointis643342WedSep2417:34:162014Theinputbackuppiece/backup/rman_bak/lvl1_PROD_133_859049103.bakisincompressedformat.Incrementalrestorecompleteofdatafile5/u01/app/oracle/oradata/prod/example01.dbfcheckpointis643739Incrementalrestorecompleteofdatafile3/u01/app/oracle/oradata/prod/sysaux01.dbfcheckpointis643739Incrementalrestorecompleteofdatafile2/u01/app/oracle/oradata/prod/undotbs01.dbfcheckpointis643739WedSep2417:34:172014alterdatabaserecoverdatafilelistclearWedSep2417:34:172014Completed:alterdatabaserecoverdatafilelistclearWedSep2417:34:172014alterdatabaserecoverdatafilelist1,2,3,4,5Completed:alterdatabaserecoverdatafilelist1,2,3,4,5WedSep2417:34:172014alterdatabaserecoverifneededstartuntilcancelusingbackupcontrolfileMediaRecoveryStartparallelrecoverystartedwith3processesORA-279signalledduring:alterdatabaserecoverifneededstartuntilcancelusingbackupcontrolfile...WedSep2417:34:182014alterdatabaserecovercancelSignallingerror1152fordatafile2!ORA-1547signalledduring:alterdatabaserecovercancel...WedSep2417:34:562014controlfileheadervalidationfailureforfile/backup/rman_bak/ctl1_166.bakWedSep2417:35:532014Theinputbackuppiece/backup/rman_bak/ctl1_166.bakisincompressedformat.
解决方法:
通过备份的controlfile进行恢复
RMAN> list backup of controlfile;
但是通过rman查看备份的controlfile信息时,却没有!
还好,在磁盘上找到一个控制文件的backup piece!
加载到rman metadata中:
RMAN> catalog backuppiece '/backup/rman_bak/ctl1_166.bak';
catalogedbackuppiecebackuppiecehandle=/backup/rman_bak/ctl1_166.bakrecid=191stamp=859138553
RMAN> list backup of controlfile;
ListofBackupSets===================BSKeyTypeLVSizeDeviceTypeElapsedTimeCompletionTime-------------------------------------------------------------162Full1.06MDISK00:00:0123-SEP-14BPKey:191Status:AVAILABLECompressed:YESTag:TAG20140923T174510PieceName:/backup/rman_bak/ctl1_166.bakControlFileIncluded:CkpSCN:645423Ckptime:23-SEP-14
查看备份信息:
RMAN> list backup of database ;
ListofBackupSets===================BSKeyTypeLVSizeDeviceTypeElapsedTimeCompletionTime-------------------------------------------------------------107Incr036.22MDISK00:06:1923-SEP-14BPKey:107Status:AVAILABLECompressed:YESTag:TAG20140923T160003PieceName:/backup/rman_bak/lv0_PROD_112_859046404.bakListofDatafilesinbackupset107FileLVTypeCkpSCNCkpTimeName---------------------------------20Incr64239923-SEP-14/u01/app/oracle/oradata/prod/undotbs01.dbf30Incr64239923-SEP-14/u01/app/oracle/oradata/prod/sysaux01.dbf50Incr64239923-SEP-14/u01/app/oracle/oradata/prod/example01.dbfBSKeyTypeLVSizeDeviceTypeElapsedTimeCompletionTime-------------------------------------------------------------108Incr081.68MDISK00:06:3023-SEP-14BPKey:108Status:AVAILABLECompressed:YESTag:TAG20140923T160003PieceName:/backup/rman_bak/lv0_PROD_111_859046404.bakListofDatafilesinbackupset108FileLVTypeCkpSCNCkpTimeName---------------------------------10Incr64239723-SEP-14/u01/app/oracle/oradata/prod/system01.dbf40Incr64239723-SEP-14/u01/app/oracle/oradata/prod/users01.dbfBSKeyTypeLVSizeDeviceTypeElapsedTimeCompletionTime-------------------------------------------------------------114Incr1216.00KDISK00:00:0123-SEP-14BPKey:114Status:AVAILABLECompressed:YESTag:TAG20140923T161506PieceName:/backup/rman_bak/lvl1_PROD_118_859047306.bakListofDatafilesinbackupset114FileLVTypeCkpSCNCkpTimeName---------------------------------11Incr64288123-SEP-14/u01/app/oracle/oradata/prod/system01.dbf41Incr64288123-SEP-14/u01/app/oracle/oradata/prod/users01.dbfBSKeyTypeLVSizeDeviceTypeElapsedTimeCompletionTime-------------------------------------------------------------115Incr11.09MDISK00:00:0523-SEP-14BPKey:115Status:AVAILABLECompressed:YESTag:TAG20140923T161506PieceName:/backup/rman_bak/lvl1_PROD_119_859047306.bakListofDatafilesinbackupset115FileLVTypeCkpSCNCkpTimeName---------------------------------21Incr64288323-SEP-14/u01/app/oracle/oradata/prod/undotbs01.dbf31Incr64288323-SEP-14/u01/app/oracle/oradata/prod/sysaux01.dbf51Incr64288323-SEP-14/u01/app/oracle/oradata/prod/example01.dbfBSKeyTypeLVSizeDeviceTypeElapsedTimeCompletionTime-------------------------------------------------------------121Incr1168.00KDISK00:00:0123-SEP-14BPKey:121Status:AVAILABLECompressed:YESTag:TAG20140923T163003PieceName:/backup/rman_bak/lvl1_PROD_125_859048203.bakListofDatafilesinbackupset121FileLVTypeCkpSCNCkpTimeName---------------------------------11Incr64334023-SEP-14/u01/app/oracle/oradata/prod/system01.dbf41Incr64334023-SEP-14/u01/app/oracle/oradata/prod/users01.dbfBSKeyTypeLVSizeDeviceTypeElapsedTimeCompletionTime-------------------------------------------------------------122Incr1240.00KDISK00:00:0123-SEP-14BPKey:122Status:AVAILABLECompressed:YESTag:TAG20140923T163003PieceName:/backup/rman_bak/lvl1_PROD_126_859048203.bakListofDatafilesinbackupset122FileLVTypeCkpSCNCkpTimeName---------------------------------21Incr64334223-SEP-14/u01/app/oracle/oradata/prod/undotbs01.dbf31Incr64334223-SEP-14/u01/app/oracle/oradata/prod/sysaux01.dbf51Incr64334223-SEP-14/u01/app/oracle/oradata/prod/example01.dbfBSKeyTypeLVSizeDeviceTypeElapsedTimeCompletionTime-------------------------------------------------------------128Incr1192.00KDISK00:00:0123-SEP-14BPKey:128Status:AVAILABLECompressed:YESTag:TAG20140923T164503PieceName:/backup/rman_bak/lvl1_PROD_132_859049103.bakListofDatafilesinbackupset128FileLVTypeCkpSCNCkpTimeName---------------------------------11Incr64373723-SEP-14/u01/app/oracle/oradata/prod/system01.dbf41Incr64373723-SEP-14/u01/app/oracle/oradata/prod/users01.dbfBSKeyTypeLVSizeDeviceTypeElapsedTimeCompletionTime-------------------------------------------------------------129Incr1240.00KDISK00:00:0123-SEP-14BPKey:129Status:AVAILABLECompressed:YESTag:TAG20140923T164503PieceName:/backup/rman_bak/lvl1_PROD_133_859049103.bakListofDatafilesinbackupset129FileLVTypeCkpSCNCkpTimeName---------------------------------21Incr64373923-SEP-14/u01/app/oracle/oradata/prod/undotbs01.dbf31Incr64373923-SEP-14/u01/app/oracle/oradata/prod/sysaux01.dbf51Incr64373923-SEP-14/u01/app/oracle/oradata/prod/example01.dbfBSKeyTypeLVSizeDeviceTypeElapsedTimeCompletionTime-------------------------------------------------------------135Incr036.26MDISK00:01:4023-SEP-14BPKey:135Status:AVAILABLECompressed:YESTag:TAG20140923T170004PieceName:/backup/rman_bak/lv0_PROD_140_859050004.bakListofDatafilesinbackupset135FileLVTypeCkpSCNCkpTimeName---------------------------------20Incr64412123-SEP-14/u01/app/oracle/oradata/prod/undotbs01.dbf30Incr64412123-SEP-14/u01/app/oracle/oradata/prod/sysaux01.dbf50Incr64412123-SEP-14/u01/app/oracle/oradata/prod/example01.dbfBSKeyTypeLVSizeDeviceTypeElapsedTimeCompletionTime-------------------------------------------------------------138Incr081.69MDISK00:02:1823-SEP-14BPKey:138Status:AVAILABLECompressed:YESTag:TAG20140923T170004PieceName:/backup/rman_bak/lv0_PROD_139_859050004.bakListofDatafilesinbackupset138FileLVTypeCkpSCNCkpTimeName---------------------------------10Incr64411923-SEP-14/u01/app/oracle/oradata/prod/system01.dbf40Incr64411923-SEP-14/u01/app/oracle/oradata/prod/users01.dbfBSKeyTypeLVSizeDeviceTypeElapsedTimeCompletionTime-------------------------------------------------------------142Incr1112.00KDISK00:00:0123-SEP-14BPKey:142Status:AVAILABLECompressed:YESTag:TAG20140923T171504PieceName:/backup/rman_bak/lvl1_PROD_146_859050904.bakListofDatafilesinbackupset142FileLVTypeCkpSCNCkpTimeName---------------------------------11Incr64456223-SEP-14/u01/app/oracle/oradata/prod/system01.dbf41Incr64456223-SEP-14/u01/app/oracle/oradata/prod/users01.dbfBSKeyTypeLVSizeDeviceTypeElapsedTimeCompletionTime-------------------------------------------------------------143Incr11.09MDISK00:00:0223-SEP-14BPKey:143Status:AVAILABLECompressed:YESTag:TAG20140923T171504PieceName:/backup/rman_bak/lvl1_PROD_147_859050904.bakListofDatafilesinbackupset143FileLVTypeCkpSCNCkpTimeName---------------------------------21Incr64456423-SEP-14/u01/app/oracle/oradata/prod/undotbs01.dbf31Incr64456423-SEP-14/u01/app/oracle/oradata/prod/sysaux01.dbf51Incr64456423-SEP-14/u01/app/oracle/oradata/prod/example01.dbfBSKeyTypeLVSizeDeviceTypeElapsedTimeCompletionTime-------------------------------------------------------------149Incr1152.00KDISK00:00:0123-SEP-14BPKey:149Status:AVAILABLECompressed:YESTag:TAG20140923T173003PieceName:/backup/rman_bak/lvl1_PROD_153_859051804.bakListofDatafilesinbackupset149FileLVTypeCkpSCNCkpTimeName---------------------------------11Incr64500723-SEP-14/u01/app/oracle/oradata/prod/system01.dbf41Incr64500723-SEP-14/u01/app/oracle/oradata/prod/users01.dbfBSKeyTypeLVSizeDeviceTypeElapsedTimeCompletionTime-------------------------------------------------------------150Incr1240.00KDISK00:00:0123-SEP-14BPKey:150Status:AVAILABLECompressed:YESTag:TAG20140923T173003PieceName:/backup/rman_bak/lvl1_PROD_154_859051804.bakListofDatafilesinbackupset150FileLVTypeCkpSCNCkpTimeName---------------------------------21Incr64500923-SEP-14/u01/app/oracle/oradata/prod/undotbs01.dbf31Incr64500923-SEP-14/u01/app/oracle/oradata/prod/sysaux01.dbf51Incr64500923-SEP-14/u01/app/oracle/oradata/prod/example01.dbfBSKeyTypeLVSizeDeviceTypeElapsedTimeCompletionTime-------------------------------------------------------------156Incr1232.00KDISK00:00:0123-SEP-14BPKey:156Status:AVAILABLECompressed:YESTag:TAG20140923T174503PieceName:/backup/rman_bak/lvl1_PROD_161_859052703.bakListofDatafilesinbackupset156FileLVTypeCkpSCNCkpTimeName---------------------------------21Incr64540723-SEP-14/u01/app/oracle/oradata/prod/undotbs01.dbf31Incr64540723-SEP-14/u01/app/oracle/oradata/prod/sysaux01.dbf51Incr64540723-SEP-14/u01/app/oracle/oradata/prod/example01.dbfBSKeyTypeLVSizeDeviceTypeElapsedTimeCompletionTime-------------------------------------------------------------157Incr1128.00KDISK00:00:0123-SEP-14BPKey:157Status:AVAILABLECompressed:YESTag:TAG20140923T174503PieceName:/backup/rman_bak/lvl1_PROD_160_859052703.bakListofDatafilesinbackupset157FileLVTypeCkpSCNCkpTimeName---------------------------------11Incr64540523-SEP-14/u01/app/oracle/oradata/prod/system01.dbf41Incr64540523-SEP-14/u01/app/oracle/oradata/prod/users01.dbf
控制文件的备份是在9月23日,17:45分,选择9月23日17:00的0级数据文件备份进行数据文件的转储!
转储控制文件:
RMAN>shutdownabort;OracleinstanceshutdownRMAN>startupnomount;connectedtotargetdatabase(notstarted)OracleinstancestartedTotalSystemGlobalArea570425344bytesFixedSize2022480bytesVariableSize184550320bytesDatabaseBuffers377487360bytesRedoBuffers6365184bytesRMAN>restorecontrolfilefrom'/backup/rman_bak/ctl1_166.bak';Startingrestoreat24-SEP-14allocatedchannel:ORA_DISK_1channelORA_DISK_1:sid=156devtype=DISKallocatedchannel:ORA_DISK_2channelORA_DISK_2:sid=155devtype=DISKchannelORA_DISK_2:skipped,autobackupalreadyfoundchannelORA_DISK_1:restoringcontrolfilechannelORA_DISK_1:restorecomplete,elapsedtime:00:00:11outputfilename=/u01/app/oracle/oradata/prod/control01.ctloutputfilename=/disk1/prod/control02.ctloutputfilename=/disk2/prod/control03.ctlFinishedrestoreat24-SEP-14
转储数据文件:
RMAN> alter database mount;
databasemountedreleasedchannel:ORA_DISK_1releasedchannel:ORA_DISK_2
RMAN> restore database from tag='TAG20140923T170004';
Startingrestoreat24-SEP-14allocatedchannel:ORA_DISK_1channelORA_DISK_1:sid=155devtype=DISKallocatedchannel:ORA_DISK_2channelORA_DISK_2:sid=156devtype=DISKchannelORA_DISK_2:startingdatafilebackupsetrestorechannelORA_DISK_2:specifyingdatafile(s)torestorefrombackupsetrestoringdatafile00001to/u01/app/oracle/oradata/prod/system01.dbfrestoringdatafile00004to/u01/app/oracle/oradata/prod/users01.dbfchannelORA_DISK_2:readingfrombackuppiece/backup/rman_bak/lv0_PROD_139_859050004.bakchannelORA_DISK_1:startingdatafilebackupsetrestorechannelORA_DISK_1:specifyingdatafile(s)torestorefrombackupsetrestoringdatafile00002to/u01/app/oracle/oradata/prod/undotbs01.dbfrestoringdatafile00003to/u01/app/oracle/oradata/prod/sysaux01.dbfrestoringdatafile00005to/u01/app/oracle/oradata/prod/example01.dbfchannelORA_DISK_1:readingfrombackuppiece/backup/rman_bak/lv0_PROD_140_859050004.bakchannelORA_DISK_1:restoredbackuppiece1piecehandle=/backup/rman_bak/lv0_PROD_140_859050004.baktag=TAG20140923T170004channelORA_DISK_1:restorecomplete,elapsedtime:00:00:35channelORA_DISK_2:restoredbackuppiece1piecehandle=/backup/rman_bak/lv0_PROD_139_859050004.baktag=TAG20140923T170004channelORA_DISK_2:restorecomplete,elapsedtime:00:00:35Finishedrestoreat24-SEP-14
查看转储后的数据文件和控制文件的checkpoint:
SQL>colnamefora50SQL>r1*selectname,checkpoint_change#fromv$datafileNAMECHECKPOINT_CHANGE#--------------------------------------------------------------------/u01/app/oracle/oradata/prod/system01.dbf645405/u01/app/oracle/oradata/prod/undotbs01.dbf645407/u01/app/oracle/oradata/prod/sysaux01.dbf645407/u01/app/oracle/oradata/prod/users01.dbf645405/u01/app/oracle/oradata/prod/example01.dbf645407SQL>selectname,checkpoint_change#fromv$datafile_header;NAMECHECKPOINT_CHANGE#--------------------------------------------------------------------/u01/app/oracle/oradata/prod/system01.dbf644119/u01/app/oracle/oradata/prod/undotbs01.dbf644121/u01/app/oracle/oradata/prod/sysaux01.dbf644121/u01/app/oracle/oradata/prod/users01.dbf644119/u01/app/oracle/oradata/prod/example01.dbf644121
对database做recover:
RMAN> recover database;
Startingrecoverat24-SEP-14usingchannelORA_DISK_1usingchannelORA_DISK_2channelORA_DISK_1:startingincrementaldatafilebackupsetrestorechannelORA_DISK_1:specifyingdatafile(s)torestorefrombackupsetdestinationforrestoreofdatafile00001:/u01/app/oracle/oradata/prod/system01.dbfdestinationforrestoreofdatafile00004:/u01/app/oracle/oradata/prod/users01.dbfchannelORA_DISK_1:readingfrombackuppiece/backup/rman_bak/lvl1_PROD_146_859050904.bakchannelORA_DISK_2:startingincrementaldatafilebackupsetrestorechannelORA_DISK_2:specifyingdatafile(s)torestorefrombackupsetdestinationforrestoreofdatafile00002:/u01/app/oracle/oradata/prod/undotbs01.dbfdestinationforrestoreofdatafile00003:/u01/app/oracle/oradata/prod/sysaux01.dbfdestinationforrestoreofdatafile00005:/u01/app/oracle/oradata/prod/example01.dbfchannelORA_DISK_2:readingfrombackuppiece/backup/rman_bak/lvl1_PROD_147_859050904.bakchannelORA_DISK_1:restoredbackuppiece1piecehandle=/backup/rman_bak/lvl1_PROD_146_859050904.baktag=TAG20140923T171504channelORA_DISK_1:restorecomplete,elapsedtime:00:00:01channelORA_DISK_1:startingincrementaldatafilebackupsetrestorechannelORA_DISK_1:specifyingdatafile(s)torestorefrombackupsetdestinationforrestoreofdatafile00001:/u01/app/oracle/oradata/prod/system01.dbfdestinationforrestoreofdatafile00004:/u01/app/oracle/oradata/prod/users01.dbfchannelORA_DISK_1:readingfrombackuppiece/backup/rman_bak/lvl1_PROD_153_859051804.bakchannelORA_DISK_2:restoredbackuppiece1piecehandle=/backup/rman_bak/lvl1_PROD_147_859050904.baktag=TAG20140923T171504channelORA_DISK_2:restorecomplete,elapsedtime:00:00:02channelORA_DISK_2:startingincrementaldatafilebackupsetrestorechannelORA_DISK_2:specifyingdatafile(s)torestorefrombackupsetdestinationforrestoreofdatafile00002:/u01/app/oracle/oradata/prod/undotbs01.dbfdestinationforrestoreofdatafile00003:/u01/app/oracle/oradata/prod/sysaux01.dbfdestinationforrestoreofdatafile00005:/u01/app/oracle/oradata/prod/example01.dbfchannelORA_DISK_2:readingfrombackuppiece/backup/rman_bak/lvl1_PROD_154_859051804.bakchannelORA_DISK_1:restoredbackuppiece1piecehandle=/backup/rman_bak/lvl1_PROD_153_859051804.baktag=TAG20140923T173003channelORA_DISK_1:restorecomplete,elapsedtime:00:00:02channelORA_DISK_2:restoredbackuppiece1piecehandle=/backup/rman_bak/lvl1_PROD_154_859051804.baktag=TAG20140923T173003channelORA_DISK_2:restorecomplete,elapsedtime:00:00:02channelORA_DISK_1:startingincrementaldatafilebackupsetrestorechannelORA_DISK_1:specifyingdatafile(s)torestorefrombackupsetdestinationforrestoreofdatafile00001:/u01/app/oracle/oradata/prod/system01.dbfdestinationforrestoreofdatafile00004:/u01/app/oracle/oradata/prod/users01.dbfchannelORA_DISK_1:readingfrombackuppiece/backup/rman_bak/lvl1_PROD_160_859052703.bakchannelORA_DISK_2:startingincrementaldatafilebackupsetrestorechannelORA_DISK_2:specifyingdatafile(s)torestorefrombackupsetdestinationforrestoreofdatafile00002:/u01/app/oracle/oradata/prod/undotbs01.dbfdestinationforrestoreofdatafile00003:/u01/app/oracle/oradata/prod/sysaux01.dbfdestinationforrestoreofdatafile00005:/u01/app/oracle/oradata/prod/example01.dbfchannelORA_DISK_2:readingfrombackuppiece/backup/rman_bak/lvl1_PROD_161_859052703.bakchannelORA_DISK_1:restoredbackuppiece1piecehandle=/backup/rman_bak/lvl1_PROD_160_859052703.baktag=TAG20140923T174503channelORA_DISK_1:restorecomplete,elapsedtime:00:00:01channelORA_DISK_2:restoredbackuppiece1piecehandle=/backup/rman_bak/lvl1_PROD_161_859052703.baktag=TAG20140923T174503channelORA_DISK_2:restorecomplete,elapsedtime:00:00:01startingmediarecoveryarchivelogthread1sequence92isalreadyondiskasfile/disk1/prod/redo01.logarchivelogthread1sequence93isalreadyondiskasfile/disk1/prod/redo02.logchannelORA_DISK_1:startingarchivelogrestoretodefaultdestinationchannelORA_DISK_1:restoringarchivelogarchivelogthread=1sequence=77channelORA_DISK_1:readingfrombackuppiece/backup/rman_bak/arch2_165.bakchannelORA_DISK_1:restoredbackuppiece1piecehandle=/backup/rman_bak/arch2_165.baktag=TAG20140923T174507channelORA_DISK_1:restorecomplete,elapsedtime:00:00:02archivelogfilename=/arch/1_77_858969934.dbfthread=1sequence=77unabletofindarchivelogarchivelogthread=1sequence=78RMAN-00571:===========================================================RMAN-00569:===============ERRORMESSAGESTACKFOLLOWS===============RMAN-00571:===========================================================RMAN-03002:failureofrecovercommandat09/24/201417:44:48RMAN-06054:mediarecoveryrequestingunknownlog:thread1seq78lowscn645415
recover failure,提示缺少archivelog ,做不完全恢复!
RMAN>run{2>setuntilsequence78;3>recoverdatabase;4>}executingcommand:SETuntilclauseStartingrecoverat24-SEP-14usingchannelORA_DISK_1usingchannelORA_DISK_2startingmediarecoverymediarecoverycomplete,elapsedtime:00:00:01Finishedrecoverat24-SEP-14
recover完成!
查看恢复后的database checkpoint:
SQL>selectname,checkpoint_change#fromv$datafile;NAMECHECKPOINT_CHANGE#--------------------------------------------------------------------/u01/app/oracle/oradata/prod/system01.dbf645415/u01/app/oracle/oradata/prod/undotbs01.dbf645415/u01/app/oracle/oradata/prod/sysaux01.dbf645415/u01/app/oracle/oradata/prod/users01.dbf645415/u01/app/oracle/oradata/prod/example01.dbf645415SQL>selectname,checkpoint_change#fromv$datafile_header;NAMECHECKPOINT_CHANGE#--------------------------------------------------------------------/u01/app/oracle/oradata/prod/system01.dbf645415/u01/app/oracle/oradata/prod/undotbs01.dbf645415/u01/app/oracle/oradata/prod/sysaux01.dbf645415/u01/app/oracle/oradata/prod/users01.dbf645415/u01/app/oracle/oradata/prod/example01.dbf645415
打开数据库:
RMAN> alter database open resetlogs;
database opened
@数据库open成功,至此,数据库恢复完成!
以上是“RMAN如何实现完全恢复错误”这篇文章的所有内容,感谢各位的阅读!相信大家都有了一定的了解,希望分享的内容对大家有所帮助,如果还想学习更多知识,欢迎关注亿速云行业资讯频道!
声明:本站所有文章资源内容,如无特殊说明或标注,均为采集网络资源。如若本站内容侵犯了原著者的合法权益,可联系本站删除。