讲义Oracle.ppt

《讲义Oracle.ppt》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、BackupandRecoveryObjectivesAftercompletingthislesson,youshouldbeabletodothefollowing:Describethebasicsofdatabasebackup,restore,andrecoveryListthetypesoffailurethatmayoccurinanOracleenvironmentDefineabackupandrecoverystrategyBackupandRecoveryIssuesProtectthedatabasefromnumeroustypesoffai

2、luresIncreaseMean-Time-Between-Failures(MTBF)DecreaseMean-Time-To-Recover(MTTR)MinimizedatalossCategoriesofFailuresStatementfailureUserprocessfailureUsererrorInstancefailureMediafailureNetworkfailureCausesofStatementFailuresLogicerrorinanapplicationAttempttoenterinvaliddataintothetableA

3、ttemptanoperationwithinsufficientprivilegesAttempttocreateatablebutexceedallottedquotalimitsAttemptanINSERTorUPDATEtoatable,causinganextenttobeallocated,butwithinsufficientfreespaceavailableinthetablespaceResolutionsforStatementFailuresCorrectthelogicalflowoftheprogram.Modifyandreissuet

4、heSQLstatement.Providethenecessarydatabaseprivileges.Changetheuser’squotalimitbyusingtheALTERUSERcommand.Addfilespacetothetablespace.Enableresumablespaceallocation.CausesofUserProcessFailuresTheuserperformedanabnormaldisconnectinthesession.Theuser’ssessionwasabnormallyterminated.Theuser

5、’sprogramraisedanaddressexception,whichterminatedthesession.ResolutionofUserProcessFailuresThePMONprocessdetectsanabnormallyterminateduserprocess.PMONrollsbackthetransactionandreleasesanyresourcesandlocksbeingheldbyit.PossibleUserErrorsSQL>DROPTABLEemployees;SQL>TRUNCATETABLEemployees;S

6、QL>UPDATEemployees2SETsalary=salary*1.5;SQL>COMMIT;SQL>DELETEFROMemployees;SQL>COMMIT;ResolutionofUserErrorsTrainthedatabaseusers.Recoverfromavalidbackup.Importthetablefromanexportfile.UseLogMinertodeterminethetimeoferror.Recoverwithapoint-in-timerecovery.UseLogMinertoperformobject-leve

7、lrecovery.UseFlashBacktoviewandrepairhistoricaldata.DatabaseDatafile1Datafile2Datafile3ControlfilesRedologfile1Redologfile2145CausesofInstanceFailureInstanceSGARedologbufferDatabufferLargePoolLocksSharedpoolDatadict.cacheSharedSQLandPL/SQLPMONDBWnSMONLGWRCKPTARCnUserproc