Ameer Khan

Env:-

DB : 12.1.0.2

GI: 19.0.0(Oracle restart)

OS: OEL 7

DB Type: Standalone Database

During execution of  rman duplicate database  following error is observed.

RMAN> run{ allocate auxiliary channel C1 DEVICE TYPE DISK; allocate auxiliary channel C2 DEVICE TYPE DISK; allocate auxiliary channel C3 DEVICE TYPE DISK; allocate auxiliary channel C4 DEVICE TYPE DISK; duplicate database to ‘E1THS’ backup location ‘/u01/rman18062021/databkp’ nofilenamecheck; }

Error details:-

RMAN-03015: error occurred in stored script Memory Script RMAN-03009: failure of sql command on clone_default channel at 11/07/2022 02:29:26 RMAN-20000: abnormal termination of job step RMAN-11003: failure during parse/execution of SQL statement: alter system reset  db_unique_name scope=spfile RMAN-11001: Oracle Error: ORA-32010: cannot find entry to delete in SPFILE RMAN-03015: error occurred in stored script Memory Script RMAN-03009: failure of sql command on clone_default channel at 11/07/2022 02:29:06 RMAN-20000: abnormal termination of job step RMAN-11003: failure during parse/execution of SQL statement: alter system set  db_unique_name =  ‘E1THS’ comment= ‘Modified by RMAN duplicate’ scope=spfile RMAN-11001: Oracle Error: ORA-32017: failure in updating SPFILE ORA-65500: could not modify DB_UNIQUE_NAME, resource exists RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 11/07/2022 02:29:26 RMAN-05501: aborting duplication of target database

Rationale:-

This issue is reported as Bug 20977794 in MOS for Oracle 12.1.0.2 version.The error is observed during execution of rman duplicate database where any attempt to change DB_UNIQUE_NAME for database when a CRS resource for it exists. As RMAN tries to make a change to db_unique_name, this error is observed.

Solution :-

Remove the existing entry to database which is going to be cloned from CRS registry

[oracle@server004 dbs]$ srvctl config database E1KRS E1THS   [oracle@server004 dbs]$ srvctl remove database -db E1THS Remove the database E1THS? (y/[n]) y

Now rerun the Rman duplicate command , it should work fine.