RMAN-11003: failure during parse/execution of SQL statement: alter system reset  db_unique_name scope=spfile



While doing RMAN duplicate the process was failing with the below error.

Error:

Errors in memory script
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of sql command on clone_default channel at 11/23/2020 09:54:16
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/23/2020 09:54:06
RMAN-20000: abnormal termination of job step
RMAN-11003: failure during parse/execution of SQL statement: alter system set  db_unique_name =  'TEST' 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/23/2020 09:54:16
RMAN-05501: aborting duplication of target database


BackGround:

The duplicate was failing and when we already have dropped TEST database and no database was running with that particular SID. This was quite strange to find why RMAN was failing.

Solution:

After a lot of investigation, I found that the database was dropped but it was still registered in srvctl due to which RMAN was failing.

test--> Is my Oracle database SID

cd $ORACLE_HOME/bin

$ ./srvctl config database -d test
Database unique name: test
Database name: test
Oracle home: /d01/oracle/12.1.0/dbhome
Oracle user: oracle
Spfile: /d01/oracle/12.1.0/dbhome/dbs/spfiletest.ora
Password file:
Domain: lab
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Disk Groups: TEST_DATA
Services: test
OSDBA group: dba
OSOPER group: dba
Database instance: test


./srvctl remove database -d test


Re-run RMAN duplicate 




If you like please follow and comment