My Oracle Support Banner

How To Migrate Multitenant Standalone Database Using Fleet Maintenance (Doc ID 2725136.1)

Last updated on DECEMBER 02, 2020

Applies to:

Enterprise Manager for Oracle Database - Version 12.1.0.8.0 to 13.4.1.0.0 [Release 12.1 to 13.2]
Information in this document applies to any platform.

Purpose

Fleet Maintenance is a centralized mechanism for Patching/Upgrading of Oracle homes and maintain consistency. Fleet Maintenance allows Enterprise Manager (EM) Cloud Control administrators to patch database, Oracle Restart or Grid Infrastructure with minimal downtime. Fleet maintenance uses the Out of Place Patching option. Also this can be done only via emcli verb and there is no GUI option available.

Scope

 Steps outlined in this document are applicable for migrating multitenant  standalone DB. Scenarios applicable are

  1. Migration of existing PDB's to the newly created CDB. 
  2. Migration of PDB's from an existing CDB to the same patch level destination CDB.
Note:
  • Please follow the below document if you want to patch/Upgrade multitenant database using fleet maintenance. How To Patch Or Upgrade Standalone Database Using Fleet Maintenance <Note 2434260.1>
  • Above document helps in migrating entire CDB along with PDB's to new Oracle Home after Patching/Upgrade. 
  • This document helps in migrating some or all of PDB's to another CDB of the same patch level. 

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
 A. Migration of one or more existing PDB's to the newly created CDB of same Patch level
 1. Creating a Gold Image from the reference environment
 2. Subscribing Targets to the Selected Image
 3. Staging and Deploying the Software
 4. Migrating listener from old home to new home
 5. Migrating of one or more existing PDB's to the newly created CDB 
 a. DEPLOY_CDB: Deploys a new container DB
 b. Update PDB's: Move the PDB's from OLD Container DB to New Container DB
 B. Migration of one or more PDB's from an existing CDB to the same patch level destination CDB.
 1. Creating a Gold Image from the reference environment
 2. Subscribing Targets to the Selected Image
 3. Migrating listener from old home to new home
 4. Migrating of one or more existing PDB's to the newly created CDB 
 a. To Attach  a new container DB use the following command
 b. Update PDB's: Moves a PDB from its predecessor container to the newly available successor container
 6. Rollback Pluggable Databases
 7. Cleaning up oracle databases homes
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.