PolarDB-O的Oracle平滑遷移方案

1、技術(shù)創(chuàng)新，變革未來(lái)PolarDB-O的Oracle平滑遷移方案PolarDB架構(gòu)PolarDB兼容性PolarDB增強(qiáng)PolarDB遷移目錄PolarDB架構(gòu)公有云/線下統(tǒng)一化方案設(shè)計(jì)SAN、Polarstore共享存儲(chǔ)RO擴(kuò)展讀寫(xiě)負(fù)載自動(dòng)化路由分離自動(dòng)化、透明FailoverPaas平臺(tái)被集成統(tǒng)一API接口PolarDB架構(gòu)PolarDB兼容性PolarDB增強(qiáng)PolarDB遷移目錄PolarDB兼容性01接口兼容OCI JDBCPro* CXA 02 語(yǔ)法兼容數(shù)據(jù)類型 系統(tǒng)函數(shù) 偽列03 功能兼容分區(qū)層次查詢Pipelined Ta ble FunctionsPL/ SQL、Package

2、VPD 系統(tǒng)視圖和系統(tǒng)包DBLINKNULL和空串兼容PROFILE生態(tài)兼容AWRRMANData GuardGolden GateSQLPlusGUI04 接口兼容文字內(nèi)容OCIEnv* OCIServer* OCISession* tnsnames.ora文件 OCIBind* OCIDefine* OCIStmt* OCITrans* OCIFile* OCILob* SQLT_* 數(shù)據(jù)類型 Error Code兼容 xaoEnv xaoSvcCtxOCIECPGPro*C代碼文字內(nèi)容xa_openxa_closexa_startxa_endxa_preparexa_rollbackxa

3、_forgetxa_recoverTuxedo中間件ATMI 事務(wù)支持，tpbegin、 tpcommit、tpabort、 tpsuspend、 tpresume等XA C接口EXEC SQL INCLUDEEXEC CONNECT service EXEC SQL BEGIN/END DECLARE SECTION EXEC SQL EXECUTE EXEC SQL PREPARE/EXECUTE EXEC SQL ALLOCATE EXEC SQL OPEN|FETCH EXEC SQL WHENEVER EXEC SQL DESCRIBEsqlglm sqlda sqlcaC代碼#in

4、clude #include ” #define#ifdef #if #else #endif unsigned int, short, long long, charn, float, bool, varcharntypedef, struct, enum, extern const charn fordowhile語(yǔ)法兼容文字內(nèi)容NUMBER NCHAR、 NVARCHAR RAW、LONGCLOB、BLOB、BFILE DATE、TIMESTAMP、 INTERVALXMLTYPE ANYDATA JSON數(shù)據(jù)類型文字內(nèi)容PIPELINEDAnonymous BlocksAUTONOMO

5、US_T RANSACTION;SUBTYPETYPE IS RECORDTYPE IS VARRAY OFBULK COLLECT%ROWTYPEGOTOSAVEPOINTROLLBACK TOPL/SQL文字內(nèi)容DUMP VSIZE NLSSORTREGEXP_LIKE TZ_OFFSET ROUND SYS_GUID SYS_CONTEXTALL/USER/DBA_* DBMS_SQL DBMS_DEBUG DBMS_STATS DBMS_APPLICATION_I NFO系統(tǒng)函數(shù)/視圖/包文字內(nèi)容ROWNUM ROWID NEXTVAL CURVAL LEVELCONNECT_BY_R

6、OOT CONNECT_BY_ISLEAF偽列功能兼容文字內(nèi)容PartitionSubpartitionInterval PartitionPartition TemplateSplit PartitionMerge PartitionExchange PartitionMove PartitionDrop Partition分區(qū)文字內(nèi)容CREATE PUBLIC DATABASE LINKCONNECT TOCURRENT_USER | IDENTIFIED BY USING FDW|OCIALL_DB_LINKSUSER_DB_LINKSDBINK文字內(nèi)容Connect By PriorC

7、onnect By NocycleConnect By Start With Order SiblingsLEVELCONNECT_BY_ROOTCONNECT_BY_ISLEA F層次查詢文字內(nèi)容資源：CPU、Memory策略：Request、Limit粒度：Session（SQL)、 User、Database、 Process、Instance總 量資源管理生態(tài)兼容-AWR生態(tài)兼容-DataMax(ADG)異地異步復(fù)制同構(gòu)物理復(fù)制人工切換支持所有產(chǎn)品形態(tài)（主備+三節(jié) 點(diǎn)+一寫(xiě)多讀）生態(tài)兼容-DTS(OGG)數(shù)據(jù)全量遷移數(shù)據(jù)增量同步數(shù)據(jù)訂閱SDK多種主流異構(gòu)數(shù)據(jù)庫(kù)云上、云下、自建數(shù) 據(jù)庫(kù)生

8、態(tài)兼容-DBS(RMAN)生態(tài)兼容-PolarPlus（SQLPlus）ACCEPTDEFINECHANGECLEARCOLUMN FORMAT|HEADINGCONNECTDESCRIBEEXECUTEHOSTPROMPTSET AUTOCOMMIT|NULL|TIMINGSHOWSPOOLUNDEFINEWHENEVER SQLERROR生態(tài)兼容-開(kāi)發(fā)工具(DBNavigator)腳本編輯數(shù)據(jù)庫(kù)連接管理對(duì)象瀏覽代碼編輯數(shù)據(jù)編輯執(zhí)行引擎存儲(chǔ)過(guò)程調(diào)試（DBMS_DEBUGGER）PolarDB架構(gòu)PolarDB的Oracle兼容PolarDB增強(qiáng)PolarDB遷移目錄PolarDB增強(qiáng)-性能優(yōu)

9、化CSNCSN快照 XMIN：當(dāng)前活躍事務(wù)中最小的事務(wù)號(hào) CSN：Commit Sequence Number，全局單調(diào)遞增整數(shù)XMAX：當(dāng)前已結(jié)束（提交或回滾） 的所有事務(wù)中最大的事務(wù)號(hào)PolarDB增強(qiáng)-DMA高可用基于Raft三節(jié)點(diǎn)高可用RPO=0，RTO 60sFollower副本只讀支持容器化部署兼容主備高可用CM一體化架構(gòu)。PolarDB增強(qiáng)-GanosPolarDB增強(qiáng)-Performance InsightPolarDB架構(gòu)PolarDB的Oracle兼容性PolarDB功能增強(qiáng)PolarDB遷移目錄PolarDB遷移-ADAM數(shù)據(jù)庫(kù)和應(yīng)用遷移（Advanced Database & Application M