Oracle Modern Cloud Day · 2019-11-21 · Oracle Modern Cloud Day Oracle Modern Cloud Day 18...

Oracle Modern Cloud Day

Copyright © 2019, Oracle and/or its affiliates. All rights reserved. |


1

1

18 Methods for Database Migration to Oracle Cloud

김승현 상무 / Solution Engineering Director

한국오라클 / Oracle Korea

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.

2 Copyright © 2019 Oracle and/or its affiliates

Database Migration 고려사항

Program agenda

1

2

3

배경지식들

18 Methods for Database Migration

3 Copyright © 2019 Oracle and/or its affiliates



Database Migration 고려사항

Database Migration을위한다양한조합들

Copyright © 2019 Oracle and/or its affiliates5

Source 11gR2On-Premise

Little Endian Family

Big Endian Family

ATPServerless

VMDB System

Bare MetalDB System

AutonomousData

Warehouse

ATPDedicated

ExadataDB System

Database onOCI Compute

11gR2, 12cR1,12cR2, 18c,

19c

Database Migration 방법결정을위한고려사항들


SourceDatabaseHost OS

SourceDatabaseVersion

SourceDatabase

Character Set

Source CDBor Non CDB

Source DBData Types

OCIDB SystemVersions

ProjectFinancials &

Licensing

PermissibleDowntime

NetworkBandwidth

SourceDatabase

Size

StagingStorage

Requirement

Many More........

18 Methods for Database Migration to OCI (1/2)


✓ RMAN Cross Platform Incremental Transportable Tablespace

✓ Hybrid DataGuard from OnPremise to OCI DBSystem

✓ Golden Gate Real Time Replication

✓ RMAN Restore and Recovery from Full Backup

✓ RMAN Active Duplicate

✓ MV2OCI: Move Data to Oracle Cloud Database in "One Click"

✓ Unplugging and Plugging a PDB

✓ Unplugging and Plugging a NonCDB

✓ Remote Clone PDB

✓ Remote Clone (NonCDB)

18 Methods for Database Migration to OCI (2/2)


✓ Data Pump Conventional Export Import

✓ Data Pump Full Transportable

✓ Data Pump Transportable Tablespace

✓ RMAN Active Duplicate for PDBs

✓ RMAN Cross Platform Transportable PDB

✓ RMAN Cross Platform TTS Backup Sets

✓ RMAN Transportable Tablespace with Data Pump

✓ RMAN Convert Transportable Tablespace with Data Pump



배경 지식들

18 Methods for Database Migration to OCI –유형별로재정렬


1. Data Pump Conventional Export Import

2. Data Pump Transportable Tablespace

3. Data Pump Full Transportable

4. MV2OCI: Move Data to Oracle Cloud Database in "One-Click"

5. RMAN Restore and Recovery from Full Backup

6. RMAN Transportable Tablespace with Data Pump

7. RMAN Convert Transportable Tablespace with Data Pump

8. RMAN Cross Platform Incremental Transportable Tablespace

9. RMAN Cross Platform TTS Backup Sets

10. RMAN Cross Platform Transportable PDB

11. RMAN Active Duplicate

12. RMAN Active Duplicate for PDBs

13. Unplugging and Plugging a Non CDB

14. Unplugging and Plugging a PDB

15. Remote Clone (Non CDB)

16. Remote Clone PDB

17. Hybrid DataGuard from On-Premise to OCI DB System

18. Golden Gate Real Time Replication

PDB, CDB, NonCDB

Multitenant 아키텍처 (Oracle Database 12c 이상)


Pluggable Databases (PDBs)

PDBs

CDB

RMAN

데이타베이스의 Backup, Restore 및 Recovery를 수행하기위한클라이언트유틸리티


Incremental /Cumulative

Image Copy,BackupSet

Transportable Tablespace

Duplicate,Convert

✓ 백업에필요한설정을관리

✓ 백업해야할데이터를알아서인식

✓ 복구에필요한백업을자동으로선택

✓ 백업및복구명령의단순화

✓ 데이터블록단위로 backup, restore, recovery 가능

✓ 파일손상감지

✓ RMAN 고유기능사용가능

Data Guard 와 Oracle GoldenGate

▪ Data Guard : DR 솔루션

오라클데이터베이스에최적화된 DR 및고가용성솔루션

▪ Oracle GoldenGate : 데이터동기화솔루션

트랜잭션로그를이용하여변경된데이터를동기화하는방식


Transaction Log(Redo/Archive Log)

Source System Target System

소스Database

타겟Database

Trail

FilesTrail

Files

Oracle

GoldenGate

Oracle

GoldenGate

TCP/IPExtract Replicat

SQL

ODS/DW, DR, Data Hub, Batch/Reporting System

Pump Collector

Oracle, DB2MySQL, PostgreSQL 등

