My Oracle Support Banner

HOW TO PERFORM RMAN BACKUP BASED PARTIAL DUPLICATE INCLUDING REQUIRED TABLESPACES TO NEW CDB (Doc ID 2917631.1)

Last updated on DECEMBER 29, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Goal

For duplicate partial database including few tablespace to new database.This doc is useful incase of specifying(including) Only those tablespace name which are needed while Duplicate.
In this doc one can include only those tablespaces which are needed for business data.By default, RMAN duplicates the root and the seed database of the CDB that contains the listed PDBs.
In this doc, after duplicate new CDB is created with required tabelspace (and root and the seed database of the CDB).
This doc can also useful incase of PITR restore / recovery of Multi Tenant database to extract information from the dropped / truncated tables of specific PDB.

Solution

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
Goal
Solution
References

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