Migrating Oracle Database to Oracle Cloud NOVO

| Formação Oracle University | Oracle Database
2

Métodos de Formação

Método de Formação Preço
Classroom Training (Scheduled) -
    1 - 1

Resumo


Resumo

The “Migrating Your Oracle Database to the Oracle Cloud” 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

Expert Oracle University 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

Finally, 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.

Ideal for experienced DBAs

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.

 

Tópicos


Topicos

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

 

Objetivos


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

 

Pré-Requisitos


Pre 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 Ed 3
  • Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1
  • Oracle Database 12c R2: Managing Multitenant Architecture Ed 2
  • Oracle Database 12c R2: Backup and Recovery Workshop Ed 3
  • Using Oracle Enterprise Manager Cloud Control 13c Ed 2