Oracle, DB2MySQL 등

데이터파일

Oracle 인스턴스 Oracle 인스턴스

복구용파일

복구용파일

DB 변경정보

데이터파일

DB 레벨에서물리적/논리적으로블록 정합성 체크

Primary Database Standby Database

Source System Target System



18 Methods for Database Migration

Method01 : Data Pump Conventional Export Import

• Use Case 및특징

Endian Format 변환에사용

캐릭터셋변환에사용

동일한버전또는낮은버전에서 높은버전으로마이그레이션에 사용

주로 Schema 마이그레이션에사용

• 고려사항및유의할점

데이터베이스가크면시간이걸림

Role, 권한, 유저의세밀한관리가 필요

PerformEXPDP to

ExportSchemas

PrepareSource

System forData pump

Export

Securely CopyCreated Dump

Files to OCIDBSystem

Prepare Target

for Data pumpImport

PerformIMPDP and

ValidateMigrated Data


Method02 : Data Pump Transportable Tablespace


Conventional Export Import 보다빠름

11g에서 11g 12c 18c 19c로 마이그레이션 시사용

TRANSPORT_TABLESPACES=TS1, TS

TRANSPORT_FULL_CHECK=YES


호환가능한캐릭터셋일때사용가능

테이블스페이스 자체가포함되어있는지 확인

InvokeTransport

TablespacesExport

Put SourceTablespace in

Read OnlyMode

Securely CopyCreated DumpFiles and Data


CreateRequiredUsers atTarget

PerformImport withTransportDatafilesOption


Method03 : Data Pump Full Transportable



11gR2에서 12c로마이그레이션에 사용

12c NonCDB에서 12c로마이그레이션에 사용

12c CDB에서 12c로마이그레이션에 사용

OnPremise >= 11.2.0.3



호환가능한캐릭터셋일때 사용가능

Invoke Full Yand

TransportableALWAYSExport

Put SourceTablespace in

Read OnlyMode

Securely CopyCreated DumpFiles and Data


Perform FullTransportable

Data pumpImport

Validate Data


Method04 : MV2OCI: Move Data to Oracle Cloud Database in "One Click"



동일한버전또는낮은버전에서 높은버전으로마이그레이션시 사용

Schema 마이그레이션에사용



시스템에 대한 root 권한이필요함

Datapump Files are directly moved to OCI DBSystems

InstallMV2OCI RPMat OnPremise

Database

PrepareSource

System forMV2OCI

CreateConfiguration

File

PerformMV2OCI inAuto Mode

Validate Data


Method05 : RMAN Restore and Recovery from Full Backup


OnPremise가 Little Endian인경우사용

데이터베이스가 클수록다운타임이 길어짐

Traditional Backup and Recovery


패치셋레벨및패치조정필요

손쉬운 Migration으로 선호되는 방법

NonProduction 마이그레이션에주로사용

ImplementCloud Backup

Module atOnPremiseDatabase

ImplementTDE at

OnPremiseDatabase

Take Backupto the OCI

ObjectStorage

Create OCIDBSystem

from ObjectStorageBackup

Validate theDBSystemand Data


Method06 : RMAN Transportable Tablespace with Data Pump


OnPremise가 Little Endian인경우사용

Tablespace Migration and Database Consolidation

NonProduction 마이그레이션에주로사용



마이그레이션동안 OnPremise 테이블스페이스는R/W 가능

OnPremise 운영환경에서 OCI DBSystem개발/테스트환경으로복제하는데사용

Backup UsingTRANSPORTTABLESPACE

Clause

CreateAUXILIARY &TABLESPACE

Destination atOnPremise

Host

Securely Copythe Content

fromTABLESPACE

Destination toOCI DBSystem

Create Userand DBA

Directory onOCI DBSystem

Invoke Importwith

TransportDatafileOption


Method07 : RMAN Convert Transportable Tablespace with Data Pump




RMAN 과 Data Pump는 별도로실행



마이그레이션동안 OnPremise 테이블스페이스는Read Only 모드

NonProduction Migration에 주로사용

PerformEXPDP withTRANSPORT

TABLESPACESOption

Put SourceTablespaces In

Read OnlyMode

Invoke RMANwith

CONVERTTABLESPACE

Clause

Create Userand DBA

Directory onOCI DBSystem

Invoke Importwith

TransportDatafileOption


Copyright © 2019 Oracle and/or its affiliates

데이터베이스크기가 10TB 이상인 AIX에서 OnPremise

Database >= 11.2.0.4를실행중입니다. 참조무결성및일부

지원되지않는데이터타입으로인해 Golden Gate는사용할수

없습니다. OCI DB 시스템으로마이그레이션하는데 6시간

이상의다운타임은허용될수없습니다.

선택할수있는가장좋은마이그레이션방법은어떤것일까요?

Cloud Migration Quiz

