• Presencial

Migrating Oracle Database to the Oracle Cloud


This course teaches you how to migrate your On-Premises Oracle Database to Oracle Database Cloud.

It’s ideal for experienced DBAs who want to learn about the migration techniques to Oracle Database Cloud Service using RMAN, Data Pump, Unplug/Plug, Remote Cloning, and SQL Developer. Lessons are reinforced with hands on labs and use cases on advanced migration methods using Data Guard, GoldenGate and Lift & Shift.

Learn To:

  • Analyze and compare your source and target environments.
  • Migrate PL/SQL objects, tables, and views by using SQL Developer.
  • Use the unplug/plug method to migrate an on-premises database to Database Cloud Service.
  • Clone an on-premises database into a Database Cloud Service CDB.
  • Explore the RMAN backup and restore mechanism.
  • Identify the cloud tooling features available for database administration.
  • Describe advanced migration methods using Data Guard, GoldenGate and Lift & Shift.

Benefits to You

You will benefit from interactive sessions that cover these areas:

  • Database Deployment: instructors will provide an overview of what the Oracle Public Cloud offers in terms of services. Learn how to sign in to an Oracle Public Cloud account and create a database deployment. With this you can setup test/dev environment on Oracle Database Cloud Service.
  • Migration: develop a deeper understanding of the benefits of migrating an on-premises database to Oracle Database Cloud Service. Review migration methods, including RMAN, Data Pump, unplug/plug, remote cloning, and SQL Developer. Furthermore, learn migration using advanced methods including Oracle Data Guard, Golden Gate and Database Lift & Shift. With this you can plan your cloud migration strategy and also create secure and reliable database deployments.
  • Cloud Tooling: you’ll learn how Cloud Tooling will assist you in database patching, backup/recovery and monitoring. This will help you better manage your administrative tasks and also improved SLAs.

Destinatários

This course is ideal for experienced DBAs who are looking to enhance their skills to become Cloud Migration experts. Taking this hands-on training will prepare DBAs for Cloud DBA certification exams.

Pré-requisitos

Suggested Prerequisite

  • Experience in Oracle Database 11g and / or 12c Administration
  • Working knowledge of Oracle Database Cloud Service (DBCS)

Required Prerequisite

  • Oracle Database 12c R2: Administration Workshop
  • Oracle Database 12c R2: New Features for 12c R1 Administrators
  • Oracle Database 12c R2: Managing Multitenant Architecture
  • Oracle Database 12c R2: Backup and Recovery Workshop
  • Using Oracle Enterprise Manager Cloud Control 13c

Objetivos

  • Use-Case: Pluggable Database Lift & Shift by Using Enterprise Manager Cloud Control 13c
  • Identify Oracle Cloud offerings and describe the benefits of migrating to Oracle Cloud
  • Use the unplug/plug method to migrate an on-premises database to Database Cloud Service
  • Describe the available migration methods
  • Analyze and compare your source and target environments
  • Create a database deployment on Oracle Cloud in preparation for migration
  • Use-Case: Migrating an On-Premises Database by Using Remote Cloning
  • Explore the RMAN backup and restore mechanism
  • Use-Case: Migrating a 12c Database to Oracle Cloud by Using RMAN Cross-Platform Transportable Tablespace
  • Identify the cloud tooling features available for database administration
  • Use-Case: Migrating to Oracle Database Cloud Service by Using Data Guard (Physical Standby)
  • Use-Case: Migrating to Oracle Database Cloud Service by Using GoldenGate
  • Migrate PL/SQL objects, tables, and views by using SQL Developer
  • Describe the Data Pump conventional export/import method to migrate an on-premises database to Oracle Cloud
  • Describe the Database Lift & Shift advanced migration method using Enterprise Manager 13c
  • Describe the Data Pump full transportable method

Programa

  • Migrating Oracle Database to Oracle Public Cloud: Why? What? How?
  • Analyzing and Choosing Your Migration Strategy
  • Migrating Using SQL Developer
  • Migrating an On-Premises Database by Using Data Pump
  • Migrating an On-Premises Database by Using Unplugging/Plugging and Remote Cloning
  • Migrating an On-Premises Database by Using Recovery Manager (RMAN)
  • What Changes After Migration?
  • Advanced Migration by Using Data Guard
  • Advanced Migration by Using Golden Gate
  • Advanced Migration Method Using Lift & Shift

Migrating Oracle Database to Oracle Public Cloud: Why? What? How?

  • Migration Methods: Overview
  • Why Migrate to Oracle Cloud?
  • Oracle Database Cloud Service: Overview
  • What Is Oracle Cloud?
  • Considerations for Choosing a Migration Method
  • Managing Oracle Database: On-Premises Versus Oracle Cloud
  • What Can You Migrate to Oracle Database Cloud?
  • Migration to PaaS (DBCS) Versus IaaS

Analyzing and Choosing Your Migration Strategy

  • What To Migrate to Oracle Cloud
  • Choosing a Hardware Configuration: Compute Shapes
  • Migration Prerequisites
  • Database Cloud Service Architecture
  • Choosing a Method:
  • Migration Strategy
  • Moving Large Data Sets to Oracle Cloud
  • Migration Life Cycle of a Target Cloud Database

Migrating Using SQL Developer

  • Migrating Objects by Using SQL Developer
  • Post-Migration Verification Checklist
  • Migrating by Using SQL Developer
  • Migrating Selected Objects by Using SQL Developer INSERT Statements
  • Migrating Selected Objects by Using SQL Developer and SQL*Loader
  • Oracle SQL Developer: Overview
  • Migrating PL/SQL Objects

