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