已阅读5页,还剩41页未读, 继续免费阅读
版权说明:本文档由用户提供并上传,收益归属内容提供方,若内容存在侵权,请进行举报或认领
文档简介
User-ManagedCompleteRecovery,Objectives,Aftercompletingthislesson,youshouldbeabletodothefollowing:DescribemediarecoveryPerformrecoveryinNoarchivelogmodePerformcompleterecoveryinArchivelogmodeRestoredatafilestodifferentlocationsRelocateandrecoveratablespacebyusingarchivedredologfilesDescriberead-onlytablespacerecovery,MediaRecovery,UsedtorecoveralostordamagedcurrentdatafileorcontrolfileRequiresexplicitinvocationOperatesasfollows:FilesarerestoredfrombackupsRedodataisappliedtotherestoredfilesfromarchivedredologfilesandonlineredologs,OnlineRedolog,RecoverySteps,Restoreddatafiles,Databasecontainingcommittedanduncommittedtransactions,Recovereddatabase,Redoapplied,Undoapplied,5,4,3,2,1,ArchivedRedolog,RestorationandDatafileMediaRecoverywithUser-ManagedProcedures,RestorefilesusingoperatingsystemcommandsRecoverfilesusingtheSQL*PlusRECOVERcommand,ArchivelogandNoarchivelogModes,Instance,SGA,Redologbuffer,Databuffer,Largepool,Locks,Sharedpool,Datadict.cache,SharedSQLandPL/SQL,ARCn,Userprocess,Serverprocess,PGA,Userprocess,Serverprocess,PGA,Database,Parameterfile,Passwordfile,RecoveryinNoarchivelogMode,InNoarchivelogmode,youmustrestorethefollowingdatabasefiles:DatafilesControlfilesYoumayalsorestorethefollowingfiles:RedologfilesPasswordfileParameterfile,RecoveryinNoarchivelogMode,AdvantagesEasytoperform,withlowriskoferrorRecoverytimeisthetimeittakestorestoreallfiles.DisadvantagesDataislostandmustbereappliedmanually.Theentiredatabaseisrestoredtothepointofthelastwholeclosedbackup.,PasswordFile,ParameterFile,PasswordFile,ParameterFile,Datafile3,RedologFile2,DataFile2,ControlFiles,RedologFile1,Datafile1,Database,145,146,146,146,146,146,RecoveryinNoarchivelogModeWithRedoLogFileBackups,Backup,Restorefromthemostrecentbackup,Database,PasswordFile,ParameterFile,RecoveryinNoarchivelogModeWithoutRedoLogFileBackups,1.Shutdowntheinstance.2.Restorethedatafilesandthecontrolfilefromthemostrecentwholedatabasebackup.3.Performcancel-basedrecovery.4.OpenthedatabasewiththeRESETLOGSoption.,RecoveryinArchivelogMode,CompleteRecoveryUsesredodataorincrementalbackupsUpdatesthedatabasetothemostcurrentpointintimeAppliesallredochangesIncompleteRecoveryUsesbackupandredologstoproduceanoncurrentversionofthedatabase,CompleteRecovery,Makesurethatdatafilesforrestoreareoffline.Restoreonlylostordamageddatafiles.Donotrestorethecontrolfiles,redologfiles,passwordfiles,orparameterfiles.Recoverthedatafiles.,CompleteRecoveryinArchivelogMode,AdvantagesOnlyneedtorestorelostfilesRecoversalldatatothetimeoffailureRecoverytimeisthetimeittakestorestorelostfilesandapplyallarchivedlogfilesDisadvantagesMusthaveallarchivedlogfilessincethebackupfromwhichyouarerestoring,DeterminingWhichFilesNeedRecovery,ViewV$RECOVER_FILEtodeterminewhichdatafilesneedrecoveryViewV$ARCHIVED_LOGforalistofallarchivedredologfilesforthedatabaseViewV$RECOVERY_LOGforalistofallarchivedredologfilesrequiredforrecovery,User-ManagedRecoveryProcedures:RECOVERCommand,SQLRECOVERDATABASE;ORSQLRECOVERDATAFILE2/ORADATA/u03/users01.dbf;,Recoveramounteddatabase:,SQLRECOVERTABLESPACEusers;ORSQLRECOVERDATAFILE3;,Recoveranopendatabase:,UsingArchivedRedoLogFilesDuringRecovery,Tochangearchivelocation,usetheALTERSYSTEMARCHIVELOGmand.Toapplyredologfilesautomatically:IssuetheSETAUTORECOVERYONcommandbeforestartingmediarecoveryEnterautowhenpromptedforanarchivedlogfileUsetheRECOVERAUTOMATICmand.,RestoringDatafilestoaNewLocationwithUser-ManagedProcedures,Useoperatingsystemcommandstorestorethedatafiletothenewlocation.UsetheALTERDATABASERENAMEFILEcommandtorecordthechangeinthecontrolfile.,CompleteRecoveryMethods,Closeddatabaserecoveryfor:SystemdatafilesUndosegmentdatafilesWholedatabaseOpendatabaserecovery,withdatabaseinitiallyopened(forfileloss)Opendatabaserecoverywithdatabaseinitiallyclosed(forhardwarefailure)Datafilerecoverywithnodatafilebackup,CompleteRecoveryofaClosedDatabase,Closeddatabaserecoveryisusedfor:SystemtablespacedatafilesRollbacksegmentdatafilesWholedatabase,Shutdowntheinstance,1,Datafile3,Redologfile2,Datafile2,Controlfiles,Redologfile1,Datafile1,ClosedDatabase,Archivedlogfile,144,ClosedDatabaseRecoveryExample,Restoredatafile1(LogSequence144),2,Openthedatabase,4,Datafile3,Redologfile2,Datafile2,Controlfiles,Redologfile1,Datafile1,MountedDatabase,3,Datafile3,Redologfile2,Controlfiles,Redologfile1,Datafile1,RecoveredDatabase,146,145,146,146,146,Datafile2,146,3,3,OpenDatabaseRecoveryWhentheDatabaseIsInitiallyOpen,Usethismethodwhen:ThedatabaseiscurrentlyopenThedatabasewillremainopenduringtherecoveryThemediafailuredoesnotaffecttheSYSTEMtablespace,1,Datafile3,Redologfile2,Datafile2,Controlfiles,Redologfile1,Datafile1,OpenDatabaseRecoveryExample,2,4,Datafile3,Redologfile2,Datafile2,Controlfiles,Redologfile1,Datafile1,146,145,146,144,146,146,3,3,3,Datafile3,Redologfile2,Controlfiles,Redologfile1,Datafile1,146,145,146,146,146,Datafile2,146,Takedatafile2offline,Restoredatafile2(LogSequence144),Bringdatafile2online,Archivedlogfile,144,OpenDatabase,OpenDatabase,RecoveredDatabase,OpenDatabaseRecoveryWhentheDatabaseIsInitiallyClosed,Usethismethodwhen:ThedatabaseiscurrentlyclosedThedatabasewillbeopenedduringrecoveryThemediafailuredoesnotaffecttheSYSTEMtablespace,Takedatafile2offline,2,OpenDatabaseRecoveryExample,Restoredatafile2,4,Bringdatafile2online,6,1,Mountthedatabase,3,Openthedatabase,Datafile3,Redologfile2,Datafile2,Controlfiles,Redologfile1,Datafile1,Datafile3,Redologfile2,Controlfiles,Redologfile1,Datafile1,146,145,146,146,146,Datafile2,146,ClosedDatabase,RecoveredDatabase,Datafile3,Redologfile2,Datafile2,Controlfiles,Redologfile1,Datafile1,146,145,146,144,146,146,5,5,5,Archivedlogfile,144,OpenDatabase,RecoveryofaDatafileWithoutaBackup,DatafileislostthatwasneverbackedupCannotbeusedwhenitisafilefromtheSYSTEMtablespace,Datafile3,Redologfile2,Datafile2,Controlfiles,Redologfile1,Datafile1,146,145,146,146,146,146,OpenDatabase,Datafile3,Redologfile2,Datafile2,Controlfiles,Redologfile1,Datafile1,146,145,146,144,146,146,Archivedlogfile,144,OpenDatabase,RecoveryWithoutaBackupExample,Bringthedatafileortablespaceonline,4,1,Takethedatafileortablespaceoffline,2,Re-createthedatafile,Datafile4,3,3,3,Datafile4,146,Datafile3,Redologfile2,Datafile2,Controlfiles,Redologfile1,Datafile1,146,145,146,146,146,146,RecoveredDatabase,Datafile4,146,Read-OnlyTablespaceRecovery,Backup2,Recovery,Case1,Case2,Case3,Backup1,Read-Only,Read-Write,Read-Only,Read-Only,Read-Write,Read-OnlyTablespaceRecoveryIssues,Specialconsiderationsmustbetakenforread-onlytablespaceswhen:Re-creatingacontrolfileRenamingdatafilesUsingabackupcontrolfile,LossofControlFiles,Youmayneedtocreatecontrol
温馨提示
- 1. 本站所有资源如无特殊说明,都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
- 2. 本站的文档不包含任何第三方提供的附件图纸等,如果需要附件,请联系上传者。文件的所有权益归上传用户所有。
- 3. 本站RAR压缩包中若带图纸,网页内容里面会有图纸预览,若没有图纸预览就没有图纸。
- 4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
- 5. 人人文库网仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对用户上传分享的文档内容本身不做任何修改或编辑,并不能对任何下载内容负责。
- 6. 下载文件中如有侵权或不适当内容,请与我们联系,我们立即纠正。
- 7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。
最新文档
- 2026文思海辉的面试题及答案
- 2026西奥电梯招聘面试题及答案
- 2026乡镇省考面试题及答案
- 2026携程人才面试题及答案
- 毛纺织企业隐患排查治理制度
- 2026年人脸识别智能门锁产品认证费用预算
- 2026年仓储信息化建设合同二篇
- 培训课件:储能变流器PCS立项分析报告
- 土木工程认识的实习报告
- 医保相关知识考试试题及答案
- 2026年安康紫阳县直及县城周边学校遴选教师(81人)考试模拟试题及答案详解
- 2025年中国真空阀门设备市场调查研究报告
- 2026有色金属期货价格预测机器学习模型构建分析
- (2025年)正阳县纪委遴选笔试试题及答案
- 卫生院应急演练制度
- 2026贵州能源集团有限公司第一批综合管理岗招聘41人考试历年真题汇编附答案解析
- 考试出题保密协议书
- 神经外科常用英文词汇
- DL∕ T 736-2010 农村电网剩余电流动作保护器安装运行规程
- GB/T 44148.1-2024承压设备用钢锻件、轧制或锻制钢棒第1部分:一般要求
- 全科医学病案分析报告
评论
0/150
提交评论