Migrating an On-Premises Database by Using Data Pump

  • Full Transportable Mode & NETWORK_LINK Mode
  • Special Considerations & Post-Migration Verification Checklist
  • Data Pump Export and Import Modes
  • Conventional Modes for Migrating an On-Premises Oracle Database
  • Transportable Tablespace (TTS) Mode
  • How Does Data Pump Load and Unload Table Row Data?
  • Oracle Data Pump: Overview & Key Features
  • Data Pump Migration Compatibility

Migrating an On-Premises Database by Using Unplugging/Plugging and Remote Cloning

  • Use-Case: Migrating an On-Premises Database by Using Remote Cloning
  • Unplugging an On-Premises Non-CDB
  • Unplugging/Plugging a Non-CDB – High Level Overview
  • Plugging In an On-Premises Non-CDB
  • Migrating a 12.1 PDB to a 12.2 CDB in Database Cloud Service
  • Unplugging/Plugging a PDB – High Level Overview
  • Unplug/Plug Method: Overview
  • Remote Cloning Method: Overview

Migrating an On-Premises Database by Using Recovery Manager (RMAN)

  • Use-Case: Migrating a 12c On-Premises Database to Oracle Cloud by Using RMAN Cross-Platform Transportable Tablespace
  • Cross-Platform PDB Transport
  • Cross-Platform Tablespace Transport
  • Migrating by Using RMAN Cross-Platform Transportable Tablespace
  • Transportable Tablespaces & Transportable Database
  • RMAN Migration Methods to Oracle Cloud and Version Compatibility
  • Recovery Manager (RMAN): Overview
  • RMAN Backup and Restore/Recover

What Changes After Migration?

  • Post-Migration Best Practices
  • Tablespace Encryption in Database Cloud Service
  • Backup and Recovery Strategy & Patching Database Cloud Service
  • Creating Security Lists & Security Rules
  • Configuring Connections to the Compute Node
  • Network Access to the Compute Node and Database
  • Cloud Tooling: Benefits
  • Post-Migration Considerations: Overview

Advanced Migration by Using Data Guard

  • Migration Best Practices
  • Near-Zero Down Time Migration by Using Data Guard (Physical Standby)
  • Use-Case: Migrating to Oracle Database Cloud Service by Using Data Guard (Physical Standby)
  • Support Matrix for Hybrid Cloud Data Guard (Physical Standby)

Advanced Migration by Using Golden Gate

  • GoldenGate: Features
  • GoldenGate Setup Between On-Premises and Cloud Database for Migration
  • Use-Case: Migrating to Oracle Database Cloud Service by Using GoldenGate
  • Near-Zero Down Time Migration by Using GoldenGate
  • Oracle GoldenGate Architecture & Supported Topologies

Advanced Migration Method Using Lift & Shift

  • Enterprise Manager Cloud Control – Driven Hybrid Cloud Management
  • PDB Lift & Shift by Using Enterprise Manager 13c
  • Enterprise Manager Strategy for Hybrid Cloud
  • Use-Case: Pluggable Database Lift & Shift by Using Enterprise Manager Cloud Control 13c

Inscreva-se

Dados Pessoais

Dados para faturação

Condições Gerais e Autorizações
  • Se a inscrição for cancelada com antecedência superior a 5 dias úteis da data de início do curso, a Rumos não efectuará qualquer facturação ao cliente.
  • Se a inscrição for cancelada com antecedência igual ou inferior a 5 dias, a Rumos procederá à facturação do valor da inscrição, dando no entanto ao cliente a possibilidade de transferir a sua inscrição para uma nova data. Esta garantia é válida por 6 meses, não se responsabilizando a Rumos se o curso não se repetir nesse período.
  • Pela não comparência do participante no curso sem cancelamento da inscrição a Rumos facturará o valor da inscrição, perdendo o formando o direito à participação no curso.
  • A viabilidade de realização de um curso depende de um número mínimo de inscrições. A Rumos reserva o direito de cancelar um curso por falta de viabilidade deste, notificando esse facto aos inscritos com o mínimo de 2 dias úteis de antecedência.

Os seus dados pessoais são recolhidos em conformidade com o Regulamento Geral de Proteção de Dados (RGPD).
Consente que os seus dados sejam utilizados, nos termos da nossa Politica de Privacidade, para o contacto/envio de:

Ações de informação, de marketing de produtos e serviços, como campanhas e eventos?

Para mais informações, consulte a Política de Privacidade do Grupo Rumos.
pode retirar o seu consentimento a qualquer momento através do botão Cancelar subscrição ou Unsubscribe que estão presentes em cada comunicação enviada, bem como exercer os direitos descritos na politica de privacidade

Para a subscrição da newsletter deverá desativar o bloqueio de pop-ups do seu browser.

Migrating Oracle Database to the Oracle Cloud

  • Datas
    08 Jul a 09 Jul 2019
    Porto
  • Horário
    Laboral
    das 09h30 às 17h30
  • Nº Horas
    12
  • Preço
    900€

Migrating Oracle Database to the Oracle Cloud

Área

Dados

Como chegou até nós

Os seus dados pessoais são recolhidos em conformidade com o Regulamento Geral de Proteção de Dados (RGPD).
Consente que os seus dados sejam utilizados, nos termos da nossa Politica de Privacidade, para o contacto/envio de:

Ações de informação, de marketing de produtos e serviços, como campanhas e eventos?

Para mais informações, consulte a Política de Privacidade do Grupo Rumos.
pode retirar o seu consentimento a qualquer momento através do botão Cancelar subscrição ou Unsubscribe que estão presentes em cada comunicação enviada, bem como exercer os direitos descritos na politica de privacidade

Para a subscrição da newsletter deverá desativar o bloqueio de pop-ups do seu browser.