RMAN duplicate using ‘SKIP TABLESPACE’ skipping all tablespaces

Duplicate the database using RMAN and SKIP tablespace, restoring only the necessary tablespace for table recovery.

You must include the specified tablespace to create new databases.

System tablespace
Sysaux tablespace
Undo tablespaces ( all included in RAC)

To duplicate a database with RMAN while skipping specific tablespaces, you can use the SKIP TABLESPACE option in the DUPLICATE command.

1. Connect to the Target and Auxiliary Databases:

RMAN> CONNECT TARGET SYS@target_db;
RMAN> CONNECT AUXILIARY SYS@auxiliary_db;

2. Run the DUPLICATE Command with SKIP TABLESPACE:

RMAN> DUPLICATE TARGET DATABASE TO auxiliary_db
2> SKIP TABLESPACE tablespace_name1, tablespace_name2;