Friday, March 25, 2022

Duplicate of a Standby DB from an RMAN backup throws RMAN-05657: There are multiple database IDs present


The RMAN duplicate command for creating a standby database from a backup throws the following error, just right after allocating auxiliary channels:

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 03/24/2022 13:32:59
RMAN-05501: aborting duplication of target database
RMAN-05657: There are multiple database IDs present.


Try to set the same DBID of the primary DB in the duplicate script of the standby DB:

Get the DBID from the primary DB:

SQL> select dbid from v$database;



Or from the RMAN backup logfile:

Then set the DBID in the duplicate script like this:

set dbid 1352250453
run {
allocate auxiliary channel aux1 type disk;
duplicate target database for standby backup location '/backup/RMANBKP' nofilenamecheck

Good luck!

No comments:

Post a Comment