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 )