Formation Migrating Your Oracle Database to Oracle Cloud Infrastructure

QUESTIONS ?

Migrating Your Oracle Database to Oracle Cloud Infrastructure

Prix: 1 422 €Durée: 2 joursCode de Réference: D105571 Catalogue
Oracle Cloud Infrastructure
Print Friendly, PDF & Email



This course teaches you how to migrate your Oracle Database to Oracle Cloud Infrastructure. It’s ideal for experienced DBAs who want to learn techniques and methods involved in migrating Oracle Database from an On-Premises platform and Oracle Cloud Infrastructure-Classic (OCI-C) environment to Oracle Cloud Infrastructure (OCI).

Objectifs de la formation

A l’issue de cette formation Oracle Cloud Infrastructure, vous serez capable de :

  • Analyze and compare your source and target environments
  • Identify the benefits of migrating to Oracle Cloud Infrastructure (OCI)
  • Describe the steps involved in the migration process
  • Prepare source and target systems for migration
  • Migrate on-premises database tables using SQL Developer
  • Migrate on-premises database schema to using Data Pump
  • Use transportable tablespace method for migration
  • Migrate on-premises PDB using Data Pump Export/Import method
  • Migrate a PDB from OCI-C using Data Pump Export/Import method
  • Migrate a PDB from OCI-C using the Unplug/Plug method
  • Migrate a CDB from OCI-C using RMAN
  • Migrate Oracle Database to OCI using backups from OCI-C Object Store
  • Describe advanced migration methods using Data Guard and GoldenGate

Public

Cette formation Migrating Your Oracle Database to Oracle Cloud Infrastructure s’adresse aux administrateurs, administrateurs cloud et administrateurs de bases de données.

Prérequis

Compréhension de l’anglais et du vocabulaire anglais spécifique IT. Bonnes connaissances et compréhension des technologies Cloud Oracle ou avoir suivi la formation Oracle Cloud Infrastructure Fundamentals, avoir de l'expérience dans l'administration d'Oracle Database 11g ou 12c.

Vous souhaitez faire vérifier vos prérequis ? Contactez-nous pour l’organisation d’un entretien téléphonique avec un de nos consultants formateurs.

Programme

Migrating Oracle Database to Oracle Cloud Infrastructure: Why, What, and How

  • OCI: Specifically Architected for Oracle Databases
  • Managing Oracle Database: On-Premises Versus Oracle Cloud Infrastructure
  • Considerations for Choosing a Migration Method
  • Subscribing to an Oracle Cloud Service
  • Universal Credits & Bring Your Own License
  • Getting Started with Oracle Cloud Infrastructure

  • Regions, Availability Domains, and Backbone Network
  • Comprehensive Virtual Network with Off-box Virtualization
  • Analyzing and Choosing Your Migration Strategy

  • Migration Life Cycle of a Target Cloud Database
  • Migration Methods & Prerequisites
  • Migration Strategy: Selection Criteria
  • Choosing a Method
  • Choosing a Hardware Configuration: Compute Shapes
  • Moving Large Data Sets to Oracle Cloud
  • Preparing Source and Target Systems for Migration

  • Preparing Source On-Premises Oracle Database for Migration
  • Preparing Source DBCS Service Instance for Migration
  • Creating the Target System: OCI Virtual Machine DB System
  • Migrating Using SQL Developer

  • Migrating Tables by Using SQL Developer
  • Migrating Selected Tables by Using SQL Developer INSERT Statements
  • Migrating Selected Tables by Using SQL Developer and SQL*Loader
  • Migrating an Oracle Database to OCI by Using Data Pump

  • Migrating an On-Premises 12c CDB Schema to OCI 18c CDB: Conventional Mode
  • Migrating an On-Premises 12c PDB to 18c PDB on OCI: Conventional Mode
  • Migrating an On-Premises 12c Database Tablespace to OCI 18c CDB: Transportable Tablespace
  • Data Pump Full Transportable Mode
  • Migrating Oracle Database to OCI Using Unplug/Plug and Remote Cloning Method

  • Unplugging & Plugging In an On-Premises Non-CDB
  • Unplugging/Plugging a PDB: High-Level Overview
  • Unplugging & Plugging In an On-Premises PDB
  • Migrating a 12.1 PDB to a 12.2 CDB in Database Cloud Service
  • Remote Cloning Method: Migration Compatibility
  • Remote Cloning an On-Premises Non-CDB & PDB
  • Migrating an Oracle Database to OCI by Using Recovery Manager (RMAN)

  • RMAN Cross-Platform Transportable Tablespace Backup Sets
  • RMAN Migration Methods to Oracle Cloud and Version Compatibility
  • Tablespace Transport by Using RMAN CONVERT
  • Cross-Platform PDB Transport
  • Use-Case: Migrating a 12c On-Premises Database to Oracle Cloud by Using RMAN Cross-Platform Transportable Tablespace
  • Cross-Platform Transportable Tablespace to a Different Endian Platform with RMAN Backup Sets
  • Migrating by Using RMAN Cross-Platform Transportable Tablespace
  • Migrating Oracle Database to OCI by Using Oracle Database Cloud Backup Module

  • Oracle Backup Module Installation Prerequisites
  • Installing the Oracle Database Cloud Backup Module
  • Creating a Tiering Container When Installing the Oracle Database Cloud Backup Module
  • Restoring Oracle Database from Object Storage Classic in OCI
  • Use Case: Migrating Oracle Database from OCI-C to OCI Bare Metal Using Data Guard

    Use Case: Migrating DBCS Single-Instance Database from OCI-C to OCI VM Using the IBKUP Utility

    Use Case: Near Zero Downtime Migration by Using Oracle GoldenGate

    What Changes After Migration?

  • Network Access to the Compute Node and Database
  • Creating Security Lists & Configuring Connections to the Compute Node
  • Security Lists & Security Rule
  • Tablespace Encryption in Database Cloud Service
  • Backup and Recovery Strategy
  • Patching Database Cloud Service
  • Post-Migration Best Practices
  • Méthodes pédagogiques

    Alternance d'apports théoriques et d'exercices avec un vaste choix d'exercices pratiques et de scénarios d'atelier permettent de mettre en œuvre les connaissances acquises.

    La dernière version du support, en anglais, vous est transmise par voie dématérialisée. Vous aurez à votre disposition un eKit contenant tous les matériels de cours de votre formation. Celui-ci peut être téléchargé jusqu’à 180 jours après votre formation.

    Afin d’évaluer l’acquisition de vos connaissances et compétences, il vous sera remis une grille d’auto-évaluation, qui sera à compléter à la fin de chaque module pratique, ainsi qu’à la fin de la formation.

    Print Friendly, PDF & Email
    retour vers le catalogue des formations