Oracle Database Migration to Oracle Cloud Infrastructure

Oracle Database Migration to Oracle Cloud Infrastructure Sinan Petrus Toma Senior Solution Engineer September, 2020

Sinan Petrus Toma 2 Passionate about Database & Cloud Technologies

Safe harbor statement The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, timing, and pricing of any features or functionality described for Oracle’s products may change and remains at the sole discretion of Oracle Corporation. 3 Copyright © 2020, Oracle and/or its affiliates

Agenda 1 Oracle Database in Oracle Cloud 2 Considerations for Cloud Migration 3 Automation Tools 4 5 4 Copyright © 2020, Oracle and/or its affiliates Migration Methods Decision Tree for Migration Methods

Oracle Database Cloud Offering 6 Copyright © 2020, Oracle and/or its affiliates DBCS ADBExa C@C Shared SE, EE, EE-HP, EE-EP EE 11.2, 12.1, 12.2, 18c, 19c, 20c on VM 19c EE-EP ADB C@CExaCS EE, EE-EP managed autonomous Max. CPU/Storage? Online Scaling? Install multiple DB homes and additional software?

7 Copyright © 2020, Oracle and/or its affiliates Logical & Physical (access to OS and CDB) Shared Logical (no access to OS and CDB) Data Pump RMAN 19 c Unplug / Plug Remote Clone Refreshable Clone 10110101 Data GuardGoldenGate Data Pump GoldenGate MV2ADB MV2OCI ZDM PDB Relocate

Cloud Benefits 8 Copyright © 2020, Oracle and/or its affiliates Higher Security • Self-patching • Encryption • IAM Simplified Management • Patching • Restore • Cloning Higher Availability & Performance • RAC • Data Guard • Exadata Automation • Infrastructure • Provisioning • Backups Cost Effectiveness • Scalability • Elasticity • Pay-per-use Take Automation to Next Level

Characteristics & Factors Database version • 11g, 12c, 18c, 19c Character set • UTF8, ISO8859P1, ... 10 Copyright © 2020, Oracle and/or its affiliates Database architecture • Non-CDB, Multitenant Database platform • Endian format (little, big) Data types • LONG, Mulitmedia, ... Database edition • Standard, Enterprise Isolation • Shared or dedicated environment Data transfer • Physical, Logical Database options • Adv. Security (TDE), RAC, .. Performance • VM, BM, Exadata Source database availability • Online, Offline

11 Copyright © 2020, Oracle and/or its affiliates Characteristics & Factors Network bandwidth • Internet, VPN, FastConnect • Storage Gateway • Data Transfer Appliance Database size • Small, medium, large • Long: Time needed for Data Pump conventional export and import for full backup & restore • Short: Time needed to copy the data files over the network or create and apply last incremental backup • Zero: Time needed for switchover or 1min for refreshable clones Options • Parallelism • Compression Downtime

Automation Tools 14 Copyright © 2020, Oracle and/or its affiliates MV2ADB MV2OCI ZDM Move to ADB Migration to Autonomous by using Data Pump Doc ID 2463574.1 Move to OCI Migration to DBCS by using Data Pump Doc ID 2514026.1 Zero Downtime Migration Migration to DBCS by using Standby Database oracle.com/database/technologies/rac/zdm.html All for Free

MV2ADB | move data to Autonomous Database in "one-click" 16 Copyright © 2020, Oracle and/or its affiliates 11g  Different version  Different architecture  Different endian format  Different character set  Logical  Online  SE, EE  Downtime: long object storage restAPI / oci cli impdp network link Installs & executes ADB Schema Advisor automatically Doc ID 2462677.1 expdp Autonomous PDB19c MV2ADB MV2ADB

MV2OCI | move data to Oracle Cloud Database in "one-click" 18 Copyright © 2020, Oracle and/or its affiliates 11g  Different version  Different architecture  Different endian format  Different character set  Logical  Online  SE, EE  Downtime: long DBCS MV2OCI expdp scp network link PDB19c local storage impdp MV2OCI

