|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/oracle-database-migration-methods-on-prem-to-oracle-cloud/
课程评论：没有评论
课程名称：Oracle数据库迁移方法：从本地到OCI 课程概述：随着云计算的兴起，数据库管理员（DBA）和解决方案架构师面临的最大挑战之一是如何将本地的Oracle数据库迁移到云端。本课程将教授不同的策略和方法，以便将数据库从本地迁移到Oracle Cloud Infrastructure（OCI），同时也包括从AWS RDS迁移到OCI的方法。这些策略同样适用于将Oracle数据库迁移到AWS（EC2）、Azure、OCI和GCP等IaaS云服务。 课程内容将从选择迁移策略的因素讨论开始，重点介绍两个驱动迁移策略的主要概念：字节序（Endianness）和数据库字符集。鉴于网络带宽是数据库迁移中最大瓶颈，课程还将介绍Oracle数据传输设备的概念。 接下来的模块将建立我们的本地环境，使用Vagrant和VirtualBox。若您对Vagrant不熟悉，将进行详细教程，包括如何安装、配置Vagrant，并使用Vagrant来配置虚拟机（VM），展示整个过程的自动化。完成后，将安装Oracle 18c XE并创建带有示例架构的数据库，作为我们的本地Oracle数据库环境。 一旦本地环境设置完成，我们将进一步探讨Oracle Cloud中的两个重要概念：分区（Compartments）和虚拟云网络（VCN）。接下来，我们将在OCI中配置基于VM的数据库即服务（DBaaS）实例。同时，我会教授如何在本地机器与OCI数据库系统之间设置SSH连接。 从下一个模块开始，我们将深入探讨多种可用的Oracle数据库迁移方法，所有讨论将分为三个部分：方法概念、工作流程及完整迁移演示。演示中使用的命令将提供在资源部分。将教授的方法包括： • 数据泵常规导出/导入 • 数据泵可传输表空间 • 数据泵全可传输 • RMAN转换可传输表空间与数据泵 • RMAN跨平台可传输PDB • RMAN跨平台可传输PDB（不一致备份） • RMAN使用Oracle云备份模块恢复 • 拔插法（CDB） • SQL开发者迁移所选对象 与我所有课程相同，在最后一个模块中，我们将进行挑战，目标是将运行在AWS RDS上的Oracle数据库迁移到Oracle Cloud，并使用AWS数据迁移服务（DMS）来实现这一目标。 希望在课程结束时，您能感到更加自信，掌握迁移本地Oracle数据库所需的所有工具与技术。祝您学习愉快！ 课程讲师：Kshitij Joy (OCM)，数据库炼金术士学院
With the advent of Cloud Computing the biggest challenge that is being faced by the DBA's & Solution Architects is how to migrate the On-Prem Oracle Databases onto the Cloud. This course teaches you all the different Strategies and methods that you can use to migrate from On-Prem to Oracle Cloud (OCI) along with a method to migrate from AWS RDS to OCI as well.Please note the same strategies can be used if you are looking to migrate your Oracle Database to IaaS based Cloud Services in AWS(EC2) / Azure / OCI & GCP as well.We shall start our migration journey with some discussion around: the factors that help you to choose your migration strategy, from here we will discuss two main concepts which drive a Migration Strategy and they are Endianness & Database Character Sets. As the biggest bottleneck in any Database Migration exercise is Nework Bandwidth hence we will discuss the concept of Oracle Data Transfer Appliance.In the next module we shall build our On-Prem Environment using Vagrant & VirtualBox , there will be a deep dive session into Vagrant if you are new to this technology as we will be installing, configuring Vagrant and then provision our Virtual Machine (VM) using Vagrant and show how this whole process is automated. This would be followed by the installation of Oracle 18c XE , creation of database along with Sample Schemas and this will act as our on-prem Oracle Database environment.Once our On-Prem environment is all setup we will proceed our journey to oracle Cloud and will introduce you to 2 important concepts in OCI which are Compartments and VCN's (Virtual Cloud Network) and then we shall provision a VM based DbaaS Instance in OCI. I shall teach you the method to setup SSH connectivity between On-prem machine and OCI DB System.From next module onwards we will be delving deeper into different types of Oracle Database Migration methods which are available to us. The whole discussion will be divided into three parts: Discussion on the concept , Workflow of the Method , An End to End Demo on the migration method. Please note that the commands used in the demos are all given under the Resources section as well. The Methods that will be taught are:•Data Pump Conventional Export/Import •Data Pump Transportable Tablespace•Data Pump Full Transportable•RMAN CONVERT Transportable Tablespace with Data Pump •RMAN Cross-Platform Transportable PDB•RMAN Cross-Platform Transportable PDB (Inconsistent Backups)•RMAN Restore using Oracle Cloud Backup Module •Unplugging/Plugging (CDB)•SQL Developer to Migrate Selected ObjectsAs with my all courses in the last Module we shall try and challenge ourselves and the challenge will be to Migrate the Oracle Database running in AWS RDS to Oracle Cloud and to accomplish this we shall be making use of AWS DMS (Data Migration Service).I hope at the end of the course you will feel more confident as you would be equipped with all the tools & techniques that you need to Migrated your on-prem oracle databases.Happy Learning!!!RegardsKshitij Joy (OCM)DB Alchemist Academy
