Performing rman duplicate on 19c database failed with below error:
Solution:
We must ensure that we are using the same password of "SYS" users on auxliliary and target database.
RMAN> connect target *Recovery Manager complete.
2> connect auxiliary *
3> run
4> {
5> duplicate target database for standby from active database nofilenamecheck;
6> }
7>
8>
PL/SQL package SYS.DBMS_BACKUP_RESTORE version 19.03.00.00 in TARGET database is not current
PL/SQL package SYS.DBMS_RCVMAN version 19.03.00.00 in TARGET database is not current
connected to target database: PRODDB (DBID=33467284355)
connected to auxiliary database: PRODDB (not mounted)
Starting Duplicate Db at 19-MAY-20
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 05/19/2020 17:43:58
RMAN-05501: aborting duplication of target database
RMAN-05614: Passwords for target and auxiliary connections must be the same when using active duplicate
Solution:
We must ensure that we are using the same password of "SYS" users on auxliliary and target database.
Comments
UK VPS Hosting