ZDM | Zero Downtime Migration 19 Copyright © 2020, Oracle and/or its affiliates Download ZDM1 Application ZDM SSH SSH SQLnet Connects to Source & Target2 Connects to Object Store3 Transfers DB Files4 Instantiates Standby5 Syncs Primary & Standby6 Switches Over & Role Swaps7 User Finalizes at Will8

20 Copyright © 2020, Oracle and/or its affiliates ZDM swtich over ZDM | Zero Downtime Migration ZDM PDB19cPDB19c  Same version  Same architecture  Same endian format  Compatible character set 101101010001  Physical  Online, Offline  EE, SE  Downtime: zero, long DBCS

21 Copyright © 2020, Oracle and/or its affiliates Sources TargetsZDM: https://dohdatabase.com/2020/07/06/zdm/ On-premise, OCI Classic, OCI DBCS VM, DBCS BM, ExaCS, ExaC@C Linux operating system Oracle Linux 7 or newer DB release 11.2.0.4 or newer Same release as on-premise Enterprise Edition Enterprise Edition (zero downtime) Standard Edition Standard Edition (offline) 12c non-CDB 12c non-CDB (ExaCS, ExaC@C) CDB CDB Single Instance Single Instance, RAC RAC one node, RAC RAC Encrypted, not encrypted Encrypted (no fallback if no ASO on-prem) Patch level Same, higher (run datapatch)

22 Copyright © 2020, Oracle and/or its affiliates For Autonomous Database use MV2ADB Cloud Migration | Best Practice For all other use cases use ZDM when applicable If not applicable, use manual methods according on your requirements

Data Guard 1. Data Guard 25 Copyright © 2020, Oracle and/or its affiliates PDB19cPDB19c  Same version  Same architecture  Same endian format  Compatible character set 101101010001 2 redo apply 1 create standby 3 switch over  Physical  Online  EE  Downtime: zero DBCS

Data Guard | Switchover and Upgrade 26 Copyright © 2020, Oracle and/or its affiliates PDB19cPDB12c  Different version  Same architecture  Same endian format  Compatible character set 101101010001 2 redo apply 1 create standby 3 switch over  Physical  Online  EE  Downtime: zero DBCS 4 upgrade

Data Guard | Transient Logical Standby 27 Copyright © 2020, Oracle and/or its affiliates PDB19cPDB12c  Different version  Same architecture  Same endian format  Compatible character set 101101010001 2 redo apply 1 create standby 4 switch over  Logical  Online  EE  Downtime: <5min DBCS 3 upgrade

GoldenGate 2. GoldenGate 28 Copyright © 2020, Oracle and/or its affiliates  Different version  Different architecture  Different endian format  Different character set 11g 2 initial load PDB19c 1 Set up GoldenGate 3 replicate unidirectional  Logical  Online  SE, EE  Downtime: zero 1 Set up GoldenGate DBCS Autonomous

3. Data Pump | Conventional Export/Import - DBCS 30 Copyright © 2020, Oracle and/or its affiliates Data Pump dump files local storage dump files local storage 11g PDB19c 1 expdp 3 impdp 2 scp  Different version  Different architecture  Different endian format  Different character set  Logical  Online  SE, EE  Downtime: long DBCS

Data Pump | Conventional Export/Import - ADB 31 Copyright © 2020, Oracle and/or its affiliates dump files local storage dump files object storage 11g 2 expdp 4 impdp 3 oci cli PDB19c  Different version  Different architecture  Different endian format  Different character set  Logical  Online  SE, EE  Downtime: long ADB Schema Advisor Doc ID 2462677.1 1 run ADB Schema Advisor Autonomous

Data Pump | Network Link 32 Copyright © 2020, Oracle and/or its affiliates DBCS Autonomous 11g 1 create DB link2 impdb NETWORK_LINK PDB19c  Different version  Different architecture  Different endian format  Different character set  Logical  Online  SE, EE  Downtime: long

