Oracle Database Cloud VM/BMへの移行

3115a782126be714b5f94d24073c957d?s=47 oracle4engineer
June 01, 2020
110

Oracle Database Cloud VM/BMへの移行

3115a782126be714b5f94d24073c957d?s=128

oracle4engineer

June 01, 2020
Tweet

Transcript

  1. 2.

    Copyright © 2020 Oracle and/or its affiliates. 2 Oracle Cloud

    Infrastructure https://docs.oracle.com/cd/E97706_01/Content/Database/Tasks/migrating.htm ※最新情報は英語ページをご確認ください。
  2. 4.

    Copyright © 2020 Oracle and/or its affiliates. 4 ( DB

    ) non-CDB CDB Data Pump DB/ / / 11.2.0.4 SE RMAN Backup/Restore DB 11.2.0.4 SE RMAN Duplicate DB 11.2.0.4 SE Transportable Tablespaces 11.2.0.4 EE DB EE Full Transportable export/import DB 11.2.0.4 EE DB EE DB 12.1.0.1 RMAN Transportable Tablespaces DB/ 11.2.0.4 EE DB EE PDB Unplug/Plug PDB 12.1.0.2 SE PDB Clone PDB 12.1.0.2 SE Non-CDB Clone DB 12.1.0.2 SE Data Guard DB 11.2.0.4 EE DB EE GoldenGate DB/ / / 11.2.0.4 SE GoldenGate Cloud Backup Module for OCI DB 11.2.0.4 SE Zero Downtime Migration(ZDM) DB 11.2.0.4 SE
  3. 5.
  4. 7.

    Copyright © 2020 Oracle and/or its affiliates. 7 Zero Downtime

    Migration Cloud Backup Module for OCI Data Pump RMAN Backup/Restore 2019/11 OCI DB 3 Module →RMAN →OCI DB GoldenGate RMAN Transportable Tablespaces
  5. 8.

    Copyright © 2020 Oracle and/or its affiliates. 8 • Zero

    Downtime Migration Service(ZDM) • Cloud Backup Module for OCI NG • Data Pump , Transportable Tablespaces(TTS) • DB (dbcli register-database) - - - PDB
  6. 9.

    9 11.2.0.4 12.1.0.1 - SQL*Loarder / - Data Pump -

    RMAN Backup/Restore - RMAN Duplicate - Cloud Backup Module for OCI* - Data Guard * - Transportable Tablespaces - Full Transportable export/import - Zero Downtime Migration* - GoldenGate Copyright © 2020 Oracle and/or its affiliates. * OCI DBCS DB
  7. 10.

    10 12.1.0.2 - SQL*Loarder / - Data Pump - RMAN

    Backup/Restore - RMAN Duplicate - Cloud Backup Module for OCI* - Data Guard * - PDB Unplug/Plug Clone Non-CDB Clone - Transportable Tablespaces - Full Transportable export/import - Zero Downtime Migration* - GoldenGate Copyright © 2020 Oracle and/or its affiliates. * OCI Database DB
  8. 11.

    11 データベース移行方式の検討例 移行方式の選び方 移行要件と前提条件を考慮して移行方式を検討 移行時のダウンタイム を極力短くしたいか データ転送に時間が 掛かるか 定期的なパッチ適用 運用を行っているか

    Data Guard GoldenGate YES YES YES NO NO NO Backup Service RMAN 移行時にバージョン アップしたいか マルチテナント構成か GoldenGate TTS マルチテナント (Unplug/Plug) YES NO YES RMAN Data Pump NO etc. etc. データ量:多 ネットワーク転送速度:低速 初期移行 移行要件 前提条件 初期移行 Data Guard ( ) ZDM Data Guard Backup Service Data Pump ZDM 切り戻しを見越した差 分同期機能が必要か YES NO
  9. 13.

    Copyright © 2020 Oracle and/or its affiliates. 13 Oracle Zero

    Downtime Migration Service(ZDM) / 1. ZDM 2. ZDM 3. 4. ( ) 5. ZDM 6. 2019/11 2020/01 DB DB , DB ZDM Object Storage Application ZDM SSH SSH SQLnet On-Premise Oracle Cloud
  10. 14.

    Copyright © 2020, Oracle and/or its affiliates 14 • /

    • • 12.2 TDE • Database • ZDM (OCI Compute ) • ZDM SSH • • Object Storage Oracle Zero Downtime Migration Service(ZDM)
  11. 15.

    Copyright © 2020, Oracle and/or its affiliates 15 • Zero

    Downtime Migration https://www.oracle.com/database/technologies/rac/zdm.html • https://docs.oracle.com/en/database/oracle/zero-downtime-migration/19.2/zdmug/index.html • https://www.oracle.com/a/otn/docs/oracle-zdm-wp.pdf • MOS Note Doc ID 2386116.1 Migration to Exadata Cloud using Simple Data Guard Approach with Minimal Downtime which is replaced by Zero Downtime Migration tool Oracle Zero Downtime Migration Service(ZDM)
  12. 16.

    Copyright © 2020 Oracle and/or its affiliates. 16 Cloud Backup

    Module for OCI Object Storage , Backup Cloud Service 1. 2. (GUI) API Object Storage Database DB On-Premise Oracle Cloud DB Oracle Database Cloud Backup Module ODBCM Object Storage / DB 12c CDB
  13. 17.

    Copyright © 2020 Oracle and/or its affiliates. 17 • Database

    • DB 12c CDB • RMAN ( TDE) - DB SE • Database Backup Cloud Service Object Storage Cloud Backup Module for OCI
  14. 18.

    Copyright © 2020 Oracle and/or its affiliates. 18 Oracle GoldenGate

    Oracle GoldenGate DB DB DB object 1. OCI DB 2. GoldenGate 3. DB 4. 5. Database DB On-Premise Oracle Cloud DB Non-Oracle
  15. 19.

    Copyright © 2020 Oracle and/or its affiliates. 19 • VM.Standard2.4

    • GoldenGate 19c (19.1.0.0.4) Oracle Databases(OnP) • Oracle Databases 11.2.0.4+ • DDL Replication Cloud Based Services • Autonomous Resources and DBaaS • Parallel Replicat Delivery • SQL*Net GoldenGate on OCI Marketplace
  16. 20.

    Copyright © 2020 Oracle and/or its affiliates. 20 30 (Term,

    Processor, Named User, etc) 2019 5 UCM/Credit 2020 12 OGG NOW AVAILABLE!(2019 12 ) 2020 12 OCI Cloud Database GoldenGate GoldenGate on OCI Marketplace * IaaS(Compute + Storage) UCM/Credit
  17. 21.

    Copyright © 2020 Oracle and/or its affiliates. 21 GoldenGate on

    OCI Marketplace ※ ※(2019 12 ) (1) You represent that You had an active entitlement for Oracle PaaS and IaaS Universal Credits Cloud Services as of May 31, 2019. Assuming the foregoing, this promotion grants You a limited use term license for this Program and the right to receive technical support services for this Program, both through December 31, 2020. This Program may only be used in conjunction with Your Oracle PaaS and IaaS Universal Credits Cloud Services through December 31, 2020. OR (2) You represent that You are using the Program to replicate data into an Oracle Cloud Service (an “Oracle Cloud Service”), as designated in the Oracle PaaS and IaaS Universal Credits Service Descriptions (which may be viewed at http://www.oracle.com/contracts). Assuming the foregoing, this promotion grants You a limited use term license for this Program and the right to receive technical support services for this Program, both through Dec 31, 2020. This Program may only be used to replicate data into an Oracle Cloud Service through Dec 31, 2020. 1) Promotional Oracle Program Limited Use Promotional Terms. 2) 3) Launch Stack
  18. 23.

    Copyright © 2020 Oracle and/or its affiliates. 23 Data Pump

    1. OCI DB 2. DB dump export 3. dump 4. DB dump import Database DB On-Premise Oracle Cloud DB dump
  19. 24.

    Copyright © 2020 Oracle and/or its affiliates. 24 RMAN Backup/Restore

    1. DB RMAN 2. OCI DB 3. ( ) dbcli 4. DB 5. ( DB ) TDE DB 6. RMAN 7. RMAN 8. dbcli register-database OCI DB ※2-node RAC DB_UNIQUE_NAME DB Database DB On-Premise Oracle Cloud DB RMAN ※ / Object Storage Cloud Backup Module for OCI Cloud Backup Module for OCI
  20. 25.

    Copyright © 2020 Oracle and/or its affiliates. 25 Transportable Tablespaces

    data pump PL/SQL 1. OCI DB 2. DB READ ONLY 3. DB expdp 4. 5. DB impdp Database DB On-Premise Oracle Cloud DB (SYSTEM/SYSAUX/TEMP/UNDO )
  21. 27.

    Copyright © 2020 Oracle and/or its affiliates. 27 PDB Unplug/Plug

    Unplug/Plug Multitenant PDB 12.1.0.2 PDB 1. OCI CDB 2. PDB 3. Unplug XML 4. XML 5. DB XML PDB 12.2 Unplug/Plug (PDB ) PDB 1. OCI CDB 2. CDB CDB 3. CDB PDB SQL 4. PDB OPEN PDB PDB PDB
  22. 28.

    1. OCI CDB 2. CDB CDB 3. CDB PDB SQL

    Copyright © 2020 Oracle and/or its affiliates. 28 PDB Clone PDB 12.1.0.2 PDB PDB CDB UNDO PDB CDB ARCHIVELOG 12.2 ( ) 12.2 PDB PDB ( ) 1. OCI CDB 2. CDB CDB 3. CDB PDB SQL (refresh mode ) 4. or ※ PDB CLOSE
  23. 29.

    Copyright © 2020 Oracle and/or its affiliates. 29 Non-CDB Clone

    12.1.0.2 CDB CDB PDB 1. OCI CDB 2. CDB READ ONLY 3. CDB CDB 4. CDB PDB SQL 5. DB $ORACLE_HOME/rdbms /admin/noncdb_to_pdb.sql DB On-Premise Oracle Cloud 12.1.0.2 CDB PDB
  24. 31.

    Copyright © 2020 Oracle and/or its affiliates. 31 RMAN Duplicate

    DB DB SSH DB DB 1. OCI DB 2. ( ) dbcli 3. dbcli create-dbstorage DATA,RECO,REDO 4. ( DB TDE ) DB 5. 6. RMAN Duplicate 7. dbcli register-database OCI DB ※2-node RAC DB_UNIQUE_NAME DB DB
  25. 32.

    Copyright © 2020 Oracle and/or its affiliates. 32 RMAN Transportable

    Tablespaces RMAN READ ONLY 1. OCI DB 2. DB RMAN> TRANSPORT TABLESPACE ( dmp, ,impdp ) 3. 4. DB impdp Database DB On-Premise Oracle Cloud DB impdp DB
  26. 33.

    Copyright © 2020 Oracle and/or its affiliates. 33 Full Transportable

    export/import Transportable Tablespaces DB 1. OCI DB 2. DB READ ONLY 3. DB expdp (FULL=Y, TRANSPORTABLE=ALWAYS ) 4. 5. DB impdp (FULL=Y, TRANSPORTABLE=ALWAYS ) Database DB On-Premise Oracle Cloud DB DB 11.2.0.3 DB 12.1.0.1 RMAN PL/SQL
  27. 34.

    Copyright © 2020 Oracle and/or its affiliates. 34 Oracle Data

    Guard EE EE 1. DB 2. DB DB 3. REDO 4. DB DB 5. DB / DB Database DB On-Premise Oracle Cloud DB REDO
  28. 35.
  29. 36.

    Copyright © 2020 Oracle and/or its affiliates. 36 Zero Downtime

    Migration Service(ZDM) Cloud Backup Module for OCI Data Pump , TTS
  30. 38.

    Copyright © 2020 Oracle and/or its affiliates. 38 OCI Database

    Oracle SQL Developer Oracle Database Oracle SQL Developer CDB CDB CDB CDB DDL SQL*Loader XML,INSERT,CSV
  31. 39.

    Copyright © 2020 Oracle and/or its affiliates. 39 RMAN Oracle

    OCI Database OCI Data Transfer Service (US and EU Only) “convert” the disk backup format to cloud backup RMAN> SEND CHANNEL t1 ‘ 2> export backuppiece /import/o1_mf_nnn.bkp, 3> export backuppiece /import/c-40712312- 01’; Perform restore as in previous examples scp encryption wallet
  32. 40.

    Copyright © 2020 Oracle and/or its affiliates. 40 2020/04/22 Youtube

    How to migrate AWS RDS Oracle DBs to OCI using OCI Backup Service https://www.youtube.com/watch?v=t7U2EH_M34Q https://www.slideshare.net/TammyBednar/database-cloud-services-office-hours-0421-migrate-aws- to-oci
  33. 41.