While recreating an standby DB from an active primary RAC DB, rman might fail with these errors:

RMAN> duplicate target database for standby from active database dorecover  nofilenamecheck;
....
....

Starting restore at 01-JUN-23
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service TEST19C
channel ORA_AUX_DISK_1: restoring control file
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 06/01/2023 16:05:54
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
ORA-19845: error in backupControlFile while communicating with remote database server
ORA-17628: Oracle error 245 returned by remote Oracle server
ORA-00245: control file backup failed; in Oracle RAC, target might not be on shared storage
ORA-19660: some files in the backup set could not be verified
ORA-19661: datafile 0 could not be verified
ORA-19845: error in backupControlFile while communicating with remote database server
ORA-17628: Oracle error 245 returned by remote Oracle server
ORA-00245: control file backup failed; in Oracle RAC, target might not be on shared storage

This is not an actual issue on the standby side, but instead a RMAN config on primary.

RMAN>  show SNAPSHOT CONTROLFILE NAME;
RMAN configuration parameters for database with db_unique_name TEST19C are:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/19c/dbhome_1/dbs/snapcf_test19c1.f'; # default
RMAN>

Since primary is a RAC DB, snapshot control file needs to be located on a shared location, so lets change to:

RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO  '+DATA/TEST19C/CONTROLFILE/snapcf_test19c1.f';
new RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATA/TEST19C/CONTROLFILE/snapcf_test19c1.f';
new RMAN configuration parameters are successfully stored
RMAN>

After this, duplicate completed ok.

Last modified: 1 June 2023

Author

Comments

Write a Reply or Comment

Your email address will not be published.