Friday, March 25, 2022

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

 Problem:

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.

Solution:

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;

      DBID
----------
1352250453

 

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
spfile
...
}

Good luck!


No comments:

Post a Comment