RMAN-05500: the auxiliary database must be not mounted when issuing a DUPLICATE command
Cause:
RMAN duplication fails because the database is in mount mode
RMAN> run
{
allocate channel ch1 type disk;
allocate channel ch2 type disk;
allocate channel ch3 type disk;
allocate channel ch4 type disk;
allocate channel ch5 type disk;
allocate channel ch6 type disk;
allocate channel ch7 type disk;
allocate channel ch8 type disk;
allocate auxiliary channel ch9 type disk;
allocate auxiliary channel ch10 type disk;
allocate auxiliary channel ch11 type disk;
DUPLICATE TARGET DATABASE TO "exdbx" skip tablespace UNDOTBS1,USERS,UND OTBS2,EXAMPLE
FROM ACTIVE DATABASE NOFILENAMECHECK;
}2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16>
using target database control file instead of recovery catalog
allocated channel: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 02/17/2021 08:07:05
RMAN-05501: aborting duplication of target database
RMAN-05500: the auxiliary database must be not mounted when issuing a DUPLICATE command
Workaround:
Shutdown the instance
SQL> shu immediate;
Startup the database in nomount mode
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 217157632 bytes
Fixed Size 2251816 bytes
Variable Size 159384536 bytes
Database Buffers 50331648 bytes
Redo Buffers 5189632 bytes
Now run the duplicate command