5OracleDatabase12c最大化应用程序的可用性

Copyright©2013,Oracleand/oritsaffiliates.Allrightsreserved.1MaximumApplicationAvailabilitywithOracleDatabase12cKuassiMensahDirectorProductManagementCopyright©2013,Oracleand/oritsaffiliates.Allrightsreserved.3Thefollowingisintendedtooutlineourgeneralproductdirection.Itisintendedforinformationpurposesonly,andmaynotbeincorporatedintoanycontract.Itisnotacommitmenttodeliveranymaterial,code,orfunctionality,andshouldnotberelieduponinmakingpurchasingdecisions.Thedevelopment,release,andtimingofanyfeaturesorfunctionalitydescribedforOracle’sproductsremainsatthesolediscretionofOracle.Copyright©2013,Oracleand/oritsaffiliates.Allrightsreserved.4MyNextSessionOracleIn-DatabaseMapReduce:WhenHadoopMeetsExadata–7/25/13,12:00–13:00,Room431Copyright©2013,Oracleand/oritsaffiliates.Allrightsreserved.5ProgramAgendaProblemstoSolveNewConceptsTransactionGuardApplicationContinuityApplicationDesignConsiderationsCopyright©2013,Oracleand/oritsaffiliates.Allrightsreserved.6ProblemstoSolveUponDatabaseOutageFourProblemsConfrontApplications1.Hang2.Errors3.OutcomeofIn-FlightWork4.ResubmissionofIn-FlightWorkCopyright©2013,Oracleand/oritsaffiliates.Allrightsreserved.7Hang-FastApplicationNotification(FAN)ErrorsHandling?NotformalizedIn-FlightWork?Lost!ResubmissionofIn-FlightWork?N/A!CurrentSituationCopyright©2013,Oracleand/oritsaffiliates.Allrightsreserved.8ProgramAgendaProblemstoSolveNewConceptsTransactionGuardApplicationContinuityApplicationDesignConsiderationsCopyright©2013,Oracleand/oritsaffiliates.Allrightsreserved.9RecoverableErrorFormalizedOracleException.IsRecoverablepropertyApplicationsNolongerneedtomaintainownlistoferrorcodes(e.g.,ora-1033,ora-1034,ora-xxx)JDBCthrowsSQLRecoverableExceptionCopyright©2013,Oracleand/oritsaffiliates.Allrightsreserved.10DatabaseRequestUnitofWorkPoolDataSourcepds=GetPoolDataSource();Connectionconn=getConnection(pds);PreparedStatementpstmt=…–…–SQL,PL/SQL,localcalls,RPC–…conn.commit();conn.close();RequestBeginsRequestBodyUsuallyendswithCOMMITRequestEndsCopyright©2013,Oracleand/oritsaffiliates.Allrightsreserved.11ProgramAgendaProblemstoSolveNewConceptsTransactionGuardApplicationContinuityApplicationDesignConsiderationsCopyright©2013,Oracleand/oritsaffiliates.Allrightsreserved.12TransactionGuard•Toolthatsupportsknownoutcomeforeverytransaction•WithoutTransactionGuard,retrycancauselogicalcorruption•UsedbyApplicationContinuity•CanbeusedindependentlyofApplicationContinuity4.EnforceOutcome1.WorkRequest2.DBCalls12cORACLEDatabase3.Errors4.ReliableCommitOutcomeCopyright©2013,Oracleand/oritsaffiliates.Allrightsreserved.13TransactionGuard–TypicalUsageUpondatabaseinstancecrashFANabortsdeadsessionApplicationgetsanerrorPoolremovesorphanconnectionfrompoolIf“recoverableerror”thenGetlastLTXIDfromdeadsessionObtainnewdatabasesessionGettransactionstatusCopyright©2013,Oracleand/oritsaffiliates.Allrightsreserved.14TransactionGuardInActiongetConnection()Txn.Commit();getLastLTXIDnewsessionCommitoutcome?COMMIT/ROLLBACKstarttransactionassignLTXIDCOMMIT?Return&PreserveCOMMITOUTCOMEClient/Mid-tierDatabaseTimeRecoverableErrorCOMMITGetLogicalTXIDSQL,PL/SQL,RPCResultsTGinActionCopyright©2013,Oracleand/oritsaffiliates.Allrightsreserved.15OnService‒COMMIT_OUTCOMEValues–TRUEandFALSEDefault–FALSEAppliestonewsessions‒RETENTION_TIMEOUTUnits–secondsDefault–24hours(86400)Maximumvalue–30days(2592000)TransactionGuardConfigurationCopyright©2013,Oracleand/oritsaffiliates.Allrightsreserved.16TransactionGuardinOracledatabase12cJDBC-thin,ODP.NET,OCI,OCCICommitModels‒LocalTXN‒Auto-commit,CommitonSuccess‒CommitembeddedinPL/SQL‒DDL,DCL,ParallelDDL‒Remote,DistributedExclusions‒XA‒R/WDBLinksfromActiveDataGuardorReadOnlyCopyright©2013,Oracleand/oritsaffiliates.Allrightsreserved.17ProgramAgendaProblemstoSolveNewConceptsTransactionGuardApplicationContinuityDesignConsiderationsCopyright©2013,Oracleand/oritsaffiliates.Allrightsreserved.18ApplicationContinuityMaskDatabaseOutageWhenSuccessful•Replaysin-flightworkonrecoverableerrors•Masksmanyhardware,software,network,storageerrorsandoutageswhensuccessful•Improvesenduserexperience5.Response1.WorkRequest2.DBCalls12cORACLEDatabase4.Replay3.ErrorsCopyright©2013,Oracleand/oritsaffiliates.Allrightsreserved.19PhasesinApplicationContinuity1-Capture2-Reconnect3-Replay•Demarcatesdatabaserequest•Holdsoriginalcallswithbinds&validation•Managesqueues•Checksrequesthasreplayenabled•Handlestimeouts•Createsanewconnection•Validatestargetdatabase•UsesTransactionGuardtoenforcelastcommit•Replaysheldcalls•Continuesreplay,ifuservisibleresultsmatch,basedonvalidations•ContinuesrequestCopyright©2013,Oracleand/oritsaffiliates.Allrightsreserved.20ApplicationContinuityInActionCall1ApplicationProxy1Proxy2RACDatabaseInstance1Instance2Instance3Call2ConnectionReplayContextOracleJDBCDriverCopyright©2013,Oracleand/oritsaffiliates.Allrightsreserved.21DEMOCopyright©2013,Oracleand/oritsaffiliates.Allrightsreserved.22SolutionCoverageApplicationContinuityforJavaClient–JDBC-Thindriver–UCP,WebLogicServerDatabas