4. Data Pump | Full Transportable 33 Copyright © 2020, Oracle and/or its affiliates dump files (meta data) local storage dump + data local storage 11g PDB19c 2 expdp FULL=y TRANSPORTABLE=always 4 impdp TRANSPORT_DATAFILES=  Physical  Offline  SE, EE  Downtime: short 3 scp (dump files) 3 scp (data files of user defined TBS)  Different version  Different architecture  Same endian format  Compatible character set 1 TBS read only DBCS

5. Data Pump | Transportable Tablespace 34 Copyright © 2020, Oracle and/or its affiliates dump dfiles meta data local storage dump + data local storage 11g PDB19c 2 expdp TRANSPORT_TABLESPACES= 5 impdp TRANSPORT_DATAFILES= 3 scp (dump files)  Different version  Different architecture  Same endian format  Compatible character set 1 TBS read only 3 scp (data files) 6 TBS read write 4 create user  Physical  Offline  SE, EE  Downtime: short DBCS

6. Data Pump | Convert Full Transportable 35 Copyright © 2020, Oracle and/or its affiliates dump files (meta data) local storage dump + data local storage 11g PDB19c 2 expdp FULL=y TRANSPORTABLE=always 5 impdp TRANSPORT_DATAFILES=  Physical  Offline  SE, EE  Downtime: short 4 scp (dump files)  Different version  Different architecture  Different endian format  Compatible character set 1 TBS read only 3 convert using DBMS_FILE_TRANSFER.PUT_FILE DBCS

Recovery Manager (RMAN) 36 Copyright © 2020, Oracle and/or its affiliates 7. Transportable Tablespace 8. Convert Transportable Tablespace 9. Cross-Platform Transportable Tablespace Backup Sets 10. Cross-Platform Transportable PDB 11. Cross-Platform Transportable PDB Inconsistent Backups 12. Duplicate from an Active Database 13. Backup & Restore RMAN 19c

37 Copyright © 2020, Oracle and/or its affiliates 7. RMAN | Transportable Tablespace with Data Pump local storage dump files local storage 11g PDB19c 1 rman TRANSPORT TABLESPACE 4 impdp TRANSPORT_DATAFILES= 2 scp (dump files)  Different version  Different architecture  Same endian format  Compatible character set dump files data files data files 2 scp (data files) 3 create user RMAN 19c  Physical  Online  SE, EE  Downtime: short DBCS

38 Copyright © 2020, Oracle and/or its affiliates 8. RMAN | Convert Transportable Tablespace with Data Pump  Different version  Different architecture  Different endian format  Compatible character set dump files local storage dump files local storage 11g PDB19c 2 expdp TRANSPORT_TABLESPACES= 6 impdp 7 TBS read write converted data files 1 TBS read only 3 rman CONVERT converted data files 5 create user 4 scp (dump files) 4 scp (data files)  Physical  Offline  SE, EE  Downtime: short DBCS

39 Copyright © 2020, Oracle and/or its affiliates 9. RMAN | Cross-Platform Transportable Tablespace Backup Sets  Different version  Different architecture  Different endian format  Compatible character set dump files local storage dump files local storage 11g PDB19c 2 rman BACKUP FOR TRANSPORT 5 rman RESTORE FOREIGN TABLESPACE 6 TBS read write backup set 1 TBS read only 4 create user backup set 3 scp (dump files) 3 scp (backup set)  Physical  Offline  SE, EE  Downtime: long DBCS

40 Copyright © 2020, Oracle and/or its affiliates 10. RMAN | Cross-Platform Transportable PDB  Different version >= 12.1  Same architecture  Same endian format  Compatible character set  Physical  Offline  SE, EE  Downtime: long local storage local storage PDB19c 2 rman BACKUP FOR TRANSPORT UNPLUG INTO 4 rman RESTORE USING ... FOREIGN PLUGABLE DATABASE 5 upgrade PDB full backup 1 close PDB full backup 3 scp (XML files) 3 scp (backup set) PDB12.1 XML file XML file 6 open PDB DBCS

