Curso Oracle Claud Migrating Your Oracle Database to Oracle Cloud Infrastructure

  • Oracle ERP & Negócios

Curso Oracle Claud Migrating Your Oracle Database to Oracle Cloud Infrastructure

16 horas
Visão Geral

Este Curso Oracle Claud Migrating Your Oracle Database to Oracle Cloud Infrastructure, vai te ensinar como migrar seu banco de dados Oracle para o Oracle Cloud Infrastructure. É ideal para DBAs experientes que desejam aprender técnicas e métodos envolvidos na migração do Oracle Database de uma plataforma On-Premises e ambiente Oracle Cloud Infrastructure-Classic (OCI-C) para Oracle Cloud Infrastructure (OCI).

Objetivo

Após realizar este Curso Oracle Claud Migrating Your Oracle Database to Oracle Cloud Infrastructure você será capaz de:

  • Analise e compare seus ambientes de origem e destino
  • Identifique os benefícios de migrar para o Oracle Cloud Infrastructure (OCI)
  • Descreva as etapas envolvidas no processo de migração
  • Prepare os sistemas de origem e destino para a migração
  • Migrar tabelas de banco de dados locais usando SQL Developer
  • Migrar o esquema do banco de dados local para usar o Data Pump
  • Use o método de espaço de tabela transportável para migração
  • Migre o PDB local usando o método Data Pump Export / Import
  • Migrar um PDB do OCI-C usando o método Data Pump Export / Import
  • Migrar um PDB do OCI-C usando o método Unplug / Plug
  • Migrar um CDB de OCI-C usando RMAN
  • Migrar banco de dados Oracle para OCI usando backups do armazenamento de objetos OCI-C
  • Descrever métodos avançados de migração usando Data Guard e GoldenGate
Publico Alvo

EsteCurso Oracle Claud Migrating Your Oracle Database to Oracle Cloud Infrastructure, destina-se a administradores, administradores de nuvem e administradores de banco de dados.

Pre-Requisitos
  • Bons conhecimentos e compreensão das tecnologias Oracle Cloud ou ter concluído o treinamento Oracle Cloud Infrastructure Fundamentals, ter experiência na administração de Oracle Database 11g ou 12c.
Informações Gerais
  • Carga horaria, 16h
  • Se noturno este curso e ministrado de segunda-feira a quinta-feira das 19h às 23h, total de 4 noites,
  • Se aos sábados este curso e ministrado das 09h às 18h, total de 2 sábados,
  • Se in-company, este curso pode ser ministrado de acordo com as agendas de ambas as partes.

 Formato de entrega

  • On-line ao vivo via Microsoft Teams na presença de um instrutor/consultor Oracle, atuando ativamente com consultoria, implementação, suporte, sustentação, treinamentos workshop,

 LAB Oracle:

  • Todo aluno participante tem acesso ao um laboratório Oracle para a pratica dos exercícios proposto pelo curso em sala de aula, auxiliado por um instrutor 
Materiais
Português/Inglês
Conteúdo Programatico

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
  • TENHO INTERESSE

    Cursos Relacionados

    Curso Oracle Database 12c PL/SQL Foundation

    32 horas

    Curso Oracle WebLogic Server 12c: Administration II

    32 horas

    Curso Oracle Database 12c Install and Upgrade Workshop

    32 horas

    Curso Oracle 12c Data Integrator ODI

    24 Horas

    Curso Oracle Database 19C Administration Workshop

    32 horas

    Curso Oracle Database 19c Backup and Recovery

    32 horas

    Curso Oracle Data Integrator 12c Integration and Advanced Development

    24 Horas

    Curso Oracle Service Bus 12c Design & Integrate Services

    32 horas

    Curso Oracle Service Bus 12c Administration

    24 Horas

    Curso Oracle SOA Suite 12c Essential Concepts

    24 Horas