12c: RMAN ORA-01580: error creating control backup file

Today I have encountered one of the issue. Weird issue, occurred in 12.1.02. 

RMAN not allowing to update the value of SNAPSHOT CONTROLFILE NAME. this DB was migrated from OEL 5.11 to OEL 7.9, from ASM to file system.  

=>rman target=/ catalog=rmanqa/***@rmancat

Recovery Manager: Release 12.1.0.2.0 - Production on Mon Oct 24 13:37:32 2022


Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.


connected to target database: GLXYQ (DBID=1753589618)

connected to recovery catalog database

recovery catalog schema release 19.03.00.00. is newer than RMAN release


RMAN> register database;


RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of register command at 10/24/2022 13:37:47

RMAN-03014: implicit resync of recovery catalog failed

RMAN-03009: failure of full resync command on default channel at 10/24/2022 13:37:47

ORA-01580: error creating control backup file +DATA/GLXYQ/snapcf_glxyq.f

ORA-17502: ksfdcre:3 Failed to create file +DATA/GLXYQ/snapcf_glxyq.f

ORA-15001: diskgroup "DATA" does not exist or is not mounted

ORA-29701: unable to connect to Cluster Synchronization Service


RMAN> show all;

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of show command at 10/24/2022 13:38:29

RMAN-03014: implicit resync of recovery catalog failed

RMAN-03009: failure of full resync command on default channel at 10/24/2022 13:38:29

ORA-01580: error creating control backup file +DATA/GLXYQ/snapcf_glxyq.f

ORA-17502: ksfdcre:3 Failed to create file +DATA/GLXYQ/snapcf_glxyq.f

ORA-15001: diskgroup "DATA" does not exist or is not mounted

ORA-29701: unable to connect to Cluster Synchronization Service

RMAN>

I was thinking to update using RMAN command, it didn't help. 

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u02/oradata/fctrq/data/FCTRQ_EEC/datafile/snapcf_glxyq.f';

Finally I had to run using SQL code to fix the problem. 

SQL> EXECUTE SYS.DBMS_BACKUP_RESTORE.CFILESETSNAPSHOTNAME('/u02/oradata/fctrq/data/FCTRQ_EEC/datafile/snapcf_glxyq.f');

PL/SQL procedure successfully completed.

SQL> 

Now the values are shown correctly. !!

RMAN> show SNAPSHOT CONTROLFILE NAME;

RMAN configuration parameters for database with db_unique_name FCTRQ_EEC are:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u02/oradata/fctrq/data/FCTRQ_EEC/datafile/snapcf_glxyq.f';

RMAN>

I hope this helps someone out there. 

No comments: