CODEWITHSUNDEEP
oracle-databasedatabase-migrationoracle19cpluggable-database
user22476323
user22476323

Reputation: 11

Migrating NON CDB to PDB with minimal downtime

I am doing a migrating from 19.11 non-CDB on a local file system to 19.11 Pluggable Database (PDB) on Automatic Storage Management (ASM) on same server. I tested:

  1. CREATE PDB WITH NOCOPY
  2. DATAPUMP
  3. CREATE EMPTY PDB and move data via db_link.

None of these are reducing downtime. I can not use "nocopy " approach as new datafiles needs to be created with ASM. Thinking of using "Step by Step Process of Migrating non-CDBs and PDBs Using ASM for file storage (Doc ID 1576755.1)" but it requires ASM on both NON CDB and new PDB. Also thinking of exploring if I can create a non-cdb standby with ASM for current NON-CDB database with filesystem and switch it to prod and convert that prod to PDB. Looking for solution with minimal downtime.

Upvotes: 1

Views: 768

Answers (2)

Kotler
Kotler

Reputation: 151

Volumes database size ?TB or ?GB please.

  1. Very Large database, better use option RMAN backup and restore. Downtime with procedure only in backup incrementan level 1. Procedure backup level 0 not downtime and restore target PDB database. Finished 1., backup incremental level 1 and downtime primary database and restore on target PDB database. Note: Shutdown multi RAC and only run one or standalone database for task.
  2. convert Non-CDB to PDB - testcase with DBMS_PDB

Upvotes: 0

Connor McDonald
Connor McDonald

Reputation: 11591

"alter database move datafile" can be an online operation since 12, so I'd recommend doing this in 2 phases.

Phase 1 - convert your non-CDB local fs database to a non-CDB ASM database using the above commands.

Phase 2 - convert to PDB inplace.

Upvotes: 0

Related Questions