Method08 : RMAN Cross Platform Incremental Transportable Tablespace


대량의데이터베이스에최상의방법 (Metadata Size is Small)


다운타임감소


상당한양의 DBA effort가필요

복잡하지만많은고객이사용하는방법

초기부터 마이그레이션 방법안정화를 위한노력이요구됨

Prepare Phase(SourceOnline)

Initial Setup(SourceOnline)

Roll ForwardPhase (Source

Online)

TransportPhase (Source

Read Only)

Data Validation



OnPremise에 AIX에서동작중인 100개이상의 NonProduction

데이터베이스가있습니다. 데이터베이스통합의일부로 OCI

DBSystem으로마이그레이션하려고합니다. 가동중지시간은

제약조건이아니며효과적이고사용하기쉬운마이그레이션

방법을찾고있습니다.

이시나리오에가장적합한마이그레이션방법은무엇입니까?


Method09 : RMAN Cross Platform TTS Backup Sets




Database Version >= 12.1.0.2



마이그레이션 동안 OnPremise 테이블스페이스는Read Only 모드

데이터베이스가커질수록다운타임증가

Backup UsingTO

PLATFORMLinux x86 64

bit

Put the SourceTablespace in

Read OnlyMode

Securely Copythe Backup

Sets and DataPump Export

Dump toDestination

RestoreForeign

Tablespace /Datafiles

ALTER theTablespace to

Read Write



여러 CDB에흩어져있는 OnPremise Little Endian Family에서

실행되는중간크기(~ 500GB)의 12.2 Pluggable 데이터베이스

몇개가있습니다. OCI ExaCS DBSystem으로마이그레이션하고

통합하려고합니다.

다운타임을줄일수있는방식을고려할때가능한최상의

마이그레이션방법은무엇입니까?


Method10 : RMAN Cross Platform Transportable PDB


OnPremise 데이터베이스가 Little Endian인경우사용

XML 파일을사용한 RMAN 백업기반마이그레이션




다운타임을줄이기위해 12.2 부터 backup에‘ALLOW INCONSISTENT’ 기능추가

백업시간단축, 복원시간은동일하게 유지

Securely Copythe Backup

Piece and PDBMetadata

Close SourcePDB and Take

Backup forTransport

Check PlugInCompatibilityat Destination

RestoreForeign

PluggableDatabase

from BackupSets

Open theRestoredPluggableDatabase



OnPremise에서 Oracle Database 11.2.0.4 또는 12cR1 / 2 /

18c Linux x86 64를실행중입니다. 마이그레이션의첫단계로

모든 NonProduction 워크로드를 OCI DB System으로

마이그레이션하고 OnPremise Production에서 OCI로빈번한

복제를수행하려고합니다.

선택할수있는가장좋은마이그레이션방법은무엇입니까?


Method11 : RMAN Active Duplicate


Multiple Databases에 FastConnect를사용하는최상의방법

리눅스나 윈도우를사용하는 OnPremise데이터베이스에 사용


소스와타겟은동일한패치레벨이요구됨

TDE를 사용하는경우 TDE Wallet 사본과 Auto Login 은필수


ConfigureStatic Listener

on OCIDBSystem

PrepareSource for

RMAN ActiveDuplicate

(Patch Set)

Copy TDEWallet from

Source toTarget andAuto Login

EstablishConnectivity

b/wOnPremise

and OCIDBSystem

PerformRMAN Active

Duplicate


Method12 : RMAN Active Duplicate for PDB


Multiple PDB Databases에 FastConnect를사용하는최상의방법

리눅스나 윈도우를사용하는 OnPremise데이터베이스에 사용


소스와타겟은동일한패치레벨이요구됨


소스 PDB에는암호화된테이블스페이스가없어야함

ConfigureStatic Listener

on OCIDBSystem

PrepareSource for

RMAN ActiveDuplicate

(Patch Set)

EstablishConnectivity

b/wOnPremise

and OCIDBSystem

PerformRMAN Active

Duplicate

PerformValidation ofPDB on OCIDBSystem


Method13 : Unplugging and Plugging a NonCDB


NonCDB 마이그레이션및콘솔리데이션의간단하면서도효과적인방법

OnPremise가 Little Endian Family인 경우사용

데이터베이스 콘솔리데이션에 주로사용

작은 NonCDB 데이터베이스에유용함


데이터베이스가클수록다운타임이증가

PDB 데이터베이스 오픈전에모든플러그인Violation 해결필요

Securely Copythe XML Fileand Datafiles

to OCIDBSystem

Open theNonCDB in

Read Only andUnplug toXML File

InvokeCREATE

PLUGGABLEDATABASE

ExecuteNonCDB to

PDB Script forCleanup andConversion

Resolve allPlugIn

Violations andOpen the PDB


Method14 : Unplugging and Plugging a PDB


