Database Backup and Recovery (MOSC)

MOSC Banner

Restore only on pdb from rman backup on another server without access to recovery catalog

edited Jan 18, 2018 5:55AM in Database Backup and Recovery (MOSC) 7 commentsAnswered ✓

I want to restore  a cdb with  only one pdb (instead of all pdb) from a full rman backup on another server without access to the recovery catalog

I'm able to restore all pdb  with this command:

duplicate database to 'tempcdb'

noopen backup location '/coldbackup';

But when I specify the only pdb with this command:

duplicate target database to 'tempcdb'

pluggable database pdb1

noopen backup location'/coldbackup';

I receive the message:

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 06/01/2017 12:09:02
RMAN-05501: aborting duplication of target database
RMAN-05521: DUPLICATE without CATALOG and TARGET not open requires that UNDO TABLESPACE is specified

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center