版权说明:本文档由用户提供并上传,收益归属内容提供方,若内容存在侵权,请进行举报或认领
文档简介
MaximumApplicationAvailabilitywithOracleDatabase12cKuassiMensah
DirectorProductManagementThefollowingisintendedtooutlineourgeneralproductdirection.Itisintendedforinformationpurposesonly,andmaynotbeincorporatedintoanycontract.Itisnotacommitmenttodeliveranymaterial,code,orfunctionality,andshouldnotberelieduponinmakingpurchasingdecisions.Thedevelopment,release,andtimingofanyfeaturesorfunctionalitydescribedforOracle’sproductsremainsatthesolediscretionofOracle.MyNextSessionOracleIn-DatabaseMapReduce:WhenHadoopMeetsExadata7/25/13,12:00–13:00,Room431ProgramAgendaProblemstoSolveNewConceptsTransactionGuardApplicationContinuityApplicationDesignConsiderationsProblemstoSolveUponDatabaseOutageFourProblemsConfrontApplicationsHangErrorsOutcomeofIn-FlightWorkResubmissionofIn-FlightWorkHang->FastApplicationNotification(FAN)
ErrorsHandling?Notformalized
In-FlightWork?Lost!ResubmissionofIn-FlightWork?N/A!CurrentSituationProgramAgendaProblemstoSolveNewConceptsTransactionGuardApplicationContinuityApplicationDesignConsiderationsRecoverableErrorFormalizedOracleException.IsRecoverablepropertyApplicationsNolongerneedtomaintainownlistoferrorcodes
(e.g.,ora-1033,ora-1034,ora-xxx)
JDBCthrows
SQLRecoverableException
DatabaseRequest
UnitofWorkPoolDataSourcepds=GetPoolDataSource();Connectionconn=getConnection(pds);PreparedStatementpstmt=……SQL,PL/SQL,localcalls,RPC …mit();conn.close();RequestBeginsRequestBody
UsuallyendswithCOMMITRequestEndsProgramAgendaProblemstoSolveNewConceptsTransactionGuardApplicationContinuityApplicationDesignConsiderationsTransactionGuardToolthatsupportsknownoutcomeforeverytransactionWithoutTransactionGuard,retrycancauselogicalcorruptionUsedbyApplicationContinuityCanbeusedindependentlyofApplicationContinuity4.EnforceOutcomeWorkRequest2.DBCalls12cORACLEDatabase3.Errors4.ReliableCommitOutcomeTransactionGuard–TypicalUsageUpondatabaseinstancecrashFANabortsdeadsessionApplicationgetsanerrorPoolremovesorphanconnectionfrompoolIf“recoverableerror”thenGetlastLTXIDfromdeadsessionObtainnewdatabasesessionGettransactionstatusTransactionGuardInActiongetConnection()Txn.Commit();getLastLTXID<newsession>Commitoutcome?COMMIT/ROLLBACKstarttransactionassignLTXIDCOMMIT?Return&PreserveCOMMITOUTCOMEClient/Mid-tierDatabaseTimeRecoverableErrorCOMMITGetLogicalTXIDSQL,PL/SQL,RPCResultsTGinActionOnServiceCOMMIT_OUTCOMEValues–TRUEandFALSEDefault–FALSEAppliestonewsessionsRETENTION_TIMEOUTUnits––secondsDefault–24hours(86400)Maximumvalue–30days(2592000)TransactionGuardConfigurationTransactionGuardinOracledatabase12cJDBC-thin,ODP.NET,OCI,OCCICommitModelsLocalTXNAuto-commit,CommitonSuccessCommitembeddedinPL/SQLDDL,DCL,ParallelDDLRemote,DistributedExclusionsXAR/WDBLinksfromActiveDataGuardorReadOnlyProgramAgendaProblemstoSolveNewConceptsTransactionGuardApplicationContinuityDesignConsiderationsApplicationContinuityMaskDatabaseOutageWhenSuccessfulReplaysin-flightworkonrecoverableerrorsMasksmanyhardware,software,network,storageerrorsandoutageswhensuccessfulImprovesenduserexperience5.ResponseWorkRequest2.DBCalls12cORACLEDatabase4.Replay3.ErrorsPhasesinApplicationContinuity1-Capture2-Reconnect3-ReplayDemarcatesdatabaserequestHoldsoriginalcallswithbinds&validationManagesqueuesChecksrequesthasreplayenabledHandlestimeoutsCreatesanewconnectionValidatestargetdatabaseUsesTransactionGuardtoenforcelastcommitReplaysheldcallsContinuesreplay,ifuservisibleresultsmatch,basedonvalidationsContinuesrequestApplicationContinuityInActionCall1Application
Proxy1
Proxy2RACDatabaseInstance1Instance2Instance3Call2
Connection
ReplayContextOracleJDBCDriverDEMOSolutionCoverageApplicationContinuityforJavaClientJDBC-ThindriverUCP,WebLogicServerDatabaseSQL,PL/SQL,RPCSelect,ALTERSESSION,DML,DDL,COMMIT/ROLLBACK/SAVEPOINTTransactionmodels:Local,Parallel,Remote,DistributedMutablefunctionsupportHardwareaccelerationoncurrentIntel&SPARCchipsExclusionsGlobalRequestTargetDatabaseDonotusedefaultdatabaseserviceExcludesXAForJava,deprecatedconcreteclassesRestrictedcallsAlterSystemAlterDatabaseNotsupportedforActiveDataGuardwithread/writedatabaselinksDoesnotsupport:LogicalStandbyGoldenGateRestrictionsWhenDoesReplayNotOccur?NormalRuntimeReconnectReplayAnycallinsamerequestaftersuccessfulcommitindynamicmode
(default)arestrictedcalldisableReplayAPIErrorisnotrecoverableReconnectionfailureReplayinitiationtimeoutMaxconnectionretriesMaxretriesperincidentTargetdatabasenotvalidforreplayLastcallcommitted
indynamicmodeValidationdetectsdifferentresultsProgramAgendaProblemstoSolveNewConceptsTransactionGuardApplicationContinuityApplicationDesignConsiderationsApplicationAssessmentDecideWhattodoRequestBoundariesMarkRequestBoundaries,ifyouarenotusingOraclePoolsJDBCConcreteClassesReplacedeprecatedconcreteclasseswithJavainterfacesSideEffectsUsedisableAPIifadatabaserequesthasanexternalcallthatshouldnotbereplayedCallbacksEnsureacallbackisregisteredifstatechangesoutsideanyrequest(WLS/UCPlabelingincludedbydefault)MutableFunctionsGrantkeepingmutablevaluesifthesearecompatiblewithyourapplicationSideEffectsWhenReplayisenabled,somecallsmayberepeated.AppsmayneedtousedisableReplay()APItopreventthis:AutonomoustransactionsUTL_HTTP,UTL_URLUTL_FILE,UTL_FILE_TRANSFER-filesoperationsUTL_SMPT,UTL_TCP,UTL_MAIL-sendingmessagesDBMS_PIPE,RPCs-toexternalsourcesDBMS_ALERT-emailorothernotificationsConfigureJDBCReplayDriverSetreplaydatasourceinpropertyfileEnableApplicationContinuityonServiceSetFA
温馨提示
- 1. 本站所有资源如无特殊说明,都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
- 2. 本站的文档不包含任何第三方提供的附件图纸等,如果需要附件,请联系上传者。文件的所有权益归上传用户所有。
- 3. 本站RAR压缩包中若带图纸,网页内容里面会有图纸预览,若没有图纸预览就没有图纸。
- 4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
- 5. 人人文库网仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对用户上传分享的文档内容本身不做任何修改或编辑,并不能对任何下载内容负责。
- 6. 下载文件中如有侵权或不适当内容,请与我们联系,我们立即纠正。
- 7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。
最新文档
- 《人力资源使用》课件
- 养老院老人入住确认制度
- 养老院环境卫生与消毒制度
- 《理想的风筝课堂》课件
- 2024年民政部社会福利中心“养老服务人才培训”拟申报课件信息反馈表
- 2024年新型环保材料研发项目投标邀请函模板3篇
- 敬老院老人不愿入住协议书(2篇)
- 《青蒿素类抗疟药》课件
- 《丰子恺白鹅》课件
- 2025年遵义c1货运上岗证模拟考试
- 三体读书分享
- 《肾内科品管圈》
- 空气预热器市场前景调研数据分析报告
- 2024年南平实业集团有限公司招聘笔试参考题库附带答案详解
- 深圳港口介绍
- PLC在变电站自动化控制中的应用案例
- 2024版国开电大法学本科《合同法》历年期末考试案例分析题题库
- 产妇产后心理障碍的原因分析及心理护理措施
- HG-T 20583-2020 钢制化工容器结构设计规范
- T-SHNA 0004-2023 有创动脉血压监测方法
- 新版资质认定评审准则详细解读课件
评论
0/150
提交评论