Move To Oracle Cloud Using Zero Downtime Migration
Oracle DatabaseMove to Oracle Cloud Using Zero DowntimeMigrationRelease 21c (21.2)F43498-03September 2021
Oracle Database Move to Oracle Cloud Using Zero Downtime Migration, Release 21c (21.2)F43498-03Copyright 2019, 2021, Oracle and/or its affiliates.This software and related documentation are provided under a license agreement containing restrictions onuse and disclosure and are protected by intellectual property laws. Except as expressly permitted in yourlicense agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license,transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverseengineering, disassembly, or decompilation of this software, unless required by law for interoperability, isprohibited.The information contained herein is subject to change without notice and is not warranted to be error-free. Ifyou find any errors, please report them to us in writing.If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it onbehalf of the U.S. Government, then the following notice is applicable:U.S. GOVERNMENT END USERS: Oracle programs (including any operating system, integrated software,any programs embedded, installed or activated on delivered hardware, and modifications of such programs)and Oracle computer documentation or other Oracle data delivered to or accessed by U.S. Government endusers are "commercial computer software" or "commercial computer software documentation" pursuant to theapplicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use,reproduction, duplication, release, display, disclosure, modification, preparation of derivative works, and/oradaptation of i) Oracle programs (including any operating system, integrated software, any programsembedded, installed or activated on delivered hardware, and modifications of such programs), ii) Oraclecomputer documentation and/or iii) other Oracle data, is subject to the rights and limitations specified in thelicense contained in the applicable contract. The terms governing the U.S. Government’s use of Oracle cloudservices are defined by the applicable contract for such services. No other rights are granted to the U.S.Government.This software or hardware is developed for general use in a variety of information management applications.It is not developed or intended for use in any inherently dangerous applications, including applications thatmay create a risk of personal injury. If you use this software or hardware in dangerous applications, then youshall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure itssafe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of thissoftware or hardware in dangerous applications.Oracle, Java, and MySQL are registered trademarks of Oracle and/or its affiliates. Other names may betrademarks of their respective owners.Intel and Intel Inside are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks areused under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Epyc,and the AMD logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registeredtrademark of The Open Group.This software or hardware and documentation may provide access to or information about content, products,and services from third parties. Oracle Corporation and its affiliates are not responsible for and expresslydisclaim all warranties of any kind with respect to third-party content, products, and services unless otherwiseset forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not beresponsible for any loss, costs, or damages incurred due to your access to or use of third-party content,products, or services, except as set forth in an applicable agreement between you and Oracle.
ContentsPreface1AudiencexiiiDocumentation AccessibilityxiiiRelated DocumentsxiiiConventionsxiiiIntroduction to Zero Downtime MigrationAbout Zero Downtime Migration1-1Physical Migrations with Zero Downtime Migration1-2Physical Online Migration1-2Physical Offline Migration1-3Supported Physical Migration Paths1-4Data Transfer Media Supported for Physical Migrations1-4Direct Data Transfer Support1-5Supported Database Architectures for Physical Migration1-5Target Placeholder Database Environment1-6Logical Migrations with Zero Downtime Migration1-6Logical Online Migration1-6Logical Offline Migration1-7Supported Logical Migration Targets1-7Initial Load Methods Supported for Logical Migrations1-7What Is Migrated During Initial Load1-8Data Replication1-8Zero Downtime Migration Requirements and Considerations1-9Supported Platforms1-9Supported Database Versions for Migration1-9Zero Downtime Migration Database Server Access1-10Zero Downtime Migration Operational Phases1-10Zero Downtime Migration Security Provisions1-10iii
23Setting Up Zero Downtime Migration SoftwarePrepare a Host for Zero Downtime Migration Software Installation2-1Install Zero Downtime Migration Software2-2Configuring Required ConnectionsConfiguring Connectivity From the Zero Downtime Migration Service Host to the Source and TargetDatabase Servers3-1Configuring SUDO Access3-3Configuring Connectivity Between the Source and Target Database Servers3-4Option 1: SQL*Net Connectivity Using SCAN3-4Option 2: Set up an SSH Tunnel3-5Additional Connectivity Prerequisites for Oracle GoldenGate Hub3-8Zero Downtime Migration Port Requirements3-9Generate SSH Keys Without a Passphrase43-12Preparing for a Physical Database MigrationPreparing the Source and Target Databases4-1Source Database Prerequisites4-1Target Database Prerequisites4-3Setting Up the Transparent Data Encryption Keystore4-5Setting Physical Migration Parameters54-8Provide Passwords Non-Interactively Using a Wallet4-11Preparing for Automatic Application Switchover4-18Configuring Resiliency to Intermittent Network Failures4-19Converting a Non-CDB Database to a CDB During Migration4-19Run a Migration Job Using an Existing RMAN Backup4-21Migrating an On-Premises Database to an On-Premises Exadata Database Machine4-22Preparing for a Logical Database MigrationSource Database Prerequisites for Logical Migration5-1Target Database Prerequisites for Logical Migration5-3Additional Logical Migration Prerequisites5-4Setting Logical Migration Parameters5-5Configuring the Transfer Medium and Specifying Transfer Nodes5-7Default Data Pump Parameter Settings for Zero Downtime Migration5-10Setting Advanced Data Pump Parameters5-13Data Pump Error Handling5-14Automatic Tablespace Creation5-14iv
6Automatic Tablespace Remap5-15Migrating to Oracle Autonomous Database on Exadata Cloud@Customer5-16Customizing a Migration JobAbout Custom Plug-ins with User Actions6-1Parameters Supplied for Custom Plug-ins with User Actions6-1User Action Scripts6-2Registering User Actions6-6Creating an Action Template6-8Associating an Action Template with a Migration Job6-8Querying Action Plug-ins6-8Updating Action Plug-ins6-9Modifying User Action Scripts6-9Chained User Action Output76-10Migrating Your Database with Zero Downtime MigrationEvaluate the Migration Job7-1Using the ZDMCLI MIGRATE DATABASE -eval Option7-2Using the Cloud Premigration Advisor Tool7-5Running CPAT Manually with a Remote Connection7-6Migrate the Database87-7Query Migration Job Status7-11List Migration Job Phases7-11Pause a Migration Job7-11Resume a Migration Job7-13Suspend and Resume a Migration Job7-15Rerun a Migration Job7-16Terminate a Running Migration Job7-16Zero Downtime Migration Centralized Fleet Migration Management7-16Migrating from Amazon Web Services RDS to Oracle Autonomous DatabaseSetting Amazon as the Source Environment8-1Configure Secure Connections8-1Configuring the Data Transfer Method8-2Setting Up Database Link Transfer Method8-2Setting Up S3 Bucket Data Transfer Medium8-2v
910Managing the Zero Downtime Migration ServiceStarting and Stopping the Zero Downtime Migration Service9-1Checking Zero Downtime Migration Service Status9-1Updating Zero Downtime Migration Software9-1Uninstalling Zero Downtime Migration Software9-3Performing a Silent Update or Deinstallation9-4Viewing the Cloud Premigration Advisor Tool Version9-4Updating the Cloud Premigration Advisor Tool9-4Setting the MySQL Port9-5Troubleshooting Zero Downtime MigrationHandling Migration Job Failures10-1ADatabase Server Connectivity Using a Bastion HostBZero Downtime Migration Encryption RequirementsCZero Downtime Migration Process PhasesDZero Downtime Migration Physical Migration Response File ParametersReferenceBACKUP PATHD-1DATA TRANSFER MEDIUMD-1DATAPATCH WITH ONE INSTANCE RUNNINGD-2HOSTD-3MAX DATAPATCH DURATION MINSD-3MIGRATION METHODD-3NONCDBTOPDB CONVERSIOND-4NONCDBTOPDB SWITCHOVERD-4OPC CONTAINERD-4PLATFORM TYPED-4SHUTDOWN SRCD-5SKIP FALLBACKD-5SKIP SRC SERVICE RETENTIOND-5SRC BASTION HOST IPD-6SRC BASTION IDENTITY FILED-6vi
SRC BASTION PORTD-7SRC BASTION USERD-7SRC CONFIG LOCATIOND-8SRC DB LISTENER PORTD-8SRC HOST IPD-9SRC HTTP PROXY PORTD-9SRC HTTP PROXY URLD-9SRC OSS PROXY HOSTD-10SRC OSS PROXY PORTD-10SRC PDB NAMED-10SRC RMAN CHANNELSD-11SRC SSH RETRY TIMEOUTD-11SRC TIMEZONED-11SRC ZDLRA WALLET LOCD-11TGT BASTION HOST IPD-12TGT BASTION IDENTITY FILED-12TGT BASTION PORTD-13TGT BASTION USERD-13TGT CONFIG LOCATIOND-14TGT DATAACFSD-14TGT DATADGD-15TGT DB UNIQUE NAMED-15TGT HOST IPD-16TGT HTTP PROXY PORTD-16TGT HTTP PROXY URLD-17TGT OSS PROXY HOSTD-17TGT OSS PROXY PORTD-17TGT RECOACFSD-18TGT RECODGD-18TGT REDOACFSD-19TGT REDODGD-20TGT RETAIN DB UNIQUE NAMED-20TGT RMAN CHANNELSD-21TGT SKIP DATAPATCHD-21TGT SSH RETRY TIMEOUTD-21TGT SSH TUNNEL PORTD-22TGT ZDLRA WALLET LOCD-22ZDLRA CRED ALIASD-22ZDM BACKUP DIFFERENTIAL SRC MONITORING INTERVALD-23ZDM BACKUP FULL SRC MONITORING INTERVALD-24ZDM BACKUP INCREMENTAL SRC MONITORING INTERVALD-24vii
EZDM BACKUP RETENTION WINDOWD-25ZDM BACKUP TAGD-25ZDM CLONE TGT MONITORING INTERVALD-25ZDM CURL LOCATIOND-26ZDM LOG OSS PAR URLD-26ZDM OPC RETRY COUNTD-26ZDM OPC RETRY WAIT TIMED-27ZDM OSS RECOVER TGT MONITORING INTERVALD-27ZDM OSS RESTORE TGT MONITORING INTERVALD-27ZDM RMAN COMPRESSION ALGORITHMD-28ZDM SHARD IDD-28ZDM SKIP DG CONFIG CLEANUPD-29ZDM SRC DB RESTORE SERVICE NAMED-29ZDM SRC TNS ADMIND-30ZDM USE EXISTING BACKUPD-30ZDM USE EXISTING UNDO SIZED-30Zero Downtime Migration Logical Migration Response File Parameters ReferenceDATA TRANSFER MEDIUME-1DATAPUMPSETTINGS CREATEAUTHTOKENE-1DATAPUMPSETTINGS DATABASELINKDETAILS NAMEE-2DATAPUMPSETTINGS DATABASELINKDETAILS WALLETBUCKET BUCKETNAMEE-2DATAPUMPSETTINGS DATABASELINKDETAILS WALLETBUCKET NAMESPACENAMEE-2DATAPUMPSETTINGS DATABUCKET BUCKETNAMEE-3DATAPUMPSETTINGS DATABUCKET NAMESPACENAMEE-3DATAPUMPSETTINGS DATAPUMPPARAMETERS ESTIMATEBYSTATISTICSE-3DATAPUMPSETTINGS DATAPUMPPARAMETERS TABLEEXISTSACTIONE-4DATAPUMPSETTINGS DATAPUMPPARAMETERS USERMETADATAE-5DATAPUMPSETTINGS DATAPUMPPARAMETERS IMPORTPARALLELISMDEGREEE-5DATAPUMPSETTINGS DATAPUMPPARAMETERS EXPORTPARALLELISMDEGREEE-6DATAPUMPSETTINGS DATAPUMPPARAMETERS EXCLUDETYPELISTE-6DATAPUMPSETTINGS DATAPUMPPARAMETERS SKIPCURRENTE-7DATAPUMPSETTINGS DATAPUMPPARAMETERS NOCLUSTERE-7DATAPUMPSETTINGS DATAPUMPPARAMETERS RETAININDEXE-8DATAPUMPSETTINGS DELETEDUMPSINOSSE-8DATAPUMPSETTINGS EXPORTDIRECTORYOBJECT NAMEE-8DATAPUMPSETTINGS EXPORTDIRECTORYOBJECT PATHE-9DATAPUMPSETTINGS FIXINVALIDOBJECTSE-9DATAPUMPSETTINGS IMPORTDIRECTORYOBJECT NAMEE-10DATAPUMPSETTINGS IMPORTDIRECTORYOBJECT PATHE-10viii
DATAPUMPSETTINGS JOBMODEE-11DATAPUMPSETTINGS METADATAFILTERS-LIST ELEMENT NUMBERE-11DATAPUMPSETTINGS METADATAREMAPS-LIST ELEMENT NUMBERE-12DATAPUMPSETTINGS METADATATRANSFORMS-LIST ELEMENT NUMBERE-13DATAPUMPSETTINGS MONITORINTERVALMINUTESE-13DATAPUMPSETTINGS OMITENCRYPTIONCLAUSEE-13DATAPUMPSETTINGS SECUREFILELOBE-14DATAPUMPSETTINGS SKIPDEFAULTTRANSFORME-14DUMPTRANSFERDETAILS PARALLELCOUNTE-14DUMPTRANSFERDETAILS RETRYCOUNTE-15DUMPTRANSFERDETAILS RSYNCAVAILABLEE-15DUMPTRANSFERDETAILS S3BUCKET ACCESSKEYE-16DUMPTRANSFERDETAILS S3BUCKET NAMEE-16DUMPTRANSFERDETAILS S3BUCKET REGIONE-16DUMPTRANSFERDETAILS SOURCE OCIHOMEE-17DUMPTRANSFERDETAILS SOURCE PARTSIZEMBE-17DUMPTRANSFERDETAILS SOURCE TRANSFERNODE DUMPDIRPATHE-18DUMPTRANSFERDETAILS SOURCE TRANSFERNODE HOSTE-18DUMPTRANSFERDETAILS SOURCE TRANSFERNODE SUDOPATHE-19DUMPTRANSFERDETAILS SOURCE TRANSFERNODE USERE-19DUMPTRANSFERDETAILS SOURCE TRANSFERNODE USERKEYE-20DUMPTRANSFERDETAILS SOURCE USEOCICLIE-20DUMPTRANSFERDETAILS TARGET OCIHOMEE-21DUMPTRANSFERDETAILS TARGET PARTSIZEMBE-21DUMPTRANSFERDETAILS TARGET TRANSFERNODE DUMPDIRPATHE-22DUMPTRANSFERDETAILS TARGET TRANSFERNODE HOSTE-22DUMPTRANSFERDETAILS TARGET TRANSFERNODE SUDOPATHE-23DUMPTRANSFERDETAILS TARGET TRANSFERNODE USERE-23DUMPTRANSFERDETAILS TARGET TRANSFERNODE USERKEYE-24DUMPTRANSFERDETAILS TARGET USEOCICLIE-24DUMPTRANSFERDETAILS TRANSFERTARGET DUMPDIRPATHE-25DUMPTRANSFERDETAILS TRANSFERTARGET HOSTE-25DUMPTRANSFERDETAILS TRANSFERTARGET SUDOPATHE-26DUMPTRANSFERDETAILS TRANSFERTARGET USERE-26DUMPTRANSFERDETAILS TRANSFERTARGET USERKEYE-27EXCLUDEOBJECTS-LIST ELEMENT NUMBERE-27GOLDENGATEHUB ADMINUSERNAMEE-28GOLDENGATEHUB COMPUTEIDE-28GOLDENGATEHUB SOURCEDEPLOYMENTNAMEE-28GOLDENGATEHUB TARGETDEPLOYMENTNAMEE-29GOLDENGATEHUB URLE-29ix
GOLDENGATESETTINGS ACCEPTABLELAGE-29GOLDENGATESETTINGS EXTRACT NAMEE-29GOLDENGATESETTINGS EXTRACT PERFORMANCEPROFILEE-30GOLDENGATESETTINGS EXTRACT WARNLONGTRANS CHECKINTERVALE-30GOLDENGATESETTINGS EXTRACT WARNLONGTRANS DURATIONE-31GOLDENGATESETTINGS REPLICAT MAPPARALLELISME-31GOLDENGATESETTINGS REPLICAT MAXAPPLYPARALLELISME-32GOLDENGATESETTINGS REPLICAT MINAPPLYPARALLELISME-32GOLDENGATESETTINGS REPLICAT NAMEE-32INCLUDEOBJECTS-LIST ELEMENT NUMBERE-33MIGRATION TYPEE-33OCIAUTHENTICATIONDETAILS REGIONIDE-33OCIAUTHENTICATIONDETAILS USERPRINCIPAL FINGERPRINTE-34OCIAUTHENTICATIONDETAILS USERPRINCIPAL PRIVATEKEYFILEE-34OCIAUTHENTICATIONDETAILS USERPRINCIPAL TENANTIDE-34OCIAUTHENTICATIONDETAILS USERPRINCIPAL USERIDE-35OCIPROXY HOSTNAMEE-35OCIPROXY PORTE-35SOURCECONTAINERDATABASE ADMINUSERNAMEE-36SOURCECONTAINERDATABASE CONNECTIONDETAILS BASTIONDETAILS IDENTITYFILEE-36SOURCECONTAINERDATABASE CONNECTIONDETAILS BASTIONDETAILS IPE-36SOURCECONTAINERDATABASE CONNECTIONDETAILS BASTIONDETAILS PORTE-37SOURCECONTAINERDATABASE CONNECTIONDETAILS BASTIONDETAILS REMOTEHOSTIPE-37SOURCECONTAINERDATABASE CONNECTIONDETAILS BASTIONDETAILS USERNAMEE-37SOURCECONTAINERDATABASE CONNECTIONDETAILS HOSTE-38SOURCECONTAINERDATABASE CONNECTIONDETAILS PORTE-38SOURCECONTAINERDATABASE CONNECTIONDETAILS PROXYDETAILS HOSTNAMEE-38SOURCECONTAINERDATABASE CONNECTIONDETAILS PROXYDETAILS PORTE-39SOURCECONTAINERDATABASE CONNECTIONDETAILS SERVICENAMEE-39SOURCECONTAINERDATABASE CONNECTIONDETAILS TLSDETAILS CREDENTIALSLOCATIONE-39SOURCECONTAINERDATABASE CONNECTIONDETAILS TLSDETAILS DISTINGUISHEDNAMEE-40SOURCECONTAINERDATABASE GGADMINUSERNAMEE-40SOURCEDATABASE ADMINUSERNAMEE-40SOURCEDATABASE CONNECTIONDETAILS BASTIONDETAILS IDENTITYFILEE-41SOURCEDATABASE CONNECTIONDETAILS BASTIONDETAILS IPE-41SOURCEDATABASE CONNECTIONDETAILS BASTIONDETAILS PORTE-41SOURCEDATABASE CONNECTIONDETAILS BASTIONDETAILS REMOTEHOSTIPE-42SOURCEDATABASE CONNECTIONDETAILS BASTIONDETAILS USERNAMEE-42SOURCEDATABASE CONNECTIONDETAILS HOSTE-42SOURCEDATABASE CONNECTIONDETAILS PORTE-43SOURCEDATABASE CONNECTIONDETAILS PROXYDETAILS HOSTNAMEE-43x
FSOURCEDATABASE CONNECTIONDETAILS PROXYDETAILS PORTE-43SOURCEDATABASE CONNECTIONDETAILS SERVICENAMEE-44SOURCEDATABASE CONNECTIONDETAILS TLSDETAILS CREDENTIALSLOCATIONE-44SOURCEDATABASE CONNECTIONDETAILS TLSDETAILS DISTINGUISHEDNAMEE-44SOURCEDATABASE ENVIRONMENT DBTYPEE-45SOURCEDATABASE ENVIRONMENT NAMEE-45SOURCEDATABASE GGADMINUSERNAMEE-45TABLESPACEDETAILS AUTOCREATEE-45TABLESPACEDETAILS AUTOREMAPE-46TABLESPACEDETAILS EXCLUDEE-46TABLESPACEDETAILS EXTENTSIZEMBE-47TABLESPACEDETAILS REMAPTARGETE-47TABLESPACEDETAILS USEBIGFILEE-47TARGETDATABASE ADMINUSERNAMEE-48TARGETDATABASE CONNECTIONDETAILS BASTIONDETAILS IDENTITYFILEE-48TARGETDATABASE CONNECTIONDETAILS BASTIONDETAILS IPE-48TARGETDATABASE CONNECTIONDETAILS BASTIONDETAILS PORTE-49TARGETDATABASE CONNECTIONDETAILS BASTIONDETAILS REMOTEHOSTIPE-49TARGETDATABASE CONNECTIONDETAILS BASTIONDETAILS USERNAMEE-49TARGETDATABASE CONNECTIONDETAILS HOSTE-50TARGETDATABASE CONNECTIONDETAILS PORTE-50TARGETDATABASE CONNECTIONDETAILS PROXYDETAILS HOSTNAMEE-50TARGETDATABASE CONNECTIONDETAILS PROXYDETAILS PORTE-51TARGETDATABASE CONNECTIONDETAILS SERVICENAMEE-51TARGETDATABASE CONNECTIONDETAILS TLSDETAILS CREDENTIALSLOCATIONE-51TARGETDATABASE CONNECTIONDETAILS TLSDETAILS DISTINGUISHEDNAMEE-52TARGETDATABASE GGADMINUSERNAMEE-52TARGETDATABASE OCIDE-52WALLET AMAZONS3SECRETE-52WALLET DATAPUMPENCRYPTIONE-53WALLET OGGADMINE-53WALLET SOURCECONTAINERE-53WALLET SOURCECGGADMINE-54WALLET SOURCEGGADMINE-54WALLET TARGETADMINE-54Zero Downtime Migration ZDMCLI Command ReferenceZDMCLI OptionsF-1abort jobF-1add imagetypeF-2xi
add useractionF-2migrate databaseF-3modify useractionF-9query jobF-9query useractionF-11resume jobF-12suspend jobF-13Indexxii
PrefaceThis book provides information about Zero Downtime Migration capabilities, how to set up theZero Downtime Migration service, how to prepare your source and target databases formigration, and how to use the Zero Downtime Migration tool to quickly and smoothly moveyour Oracle databases to the Oracle Cloud or any Oracle Exadata Database Machineenvironment without incurring any significant downtime.AudienceThis book is intended for anyone who wants to learn about what Zero Downtime Migrationcan do, and for anyone tasked with migrating Oracle databases.Documentation AccessibilityFor information about Oracle's commitment to accessibility, visit the Oracle AccessibilityProgram website at http://www.oracle.com/pls/topic/lookup?ctx acc&id docacc.Access to Oracle SupportOracle customers that have purchased support have access to electronic support through MyOracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx acc&id infoor visit http://www.oracle.com/pls/topic/lookup?ctx acc&id trs if you are hearing impaired.Related DocumentsSee Zero Downtime Migration on the Oracle Help Center for all published Zero DowntimeMigration documentation.See Zero Downtime Migration Release Notes for the latest information about what's new inthis release, known issues, and troubleshooting solutions.See the README file included with the downloaded Zero Downtime Migration software foradditional information about installation.See Zero Downtime Migration Licensing Information User Manual for information about thirdparty licenses included in the Zero Downtime Migration software kit.ConventionsThe following text conventions are used in this document:xiii
PrefaceConventionMeaningboldfaceBoldface type indicates graphical user interface elements associatedwith an action, or terms defined in text or the glossary.italicItalic type indicates book titles, emphasis, or placeholder variables forwhich you supply particular values.monospaceMonospace type indicates commands within a paragraph, URLs, codein examples, text that appears on the screen, or text that you enter.xiv
1Introduction to Zero Downtime MigrationLearn about how Zero Downtime Migration works, and its requirements and supportedconfigurations.About Zero Downtime MigrationWith Zero Downtime Migration, you can migrate Oracle databases from on premises, OracleCloud Infrastructure Classic, from one Oracle Cloud Infrastructure region to another, or fromAmazon Web Services RDS. You can move your databases to co-managed or AutonomousDatabase services in the cloud, or any Exadata Database Machine in the cloud or onpremises.Zero Downtime Migration provides a robust, flexible, and resumable migration process that isalso easy to roll back. Zero Downtime Migration integrates Oracle Maximum AvailabilityArchitecture (MAA) and supports Oracle Database 11g Release 2 (11.2.0.4) and laterdatabase releases.You can perform and manage a database migration of an individual database or performdatabase migrations at a fleet level. Leveraging technologies such as Oracle Data Guard,Oracle Recovery Manager (RMAN), Oracle GoldenGate, and Oracle Data Pump, you canmigrate databases online or offline.The Zero Downtime Migration software is a service with a command line interface that youinstall and run on a host that you provision. The server where the Zero Downtime Migrationsoftware is installed is called the Zero Downtime Migration service host. You can run one ormore database migration jobs from the Zero Downtime Migration service host.Zero Downtime Migration Capabilities Audit capability - All custom user actions are audited including actions performed by themigration job. Work flow customization - You can customize the migration work flow (marked byoperational phases) with your own scripts, which can be run before or after any phase inthe work flow. Job subsystem - You can perform and manage database migrations at a fleet scale. Job scheduler - You can schedule your migration job to run at a future point in time. Pause and resume functionality - You can pause and resume your migration job ifneeded, which is useful to conform to a maintenance window, for example. Job termination - You can terminate a running migration job, rather than waiting for it tocomplete. Job rerun ability - Your migration job can be re-run (resumed) from a point of failure. Job pre-check - You can run pre-checks for migration tasks to prevent errors duringdatabase migration.1-1
Chapter 1Physical Migrations with Zero Downtime Migration Compliance - Zero Downtime Migration is compliant with Oracle MaximumAvailability Architecture best practices and supports Oracle Database 11g Release2 (11.2.0.4.0) and later.Migration MethodsZero Downtime Migration supports both online and offline migration, and can performboth physical and logical migrations. Consider the following advantages of eachmigration method to choose which one is right for your needs. Online migration methods incur zero or minimal downtime (typically less than 15minutes) and can leverage either physical or logical migration methods. Offline migration methods will incur downtime on the source database as part ofthe migration process. It can leverage either physical or logical migration methods.Note that the only available method for migrating Oracle Database StandardEdition is the offline migration method. Physical migration methods:–Use Oracle Data Guard and RMAN to perform migrations–Allow you to convert a non-multitenant (non-CDB) source database to amultitenant (CDB) target databaseLogical migration methods:–Use Oracle Data Pump and, for online migrations, Oracle GoldenGateMicroservices–Allow you to perform cross-platform migration (in offline mode) where thesource Oracle Database is running on Oracle Solaris or IBM AIX operatingsystem, and the target is an Oracle Autonomous Database or Co-managedOracle Database on Oracle Linux.–Include integration with the Cloud Premigration Advisor Tool (CPAT), which a)warns you about any features used by your database that aren't supported inthe target cloud environment, and b) makes suggestions for remedial changesand/or parameters to use for the Data Pump export and import operationsThe migration methods are described in the following topics. Physical Migrations with Zero Downtime Migration Logical Migrations with Zero Downtime MigrationPhysical Migrations with Zero Downtime MigrationPhysical migrations with Zero Downtime Migration use the Recovery Manager (RMAN)and Oracle Data Guard to perform the data transfer from the source to the targetdatabase, and can handle the role switch of the target database to primary databasefor application connections.Physical Online MigrationZero Downtime Migration harnesses Oracle Data Guard to perform an online physicalmigration.A Zero Downtime Migration online physical migration does the following:1-2
Chapter 1Physical Migrations with Zero Downtime Migration Backs up the source database to the specified data transfer medium Instantiates a standby database from this backup to the target environment Configures Data Guard with Maximum Performance protection mode and asynchronous(ASYNC) redo transport mode Synchronizes the source and target databases Switches over to the target database as the new primary database with minimumdowntimeUpon switchover, the target database becomes the primary database, and the sourcedatabase becomes the standby.If there is SQL*Net connectivity between the new primary and the new standby after theswitchover, the configuration continues to synchronize data (ship redo) from the new primaryto the new standby source database. This configuration makes it possible to perform arollback with minimal downtime, if you need to switch the primary back to the original sourcedatabase.However, if there is no SQL*Net connectivity between the new primary and the new standbyafter the switchover, there is no data synchronization (ship redo) from the new primary to thenew standby on the source database. With this configuration you cannot fall back to theoriginal source database.Note that any fallback operation must be done manually; Zero Downtime Migration does nothandle reverse role switches to fall back to the original source database as the primarydatabase.Note that Transparent Data Encryption (TDE) is enabled on Oracle databases in the OracleCloud by default. Zero Downtime Migration handles the encryption of your target database,even if TDE is not enabled on the source Oracle database. However, once the switchoverphase of the migration has taken place, the redo logs that the new primary database in theOracle Cloud sends to the new standby database (the source) are encrypted. Therefore, ifyou decide to switch back and role swap again, making the source database the primaryagain and the database in the Oracle Cloud the standby, the source database will not be ableto read the newly encrypted changed blocks applied by the redo logs unless TDE is enabledon the source database.Physical Offline MigrationZero Downtime Migration can perform a backup and restore operation to achieve an offlinephysical migration.A Zero Downtime Migration offline physical migration does the following: Backs up the source database to the specified data transfer medium Instantiates a new database from this backup to the target environmentThe offline migration method is similar to cloning a database. The target database has norelationship to the source, so there is no data synchronization or fallback capability. NoSQL*Net connectivity is needed between the source and target database servers.Note that for physical migrations, the offline methodology is the only one that supports OracleDatabase Standard Edition1-3
Chapter 1Physical Migrations with Zero Downtime MigrationSupported Physical Migration PathsZero Downtime Migration supports the following physical migration paths. On-premises Oracle Database to Oracle Cloud Infrastructure (either virtualmachine or bare metal) On-premises Oracle Database to Exadata Cloud Service On-premises Oracle Database to Oracle Exadata Cloud at Customer On-premises Oracle Database to On-Premises Exadata Database Machine Oracle Cloud Infrastructure Classic Database to Oracle Cloud Infrastructure (eithervirtual machine or bare metal) Oracle Cloud Infrastructure Database to a database in another Oracle CloudInfrastructure regionFor example, you can move a database from the phoenix commercial OCI regionto the frankfurt or ashburn region.Data Transfer Media Supported for Physical MigrationsThe Zero Downtime Migration physical migration process involves creating a backupof the source database and restoring it to the target database. Zero DowntimeMigration supports the following backup media, depending on your target environment.Oracle Cloud Infrastructure Object StorageOCI Object Storage is supported as a backup medium when migrating a database toOracle Cloud Infrastructure, Exadata Cloud Service, or any on-premises ExadataCloud at Customer target.If you back up the database to Object Storage, then the Zero Downtime Migrationservice initiates the source database backup and restores it to the target environment,so Object Storage must be accessible from both the source and target environments.The Zero Downtime Migration service host uses an SSH connection to the source andtarget database servers to install and configure the backup module softwarenecessary to back up to and restore from Object Storage. The backup from the sourcedatabase to Object Storage takes place over an RMAN channel.Zero Data Loss Recovery ApplianceZero Data Loss Recovery Appliance is supported as a backup medium for migrating adatabase to an Exadata Cloud at Customer target or an Oracle Exadata DatabaseMachine.If Zero Data Loss Recovery Appliance is chosen as backup medium, then you mustensure that the Zero Data Loss Recovery Appliance has a valid backup of the sourcedatabase, because Zero Downtime Migration does not initiate a backup to Zero DataLoss Recovery Appliance as part of the work flow.You must also ensure that all instances of the database are up before initiating abackup to Zero Data Loss Recovery Appliance. The duplicate database operationmight fail if the backup is initiated when an instance is down.1-4
Chapter 1Physical Migrations with Zero Downtime MigrationThe Zero Downtime Migration service accesses the backup in Zero Data Loss RecoveryAppliance and restores it to Exadata Cloud at Customer. The Zero Data Loss RecoveryAppliance access credentials and wallet location are mandatory input parameters, so thatZero Downtime Migration can handle the Zero Data Loss Recovery Appliance wallet setup atthe target database.Any transfer of redo stream between the source and the target database server, in eitherdirection, takes place over a
Resume a Migration Job 7-13 Suspend and Resume a Migration Job 7-15 Rerun a Migration Job 7-16 Terminate a Running Migration Job 7-16 Zero Downtime Migration Centralized Fleet Migration Management 7-16. 8 . Migrating from Amazon Web Services RDS to Oracle Autonomous Database. Setting Amazon
Oracle Cloud Infrastructure Data Integration 5D992.c NLR Oracle Cloud Watch Dog EAR99 NLR Oracle Compute Cloud Service Bare Metal VMI EAR99 NLR Oracle Container Cloud Service 5D992.c NLR Oracle Container Registry Cloud Service 5D992.c NLR Oracle DataFox Cloud Service 5D992.c NLR Oracle
Visit cloud.oracle.com for information on our free 30-day trial, and visit our Oracle Data Visualization Cloud Service web page. Connect. Oracle Events Oracle Blog Get Social. Twitter: Oracle Cloud Zone Facebook: Oracle Cloud Computing LinkedIn: Oracle Cloud Solutions YouTube: Oracle Cloud Computing Qualogy Leverages Data Storytelling
Oracle e-Commerce Gateway, Oracle Business Intelligence System, Oracle Financial Analyzer, Oracle Reports, Oracle Strategic Enterprise Management, Oracle Financials, Oracle Internet Procurement, Oracle Supply Chain, Oracle Call Center, Oracle e-Commerce, Oracle Integration Products & Technologies, Oracle Marketing, Oracle Service,
Oracle is a registered trademark and Designer/2000, Developer/2000, Oracle7, Oracle8, Oracle Application Object Library, Oracle Applications, Oracle Alert, Oracle Financials, Oracle Workflow, SQL*Forms, SQL*Plus, SQL*Report, Oracle Data Browser, Oracle Forms, Oracle General Ledger, Oracle Human Resources, Oracle Manufacturing, Oracle Reports,
E-Business Suite and HCM Cloud E-Business Suite and ERP/SCM Cloud E-Business Suite and CX Cloud 10 Oracle E-Business Suite and Practical Coexistence Scenarios Extend with SaaS –Hybrid is the New Normal 1.EBS ERP to Oracle HCM Cloud 2.EBS Payroll with Oracle HCM Cloud 3.EBS HCM to Oracle Taleo Cloud 4.EBS HCM to Oracle Talent Management Cloud .
7 Messaging Server Oracle Oracle Communications suite Oracle 8 Mail Server Oracle Oracle Communications suite Oracle 9 IDAM Oracle Oracle Access Management Suite Plus / Oracle Identity Manager Connectors Pack / Oracle Identity Governance Suite Oracle 10 Business Intelligence
Advanced Replication Option, Database Server, Enabling the Information Age, Oracle Call Interface, Oracle EDI Gateway, Oracle Enterprise Manager, Oracle Expert, Oracle Expert Option, Oracle Forms, Oracle Parallel Server [or, Oracle7 Parallel Server], Oracle Procedural Gateway, Oracle Replication Services, Oracle Reports, Oracle
Oracle Compute hosting Oracle Data Integrator, the Oracle BI Applications Configuration Manager and Oracle Database Cloud Service. See detailed deployment documentation published on Oracle Support. (Figure 2) Hybrid solutions deploy the BI semantic model, analyses and dashboards on Oracle Analytics Cloud with Oracle Data Integrator and Oracle .
