OracleDatabase12c最大化应用程序的可用性课件

OracleDatabase12c最大化应用程序的可用性课件MaximumApplicationAvailabilitywithOracleDatabase12cKuassiMensah

DirectorProductManagementMaximumApplicationAvailabiliThefollowingisintendedtooutlineourgeneralproductdirection.Itisintendedforinformationpurposesonly,andmaynotbeincorporatedintoanycontract.Itisnotacommitmenttodeliveranymaterial,code,orfunctionality,andshouldnotberelieduponinmakingpurchasingdecisions.Thedevelopment,release,andtimingofanyfeaturesorfunctionalitydescribedforOracle’sproductsremainsatthesolediscretionofOracle.ThefollowingisintendedtooMyNextSessionOracleIn-DatabaseMapReduce:WhenHadoopMeetsExadata7/25/13,12:00–13:00,Room431MyNextSessionOracleIn-DatabProgramAgendaProblemstoSolveNewConceptsTransactionGuardApplicationContinuityApplicationDesignConsiderationsProgramAgendaProblemstoSolvProblemstoSolveUponDatabaseOutageFourProblemsConfrontApplicationsHangErrorsOutcomeofIn-FlightWorkResubmissionofIn-FlightWorkProblemstoSolveUponDatabaseHang->FastApplicationNotification(FAN)

ErrorsHandling?Notformalized

In-FlightWork?Lost!ResubmissionofIn-FlightWork?N/A!CurrentSituationHangCurrentSituationProgramAgendaProblemstoSolveNewConceptsTransactionGuardApplicationContinuityApplicationDesignConsiderationsProgramAgendaProblemstoSolvRecoverableErrorFormalizedOracleException.IsRecoverablepropertyApplicationsNolongerneedtomaintainownlistoferrorcodes

(e.g.,ora-1033,ora-1034,ora-xxx)

JDBCthrows

SQLRecoverableException

RecoverableErrorFormalizedDatabaseRequest

UnitofWorkPoolDataSourcepds=GetPoolDataSource();Connectionconn=getConnection(pds);PreparedStatementpstmt=……SQL,PL/SQL,localcalls,RPC …mit();conn.close();RequestBeginsRequestBody

UsuallyendswithCOMMITRequestEndsDatabaseRequest

UnitofWorkProgramAgendaProblemstoSolveNewConceptsTransactionGuardApplicationContinuityApplicationDesignConsiderationsProgramAgendaProblemstoSolvTransactionGuardToolthatsupportsknownoutcomeforeverytransactionWithoutTransactionGuard,retrycancauselogicalcorruptionUsedbyApplicationContinuityCanbeusedindependentlyofApplicationContinuity4.EnforceOutcomeWorkRequest2.DBCalls12cORACLEDatabase3.Errors4.ReliableCommitOutcomeTransactionGuardToolthatsupTransactionGuard–TypicalUsageUpondatabaseinstancecrashFANabortsdeadsessionApplicationgetsanerrorPoolremovesorphanconnectionfrompoolIf“recoverableerror”thenGetlastLTXIDfromdeadsessionObtainnewdatabasesessionGettransactionstatusTransactionGuard–TypicalUsTransactionGuardInActiongetConnection()Txn.Commit();getLastLTXID<newsession>Commitoutcome?COMMIT/ROLLBACKstarttransactionassignLTXIDCOMMIT?Return&PreserveCOMMITOUTCOMEClient/Mid-tierDatabaseTimeRecoverableErrorCOMMITGetLogicalTXIDSQL,PL/SQL,RPCResultsTGinActionTransactionGuardInActiongetOnServiceCOMMIT_OUTCOMEValues–TRUEandFALSEDefault–FALSEAppliestonewsessionsRETENTION_TIMEOUTUnits–secondsDefault–24hours(86400)Maximumvalue–30days(2592000)TransactionGuard

ConfigurationOnServiceTransactionGuard

TransactionGuardinOracledatabase12cJDBC-thin,ODP.NET,OCI,OCCICommitModels