rman BACKUP INCREMENTAL LEVEL 0 FOR TRANSPORT ALLOW INCONSISTENT rman RESTORE FOREIGN PLUGGABLE DATABASE 41 Copyright © 2020, Oracle and/or its affiliates 11. RMAN | Cross-Platform Transportable PDB Inconsistent Backups  Different version >= 12.2  Same architecture  Same endian format  Compatible character set local storage local storage PDB19c 1 3 backup level 0 backup level 0 7 scp (XML files) 2 scp (backup level 0) PDB12.1 XML file 9 upgrade PDB open PDB  Physical  Offline  SE, EE  Downtime: short 6 rman BACKUP INCREMENTAL FROM SCN … FOR TRANSPORT UNPLUG INTO 5 close PDB backup level 1 7 scp (final backup level 1) XML file backup level 1 8 rman RECOVER USING ....xml FOREIGN DATAFILECOPY 4 create & apply level 1 backups 10 DBCS

12. RMAN | Duplicate from an Active Database 42 Copyright © 2020, Oracle and/or its affiliates  Same version  Same architecture  Same endian format  Compatible character set  Physical  Online  SE, EE  Downtime: long PDB19c 2 rman DUPLICATE PDB19c 1 create auxiliary instance DBCS

43 Copyright © 2020, Oracle and/or its affiliates 13. RMAN | Backup & Restore PDB19c 2 rman BACKUP rman RESTORE4 backup object storage PDB19c  Same version  Same architecture  Same endian format  Compatible character set backup 3 copy backup local storage 1 close PDB DBCS  Physical  Offline  SE, EE  Downtime: long

44 Copyright © 2020, Oracle and/or its affiliates RMAN | Backup & Restore PDB19c 2 rman BACKUP rman RESTORE3 backup object storage PDB19c  Same version  Same architecture  Same endian format  Compatible character set 1 close PDB Database Backup Cloud Service DBCS  Physical  Offline  SE, EE  Downtime: long

Mulitetenant Architecture 45 Copyright © 2020, Oracle and/or its affiliates 14. Unplug & Plug 15. Remote Cloning 16. Remote Hot Cloning 17. PDB Refreshable Clone 18. PDB Relocate Unplug / Plug Remote Clone Refreshable Clone 10110101 PDB Relocate

Unplug / Plug 14. Unplug & Plug | PDB 46 Copyright © 2020, Oracle and/or its affiliates PDB19cPDB12.1 1 close PDB local storage XML + data local storage XML file 2 unplug PDB 3 scp (xml file) 4 plug in PDB 3 scp (data files) 5 upgrade PDB  Different version >= 12.1  Same architecture  Same endian format  Compatible character set  Physical  Offline  SE, EE  Downtime: short 6 open PDB DBCS

Unplug & Plug | non-CDB 47 Copyright © 2020, Oracle and/or its affiliates PDB19c local storage XML + data local storage XML file 3 scp (xml file) 4 plug in nonCDB 5 upgrade PDB  Different version >= 12.1  Different architecture  Same endian format  Compatible character set nonCDB12.1 1 DB read only 2 DBMS_PDB.DESCRIBE 6 noncdb_to_pdb.sql 3 scp (data files)  Physical  Offline  SE, EE  Downtime: short 7 open PDB DBCS

Remote Clone 15. Remote Cloning | PDB 48 Copyright © 2020, Oracle and/or its affiliates PDB19cPDB12.1 2 PDB read only 4 upgrade PDB  Different version >= 12.1  Same architecture  Same endian format  Compatible character set 1 create DB link 3 create PDB clone  Physical  Offline  SE, EE  Downtime: short 5 open PDB DBCS

Remote Cloning | non-CDB 49 Copyright © 2020, Oracle and/or its affiliates PDB19c 5 noncdb_to_pdb.sql 1 create DB link 3 create PDB clone  Different version >= 12.1  Different architecture  Same endian format  Compatible character set nonCDB12.1 2 DB read only 4 upgrade PDB  Physical  Offline  SE, EE  Downtime: short 6 open PDB DBCS

