OIG R2PS3: Migrating Non-CDB Databases Into PDB
(Doc ID 2328942.1)
Last updated on AUGUST 30, 2023
Applies to:
Identity Manager - Version 11.1.2.3.0 and later Information in this document applies to any platform.
Purpose
This document describes a strategy to migrate OIG’s database 12c (non-CDB) to 12c pluggable database (PDB) in a new CDB environment with minimal down time.
AUDIENCE
This document is for primarily for Database Administrators who plan for, deploy, and manage OIG Database. It requires advanced knowledge of Oracle Database Administration.
DB VERSION
This document applies to Oracle Database - Enterprise Edition - (12.1.0.2) and later on any platform
SCENARIOS
Migrating a 12c non-CDB to a PDB on remote host
Migrating a 12c non-CDB to a PDB on the same host
PREREQUISITIES
Target host have a CDB database configured on it
WARNING
Once migrations starts, DO NOT ADD datafiles to the source. The incremental apply command (recover database noredo) WILL ONLY recover the datafiles already restored/cataloged. It WILL NOT RESTORE any new/ added datafiles.
REFERENCE
This document uses following documents as reference:
Step by Step Examples of Migrating non-CDBs and PDBs Using ASM for File Storage Document 1576755.1
How to migrate an existing pre-12c database (non-CDB) to 12c CDB database? <Document 1564657.1>