LocalTXNAuto-commit,CommitonSuccessCommitembeddedinPL/SQLDDL,DCL,ParallelDDLRemote,DistributedExclusionsXAR/WDBLinksfromActiveDataGuardorReadOnlyTransactionGuardinOracledaProgramAgendaProblemstoSolveNewConceptsTransactionGuardApplicationContinuityDesignConsiderationsProgramAgendaProblemstoSolvApplicationContinuityMaskDatabaseOutageWhenSuccessfulReplaysin-flightworkonrecoverableerrorsMasksmanyhardware,software,network,storageerrorsandoutageswhensuccessfulImprovesenduserexperience5.ResponseWorkRequest2.DBCalls12cORACLEDatabase4.Replay3.ErrorsApplicationContinuityMaskDatPhasesinApplicationContinuity1-Capture2-Reconnect3-ReplayDemarcatesdatabaserequestHoldsoriginalcallswithbinds&validationManagesqueuesChecksrequesthasreplayenabledHandlestimeoutsCreatesanewconnectionValidatestargetdatabaseUsesTransactionGuardtoenforcelastcommitReplaysheldcallsContinuesreplay,ifuservisibleresultsmatch,basedonvalidationsContinuesrequestPhasesinApplicationContinuiApplicationContinuityInAction

Call1

Application

Proxy1

Proxy2RACDatabaseInstance1Instance2Instance3

Call2

Connection

ReplayContextOracleJDBCDriverApplicationContinuityInActiDEMODEMOSolutionCoverage

ApplicationContinuityforJavaClient

JDBC-ThindriverUCP,WebLogicServerDatabaseSQL,PL/SQL,RPCSelect,ALTERSESSION,DML,DDL,COMMIT/ROLLBACK/SAVEPOINTTransactionmodels:Local,Parallel,Remote,DistributedMutablefunctionsupportHardwareaccelerationoncurrentIntel&SPARCchipsSolutionCoverage

ApplicationExclusions

GlobalRequestTargetDatabaseDonotusedefaultdatabaseserviceExcludesXAForJava,deprecatedconcreteclassesRestrictedcallsAlterSystemAlterDatabaseNotsupportedforActiveDataGuardwithread/writedatabaselinksDoesnotsupport:LogicalStandbyGoldenGateExclusions

GlobalRequestTargRestrictions

WhenDoesReplayNotOccur?

NormalRuntimeReconnectReplayAnycallinsamerequestaftersuccessfulcommitindynamicmode

(default)arestrictedcalldisableReplayAPIErrorisnotrecoverableReconnectionfailureReplayinitiationtimeoutMaxconnectionretriesMaxretriesperincidentTargetdatabasenotvalidforreplayLastcallcommitted

indynamicmodeValidationdetectsdifferentresultsRestrictions

WhenDoesReplayProgramAgendaProblemstoSolveNewConceptsTransactionGuardApplicationContinuityApplicationDesignConsiderationsProgramAgendaProblemstoSolvApplicationAssessment

DecideWhattodoRequestBoundariesMarkRequestBoundaries,ifyouarenotusingOraclePoolsJDBCConcreteClassesReplacedeprecatedconcreteclasseswithJavainterfacesSideEffectsUsedisableAPIifadatabaserequesthasanexternalcallthatshouldnotbereplayedCallbacksEnsureacallbackisregisteredifstatechangesoutsideanyrequest(WLS/UCPlabelingincludedbydefault)MutableFunctionsGrantkeepingmutablevaluesifthesearecompatiblewithyourapplicationApplicationAssessment

DecideWSideEffectsWhenReplayisenabled,somecallsmayberepeated.

AppsmayneedtousedisableReplay()APItopreventthis:AutonomoustransactionsUTL_HTTP,

UTL_URLUTL_FILE,UTL_FILE_TRANSFER-filesoperationsUTL_SMPT,UTL_TCP,UTL_MAIL-sendingmessagesDBMS_PIPE,RPCs-toexternalsourcesDBMS_ALERT-emailorothernotificationsSideEffectsWhenReplayisenaConfigureJDBCReplayDriver

Setreplaydatasourceinpropertyfile

datasource=oracle.jdbc.replay.OracleDataSourceImplEnableApplicationContinuityonService

SetFAILOVER_TYPE=TRANSACTIONReviewsettingsfor:

REPLAY_INITIATION_TIMEOUT=1800FAILOVER_DELAY=3secondsFAILOVER_RETRIES=60retriesSESSION_STATE_CONSISTENCY=DYNAMICCOMMIT_OUTCOME=TRUEConfiguration

ConfigureJDBCReplayDriverCoGRANT[KEEPDATETIME|KEEPSYSGUID]..[to

USER]REVOKE[KEEPDATETIME|KEEPSYSGUID][from

USER]GRANTKEEPSEQUENCE..[to

USER]on[sequenceobject];REVOKEKEEPSEQUENCE[from

USER]on[sequenceobject];Ifowned,ALTERSEQUENCE..[sequenceobject][KEEP|NOKEEP];CREATESEQUENCE..[sequenceobject][KEEP|NOKEEP];MutablesandGrantPrivileges

GRANT[KEEPDATETIME|KEEPSMaximumApplicationAvailabilitywithOracledatabase12c

HangErrors&ConnectionHandlingOutcomeofIn-FlightWorkResubmissionofIn-FlightWorkMaximumApplicationAvailabiliOracleDatabase12c最大化应用程序的可用性课件OracleDatabase12c最大化应用程序的可用性课件OracleDatabase12c最大化应用程序的可用性课件MaximumApplicationAvailabilitywithOracleDatabase12cKuassiMensah

DirectorProductManagementMaximumApplicationAvailabiliThefollowingisintendedtooutlineourgeneralproductdirection.Itisintendedforinformationpurposesonly,andmaynotbeincorporatedintoanycontract.Itisnotacommitmenttodeliveranymaterial,code,orfunctionality,andshouldnotberelieduponinmakingpurchasingdecisions.Thedevelopment,release,andtimingofanyfeaturesorfunctionalitydescribedforOracle’sproductsremainsatthesolediscretionofOracle.ThefollowingisintendedtooMyNextSessionOracleIn-DatabaseMapReduce:WhenHadoopMeetsExadata7/25/13,12:00–13:00,Room431MyNextSessionOracleIn-DatabProgramAgendaProblemstoSolveNewConceptsTransactionGuardApplicationContinuityApplicationDesignConsiderationsProgramAgendaProblemstoSolvProblemstoSolveUponDatabaseOutageFourProblemsConfrontApplicationsHangErrorsOutcomeofIn-FlightWorkResubmissionofIn-FlightWorkProblemstoSolveUponDatabaseHang->FastApplicationNotification(FAN)

ErrorsHandling?Notformalized

In-FlightWork?Lost!ResubmissionofIn-FlightWork?N/A!CurrentSituationHangCurrentSituationProgramAgendaProblemstoSolveNewConceptsTransactionGuardApplicationContinuityApplicationDesignConsiderationsProgramAgendaProblemstoSolvRecoverableErrorFormalizedOracleException.IsRecoverablepropertyApplicationsNolongerneedtomaintainownlistoferrorcodes

(e.g.,ora-1033,ora-1034,ora-xxx)

JDBCthrows

SQLRecoverableException

RecoverableErrorFormalizedDatabaseRequest

UnitofWorkPoolDataSourcepds=GetPoolDataSource();Connectionconn=getConnection(pds);PreparedStatementpstmt=……SQL,PL/SQL,localcalls,RPC …mit();conn.close();RequestBeginsRequestBody

UsuallyendswithCOMMITRequestEndsDatabaseRequest

UnitofWorkProgramAgendaProblemstoSolveNewConceptsTransactionGuardApplicationContinuityApplicationDesignConsiderationsProgramAgendaProblemstoSolvTransactionGuardToolthatsupportsknownoutcomeforeverytransactionWithoutTransactionGuard,retrycancauselogicalcorruptionUsedbyApplicationContinuityCanbeusedindependentlyofApplicationContinuity4.EnforceOutcomeWorkRequest2.DBCalls12cORACLEDatabase3.Errors4.ReliableCommitOutcomeTransactionGuardToolthatsupTransactionGuard–TypicalUsageUpondatabaseinstancecrashFANabortsdeadsessionApplicationgetsanerrorPoolremovesorphanconnectionfrompoolIf“recoverableerror”thenGetlastLTXIDfromdeadsessionObtainnewdatabasesessionGettransactionstatusTransactionGuard–TypicalUsTransactionGuardInActiongetConnection()Txn.Commit();getLastLTXID<newsession>Commitoutcome?COMMIT/ROLLBACKstarttransactionassignLTXIDCOMMIT?Return&PreserveCOMMITOUTCOMEClient/Mid-tierDatabaseTimeRecoverableErrorCOMMITGetLogicalTXIDSQL,PL/SQL,RPCResultsTGinActionTransactionGuardInActiongetOnServiceCOMMIT_OUTCOMEValues–TRUEandFALSEDefault–FALSEAppliestonewsessionsRETENTION_TIMEOUTUnits–secondsDefault–24hours(86400)Maximumvalue–30days(2592000)TransactionGuard

ConfigurationOnServiceTransactionGuard

TransactionGuardinOracledatabase12cJDBC-thin,ODP.NET,OCI,OCCICommitModels

LocalTXNAuto-commit,CommitonSuccessCommitembeddedinPL/SQLDDL,DCL,ParallelDDLRemote,DistributedExclusionsXAR/WDBLinksfromActiveDataGuardorReadOnlyTransactionGuardinOracledaProgramAgendaProblemstoSolveNewConceptsTransactionGuardApplicationContinuityDesignConsiderationsProgramAgendaProblemstoSolvApplicationContinuityMaskDatabaseOutageWhenSuccessfulReplaysin-flightworkonrecoverableerrorsMasksmanyhardware,software,network,storageerrorsandoutageswhensuccessfulImprovesenduserexperience5.ResponseWorkRequest2.DBCalls12cORACLEDatabase4.Replay3.ErrorsApplicationContinuityMaskDatPhasesinApplicationContinuity1-Capture2-Reconnect3-ReplayDemarcatesdatabaserequestHoldsoriginalcallswithbinds&validationManagesqueuesChecksrequesthasreplayenabledHandlestimeoutsCreatesanewconnectionValidatestargetdatabaseUsesTransactionGuardtoenforcelastcommitReplaysheldcallsContinuesreplay,ifuservisibleresultsmatch,basedonvalidationsContinuesrequestPhasesinApplicationContinuiApplicationContinuityInAction

Call1

Application

Proxy1

Proxy2RACDatabaseInstance1Instance2Instance3

Call2

Connection

ReplayContextOracleJDBCDriverApplicationContinuityInActiDEMODEMOSolutionCoverage

ApplicationContinuityforJavaClient

JDBC-ThindriverUCP,WebLogicServerDatabaseSQL,PL/SQL,RPCSelect,ALTERSESSION,DML,DDL,COMMIT/ROLLBACK/SAVEPOINTTransactionmodels:Local,Parallel,Remote,DistributedMutablefunctionsupportHardwareaccelerationoncurrentIntel&SPARCchipsSolutionCoverage

ApplicationExclusions

GlobalRequestTargetDatabaseDonotusedefaultdatabaseserviceExcludesXAForJava,deprecatedconcreteclassesRestrictedcallsAlterSystemAlterDatabaseNotsupportedforActiveDataGuardwithread/writedatabaselinksDoesnotsupport:LogicalStandbyGoldenGateExclusions

GlobalRequestTargRestrictions

WhenDoesReplayNotOccur?

NormalRuntimeReconnectReplayAnycallinsamerequestaftersuccessfulcommitindynamicmode

(default)arestrictedcalldisableReplayAPIErrorisnotrecoverableReconnectionfailureReplayinitiationtimeoutMaxconnectionretriesMaxretriesperincidentTargetdatabasenotvalidforreplayLastcallcommitted

indynamicmodeValidationdetectsdifferentresultsRestrictions

WhenDoesReplayProgramAgendaProblemstoSolveNewConceptsTransactionGuardApplicationContinuityApplicationDesignConsiderationsProgramAgendaProblemstoSolvApplicationAssessment

DecideWhattodoRequestBoundariesMarkRequestBoundaries,ifyouarenotusingOraclePoolsJDBCConcreteClassesReplacedeprecatedconcreteclasseswithJavainterfacesSideEffectsUsedisableAPIifadatabaserequesthasanexternalcallthatshouldnotbereplayedCallbacksEnsureacallbackisregisteredifstatechange