Remote Clone 16. Remote Hot Cloning | PDB 50 Copyright © 2020, Oracle and/or its affiliates PDB19cPDB12.1 3 upgrade PDB  Different version >= 12.2  Same architecture  Same endian format  Compatible character set 1 create DB link 2 create PDB clone  Physical  Online  SE, EE  Downtime: short 4 open PDB DBCS

Remote Hot Cloning | non-CDB 51 Copyright © 2020, Oracle and/or its affiliates PDB19c 4 noncdb_to_pdb.sql 1 create DB link 2 create PDB clone  Different version >= 12.2  Different architecture  Same endian format  Compatible character set nonCDB12.1 3 upgrade PDB  Physical  Online  SE, EE  Downtime: short 5 open PDB DBCS

Refreshable Clone 10110101 17. PDB Refreshable Clone 52 Copyright © 2020, Oracle and/or its affiliates PDB19cPDB12.2 4 upgrade PDB  Different version >= 12.2  Same architecture  Same endian format  Compatible character set 1 create DB link 2 create PDB refresh 1011010100101 3 refresh (manual, auto)  Physical  Online  SE, EE  Downtime: 1min 5 open PDB DBCS

PDB Relocate 18. PDB Relocate 53 Copyright © 2020, Oracle and/or its affiliates PDB19cPDB12.2.0.1 3 upgrade PDB  Different version >= 12.2  Same architecture  Same endian format  Compatible character set 1 create DB link 2 create PDB relocate  Physical  Online  SE, EE  Downtime: short 4 open PDB (Production) Migration? DBCS

PDB Relocate | AVAILABILITY MAX 54 Copyright © 2020, Oracle and/or its affiliates PDB19cPDB19c  Same version >= 12.2  Same architecture  Same endian format  Compatible character set 1 create DB link 2 create PDB relocate AVAILABILITY MAX  Physical  Online  SE, EE  Downtime: zero DBCS

Further Methods 56 Copyright © 2020, Oracle and/or its affiliates  Logical  Online  SE, EE  Downtime: min/hrs  Different version  Different architecture  Different endian format  Different character set  Small amount of data  Limited number of objects  Flat files SQL Developer 23. SQL*Loader 20. SQL Developer Cart Utility 19. SQL Developer Database Copy Utility 24. DBMS_CLOUD COPY_DATA & CREATE_EXTERNAL_TABLE - Autonomous 25. DB Link & Create Table As Statement (CTAS) 21. SQL Developer Drag and Drop Option 22. SQL Developer Export and Import Wizard

Summary 59 Copyright © 2020, Oracle and/or its affiliates category migration_method version architecture endian_format character_set data_transfer source_availability edition downtime min_version MAA Data Guard same same same compatible physical online EE zero 9i MAA GoldenGate different different different different logical online SE,EE zero 8i DataPump Data Pump - Conventional Export/Import different different different different logical online SE,EE long 10.2 DataPump Data Pump - Transportable Tablespace different different same compatible physical offline SE,EE short 10.2 DataPump Data Pump - Full Transportable different different same compatible physical offline SE,EE short 10.2 DataPump Data Pump - Convert Full Transportable different different different compatible physical offline SE,EE short 10.2 RMAN RMAN - Transportable Tablespace with Data Pump different different same compatible physical online SE,EE short 10.2 RMAN RMAN - Convert Transportable Tablespace with Data Pump different different different compatible physical offline SE,EE short 10.2 RMAN RMAN - Cross-Platform Transportable Tablespace Backup Sets different different different compatible physical offline SE,EE long 10.2 RMAN RMAN - Cross-Platform Transportable PDB different same same compatible physical offline SE,EE long 12.1 RMAN RMAN - Cross-Platform Transportable PDB Inconsistent Backups different same same compatible physical offline SE,EE (very) short* 12.2 RMAN RMAN - Duplicate from an Active Database same same same compatible physical online SE,EE long 10.2 RMAN RMAN - Backup & Restore same same same compatible physical online SE,EE long 8i Multitenant PDB Unplug & Plug different same same compatible physical offline SE,EE short 12.1 Multitenant PDB Remote Cloning different same same compatible physical offline SE,EE short 12.1 Multitenant PDB Remote Hot Cloning different same same compatible physical online SE,EE short 12.2 Multitenant PDB Refreshable Clone different same same compatible physical online SE,EE 1min 12.2 Multitenant PDB Relocate different same same compatible physical online SE,EE short 12.2 Multitenant PDB Relocate - AVAILABILITY MAX same same same compatible physical online SE,EE zero 12.2 *faster than Unplug/Plug or Remote Cloning for larg databases

