5oracledatabase12c最大化應(yīng)用程序的可用性(存儲(chǔ)版)
【正文】 acceleration on current Intel SPARC chips Copyright 169。 REVOKE KEEP SEQUENCE [from USER] on [sequence object]。 2023, Oracle and/or its affiliates. All rights reserved. 32 Copyright 169。 2023, Oracle and/or its affiliates. All rights reserved. 28 ? Configure JDBC Replay Driver – Set replay data source in property file datasource= ? Enable Application Continuity on Service – Set FAILOVER_TYPE = TRANSACTION – Review settings for: REPLAY_INITIATION_TIMEOUT = 1800 FAILOVER_DELAY = 3 seconds FAILOVER_RETRIES = 60 retries SESSION_STATE_CONSISTENCY = DYNAMIC COMMIT_OUTCOME = TRUE Configuration Copyright 169。 2023, Oracle and/or its affiliates. All rights reserved. 20 Application Continuity In Action Call 1 Application Proxy 1 Proxy 2 RAC Database Instance1 Instance2 Instance3 Call 2 Connection Replay Context Oracle JDBC Driver Copyright 169。 2023, Oracle and/or its affiliates. All rights reserved. 13 Transaction Guard – Typical Usage Upon database instance crash ? FAN aborts dead session ? Application gets an error ? Pool removes orphan connection from pool ? If “recoverable error” then Get last LTXID from dead session Obtain new database session Get transaction status Copyright 169。 2023, Oracle and/or its affiliates. All rights reserved. 9 Recoverable Error ? Formalized property ? Applications No longer need to maintain own list of error codes (., ora1033, ora1034, oraxxx) ? JDBC throws SQLRecoverableException Copyright 169。Copyright 169。 2023, Oracle and/or its affiliates. All rights reserved. 8 Program Agenda ? Problems to Solve ?New Concepts ? Transaction Guard ? Application Continuity ? Application Design Considerations Copyright 169。 2023, Oracle and/or its affiliates. All rights reserved. 12 Transaction Guard ?Tool that supports known oute for every transaction ?Without Transaction Guard, retry can cause logical corruption
環(huán)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1