3 Replies Latest reply: Feb 5, 2014 10:55 PM by dbaAK RSS

    ora-00245 control file backup failed target is likely on a local file system

    dbaAK

      Hi,

       

      I'm getting this error in the alert log. I checked the RMAN configuration and the CONTROLFILE SNAPSHOT BACKUP is configured to a shared ASM disk but still getting the error.

       

      Version:11.2.0.3

       

      Appreciate your advise.

        • 1. Re: ora-00245 control file backup failed target is likely on a local file system
          sb92075

          00245, 00000, "control file backup operation failed"

          // *Cause:  Failed to create a control file backup because some process

          //          signaled an error during backup creation.

          // *Action: Check alert files for further information. This usually happens

          //          because some process could not access the backup file during

          //          backup creation. Any process of any instance that starts a read/write

          //          control file transaction must have an access to the backup control file

          //          during backup creation.

           

          Oracle is too dumb to lie.

          Believe the error message

          • 2. Re: ora-00245 control file backup failed target is likely on a local file system
            Suntrupth

            Is this a RAC database?

             

             

            1. Check the snapshot controlfile location:

            RMAN> show all;

             

             

            2. Configure the snapshot controlfile to a shared disk:

            RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '<shared_disk>/snapcf_<DBNAME>.f';

             

             

            3. connect to RMAN and issue:

            RMAN>  CONFIGURE SNAPSHOT CONTROLFILE NAME TO <shared_location_file>;

             

             

            This location must be available to EACH node.

             

             

            4. A controlfile copy created by either Sqlplus or RMAN backup must also reside on a shared device.  I.e.,:

             

             

            SQL>  alter database backup controlfile to '/........./control_backup.ctl' reuse;

            or

            RMAN>  copy current controlfile to '/......./control_backup.bak';

             

             

            will fail with same "ORA-00245: control file backup operation failed" error if the location to create the controlfile backup is NOT a shared device. 

             

             

            Due to the changes made to the controlfile backup mechanism any instances in the cluster may write to the backup controlfile when making changes to the current controlfile. Therefore, the backup file needs to be visible to all instances.

             

             

            Also, Check the following : Note 16012614.8 : Bug 16012614 - ORA-245 on RMAN controlfile backup

             

            Regards,

            Suntrupth

            • 3. Re: ora-00245 control file backup failed target is likely on a local file system
              dbaAK

              Solved.

              Actually, backup configuration is already set to shared disk.

              But RE-CONFIGURING the SNAPSHOT CONTROLFILE in RMAN worked.

              "CONFIGURE SNAPSHOT CONTROLFILE NAME TO <shared_location_file>;"

               

              Thanks!!