HOW TO PERFORM RMAN PARTIAL DUPLICATE SKIPPING NOT REQUIRED TABLESPACES FROM TAPE/ZDLRA BACKUP (Doc ID 2914588.1)

Last updated on APRIL 17, 2023

Applies to:

Goal

For duplicate partial database skipping not required tablespace to new database using Tape/ZDLRA backups.This doc is useful incase of skipping only those tablespace name which are not needed while Duplicate.
In this doc one can include only those tablespaces which are not 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.