欢迎来到天天文库
浏览记录
ID:49481923
大小:1.02 MB
页数:68页
时间:2020-02-25
《讲义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
此文档下载收益归作者所有