간단하면서도효과적인 PDB 마이그레이션방법

OnPremise가 Little Endian Family인 경우사용

데이터베이스 콘솔리데이션에 주로사용

작은 PDB 데이터베이스에유용함


데이터베이스가클수록다운타임이증가

PDB 데이터베이스 오픈전에모든플러그인Violation 해결필요

Securely Copythe XML Fileand Datafiles

to OCIDBSystem

Close the PDBand Unplug to

XML File

InvokeCREATE

PLUGGABLEDATABASE

Resolve allPlugIn

Violations

Open the PDBand Validate



OnPremise Windows 환경에서 1000개이상의작은

NonCDB를실행하고있으며, OCI DB System에는

Multitenant 데이터베이스로구성하고 DBA 공수가적게

들어가는방법으로마이그레이션및통합하려고합니다.

어떤마이그레이션방법을선택하시겠습니까?


Method15 : Remote Clone NonCDB


OnPremise 데이터베이스가 Little Endian인경우사용

DB Link를통한복제



마이그레이션동안 NonCDB 는 Read Only 모드


PDB 제한모드를 피하기 위하여플러그인시Violation에 대한주의가필요

마이그레이션 방법안정화 작업

CreateDatabase Link

Pointing toSource CDB

Create SourceUser, Give

Grants

CreatePluggableDatabaseNON$CDB

ExecuteNonCDB to

PDB SQLScript

Resolve PlugInViolations andOpen the PDB



OnPremise Linux 환경에서실행되는여러 CDB에 1000개

이상의작은 PDB가분산되어있으며, OCI DB System으로 DBA

공수가적게들어가는방법으로마이그레이션및통합하고자

합니다.

어떤마이그레이션방법을선택하시겠습니까?


Method16 : Remote Clone PDB


OnPremise 데이터베이스가 Little Endian이고멀티테넌트 DB를 사용하는경우사용

DB Link를통한복제



PDB Closed for Migration


PDB 제한모드를 피하기 위하여 PDB 플러그인시Violation에 대한주의가필요

마이그레이션 방법안정화 작업

Update TargetTNS File withSource PDBConnectivity

String

Create SourceUser, GiveGrants and

Close the PDB

CreateDatabase Link

Pointing toSource PDB

PerformRemote Clone

PDB UsingCreate

PluggableDatabase

Resolve PlugInViolations andOpen the PDB



데이터베이스크기가 50GB에서 50TB 사이인 Linux 또는

Windows에서 OnPremise Database>= 11.2.0.4를실행

중입니다. OnPremise의모든 12c/18c 데이터베이스는

Multitenant입니다. 다운타임이거의없는 OCI DB

시스템으로가장안정적인마이그레이션방법을찾고있습니다.

선택할수있는가장좋은마이그레이션방법은무엇입니까?


Method17 : Hybrid DataGuard from On-Premise to OCI DB System


Near zero downtime

가장널리사용되는마이그레이션방법

DR-to-Cloud 솔루션으로 구현됨, 여러번의훈련후전환필요


On-Premise Linux/Windows

원활한마이그레이션을위해 DR훈련이중요

PrepareSource andTarget forDataGuard

Setup

EstablishConnectivityb/w Source and Target

RMANStandby

Duplicate orRestore from

Service

Multiple DRDrill for Issue

Resolutionand

Integrations

Switchoverand Fly High

with OCI


Method18 : Golden Gate Real Time Replication



Near zero downtime

가장널리사용되는마이그레이션방법




마이그레이션 비용고려

TTS 및 DataPump 활용가능

PerformOGG Extract and Pump

process

PrepareSource andTarget for

Golden GateSetup

Backup and Recovery

Perform OGG Replicat

process

Switchoverand Fly High

with OCI

Summary

▪ Endian Format 변환

✓ Data Pump Conventional Export Import

✓ Data Pump Full Transportable

✓ RMAN Convert Transportable Tablespace with Data Pump


✓ RMAN Cross Platform TTS Backup Sets

▪ Reduce DownTime


✓ Hybrid DataGuard from On-Premise to OCI DB System

✓ Golden Gate Real Time Replication

▪ OnPremise DB 12.1.0.2 이상

✓ RMAN Cross Platform Transportable PDB

✓ RMAN Active Duplicate (PDB)

✓ Unplugging and Plugging a (NonCDB/PDB)

✓ Remote Clone (NonCDB/PDB)


✓ Database Migration Service - Announced (available soon)

Thank you

Seunghyun Kim

Solution EngineeringOracle Korea


Oracle Modern Cloud Day · 2019-11-21 · Oracle Modern Cloud Day Oracle Modern Cloud Day 18...

Documents

Transcript of Oracle Modern Cloud Day · 2019-11-21 · Oracle Modern Cloud Day Oracle Modern Cloud Day 18...