60 Copyright © 2020, Oracle and/or its affiliates • Long: Time needed for Data Pump conventional export and import for full backup & restore • Short: Time needed to copy the data files over the network or to create and apply the last incremental backup. • Zero: Time needed for switchover or 1min for refreshable clones migrate to? downtime? downtime? target character set? downtime? source endian format? downtime? source release level? source release level? Data Pump Data Pump Data Pump Data Pump Golden Gate Golden Gate Golden Gate Golden Gate Golden Gate CONVERT Transportable TBS Transportable TBS RMAN Backup/Restore PDB Unplug/Plug PDB Remote Clone PDB Refreshable Clone Data Guard Data Guard Autonomous DBCS long zero different compatible big endian long zero long zeroshort little endian long zeroshort <=11.2 >=12.1 <=12.1 >=12.2 Cross-Platform TBS Backup Sets Transportable PDB Inconsistent Bck PDB Relocate >=12.2 Transportable TBS PDB Unplug/Plug PDB Remote Clone Transportable PDB Transportable TBS Cross-Platform TBS Backup Sets RMAN Duplicate Transportable PDB Review the Oracle documentation:  Prerequisites  Restrictions  Recommendations Testing! Testing! Testing!

61 Copyright © 2020, Oracle and/or its affiliates 10 Series Blog https://www.linkedin.com/pulse/10-series-blog-20-ways-migrate-your-oracle-database-sinan-petrus-toma Part 1/10: Why to Migrate your Oracle Database to Oracle Cloud? Part 2/10: Introduction to Oracle Database Cloud Services Part 3/10: Oracle Database Migration Considerations Part 4/10: Automation Tools and Maximum Availability Architecture Migration Methods Part 5/10: Migration Methods using Data Pump Part 6/10: Migration Methods using RMAN Part 7/10: Migration Methods using Multitenant Architecture Part 8/10: Migration Tools and Methods for Small Amount of Data Part 9/10: Migrating Oracle Databases from AWS to Oracle Cloud Part 10/10: Summary and a Migration Decision Tree

62 Copyright © 2020, Oracle and/or its affiliates Further Reading • Move to the Oracle Cloud - oracle.com/goto/move • Cloud Migration Advisor - https://www.oracle.com/webfolder/s/assets/webtool/cloud-migration-advisor/index.html • Oracle Architecture Center - https://docs.oracle.com/en/solutions/ • Oracle Database Cloud Migration Methods - https://www.oracle.com/database/technologies/cloud-migration.html#migration-methods • Migrating Databases to the Cloud - https://docs.cloud.oracle.com/en-us/iaas/Content/Database/Tasks/migrating.htm • Oracle Zero Downtime Migration - https://www.oracle.com/database/technologies/rac/zdm.html - https://dohdatabase.com/2020/07/06/zdm/

Our mission is to help people see data in new ways, discover insights, unlock endless possibilities.

Oracle Database Migration to Oracle Cloud Infrastructure

More Related Content

What's hot

Similar to Oracle Database Migration to Oracle Cloud Infrastructure

Recently uploaded

In this document

Oracle Database Migration to Oracle Cloud Infrastructure