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

Last updated on JULY 11, 2023

Applies to:

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

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