oracle数据库恢复

《oracle数据库恢复》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、User-M1anagedCo2mpleteRecoveryCopyright©OracleCorporation,2001.Allrightsreserved.ObjectivesAftercompletingthislesson,youshouldbeabletodothefollowing:•Describemediarecovery•PerformrecoveryinNoarchivelogmode•PerformcompleterecoveryinArchivelogmode•Restoredatafilestodifferentloca

2、tions•Relocateandrecoveratablespacebyusingarchivedredologfiles•Describeread-onlytablespacerecovery12-2Copyright©OracleCorporation,2001.Allrightsreserved.MediaRecovery•Usedtorecoveralostordamagedcurrentdatafileorcontrolfile•Requiresexplicitinvocation•Operatesasfollows:–Filesare

3、restoredfrombackups–Redodataisappliedtotherestoredfilesfromarchivedredologfilesandonlineredologs12-3Copyright©OracleCorporation,2001.Allrightsreserved.RecoveryStepsArchivedRedologOnlineRedologRedoappliedUndoapplied24Datafile1Datafile1Datafile1Datafile2Datafile2Datafile2Datafil

4、e3Datafile3Datafile3DatabasecontainingRestoreddatafilesRecovereddatabasecommittedanduncommitted1transactions5312-4Copyright©OracleCorporation,2001.Allrightsreserved.RestorationandDatafileMediaRecoverywithUser-ManagedProcedures•Restorefilesusingoperatingsystemcommands•Recoverfi

5、lesusingtheSQL*PlusRECOVERcommand12-5Copyright©OracleCorporation,2001.Allrightsreserved.ArchivelogandNoarchivelogModesInstanceUserServerSGAprocessSharedpoolprocessPGASharedSQLLocksLargepoolandPL/SQLDatabufferRedologDatadict.buffercacheUserServerprocessprocessSMONDBWnPMONCKPTLG

6、WRARCnPGA144144144Datafile1ControlRedologfilesfile1Parameter144145fileDatafile2Redologfile2Password144fileDatafile3Database12-6Copyright©OracleCorporation,2001.Allrightsreserved.RecoveryinNoarchivelogModeInNoarchivelogmode,youmustrestorethefollowingdatabasefiles:•Datafiles•Con

7、trolfilesYoumayalsorestorethefollowingfiles:•Redologfiles•Passwordfile•Parameterfile12-7Copyright©OracleCorporation,2001.Allrightsreserved.RecoveryinNoarchivelogMode•Advantages–Easytoperform,withlowriskoferror–Recoverytimeisthetimeittakestorestoreallfiles.•Disadvantages–Datais

8、lostandmustbereappliedmanually.–Theentiredatabaseisrestoredto