Site icon IT Tutorial

ORA-00245: control file backup failed; in Oracle RAC, target might not be on shared storage

Hi,

You can get ” ORA-00245: control file backup failed; in Oracle RAC, target might not be on shared storage” error when you take backup of Oracle database.

 

ORA-00245: control file backup failed

Details of error are as follows.

Starting Control File and SPFILE Autobackup at 2020-09-19:12:14:24
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of Control File and SPFILE Autobackup command on Disk channel at 2020-09-19:12:14:28
ORA-00245: control file backup failed; in Oracle RAC, target might not be on shared storage

 

 

ORA-00245

If you got ” ORA-00245: control file backup failed; in Oracle RAC, target might not be on shared storage ” error, it means you are using Oracle RAC and you need to set SNAPSHOT CONTROLFILE NAME to the Shared Storage or Shared Location instead of local disk or storage.

 

Check existing configurations like following.

RMAN> show all;

using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name DEVECI are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 15;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/oracle/12.2/db/dbs/snapcf_DEVECI1.f';

 

 

 

in Oracle RAC, target might not be on shared storage

 

To Solve ORA-00245 error, configure SNAPSHOT CONTROLFILE NAME TO the +DATAC1 or any other Shared Disk group.

RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATAC1/DEVECI/CONTROLFILE/snapcf_DEVECI1.f';

old RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATAC1/DEVECI/CONTROLFILE/snapcf_DEVECI1.f';
old RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATAC1/DEVECI/CONTROLFILE/snapcf_DEVECI1.f';
new RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATAC1/DEVECI/CONTROLFILE/snapcf_DEVECI1.f';
new RMAN configuration parameters are successfully stored

RMAN>

 

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )

Exit mobile version