5 Replies Latest reply: Mar 29, 2012 9:35 AM by LKBrwn_DBA RSS

    ora-01580: error creating control backup file

    922156
      Hi,

      Made a mistake when setting the parameters of RMAN and now shows me the following error when running any command ... the error is in the destination path backup control file, there is a space between the name of the folder CONTROLFILE and the backslash:

      RMAN> show all;

      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of show command at 03/28/2012 10:11:28
      RMAN-03014: implicit resync of recovery catalog failed
      RMAN-03009: failure of full resync command on default channel at 03/28/2012 10:1
      1:28
      ORA-01580: error creating control backup file G:\DATABASE\X7AGK\BACKUPS\CONTROLF
      ILE \SNCFX7AGK.ORA
      ORA-27040: file create error, unable to create file
      OSD-04002: unable to open file
      O/S-Error: (OS 3) The system cannot find the path specified.


      Anyone know how to fix this?

      Thanks!
        • 1. Re: ora-01580: error creating control backup file
          912595
          Try running this command before show all

          RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%f';

          Then run show all;

          You can use clear the configuration with specifying 'clear' at end like

          RMAN>CONFIGURE CHANNEL DEVICE TYPE DISK CLEAR;
          • 2. Re: ora-01580: error creating control backup file
            LKBrwn_DBA
            You need to change the configuration, login to rman no catalog:
            rman target /
            RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'G:\Database\Correct\path\SNCFX7AGK.ORA'; 
            Logout from rman and login using catalog..then resync catalog.
            :p
            • 3. Re: ora-01580: error creating control backup file
              922156
              look:

              RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%f';

              RMAN-00571: ===========================================================
              RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
              RMAN-00571: ===========================================================
              RMAN-03002: failure of configure command at 03/28/2012 11:37:34
              RMAN-03014: implicit resync of recovery catalog failed
              RMAN-03009: failure of full resync command on default channel at 03/28/2012 11:3
              7:34
              ORA-01580: error creating control backup file G:\DATABASE\X7AGK\BACKUPS\CONTROLF
              ILE \SNCFX7AGK.ORA
              ORA-27040: file create error, unable to create file
              OSD-04002: unable to open file
              O/S-Error: (OS 3) The system cannot find the path specified.

              RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK CLEAR;

              RMAN-00571: ===========================================================
              RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
              RMAN-00571: ===========================================================
              RMAN-03002: failure of configure command at 03/28/2012 11:37:51
              RMAN-03014: implicit resync of recovery catalog failed
              RMAN-03009: failure of full resync command on default channel at 03/28/2012 11:3
              7:51
              ORA-01580: error creating control backup file G:\DATABASE\X7AGK\BACKUPS\CONTROLF
              ILE \SNCFX7AGK.ORA
              ORA-27040: file create error, unable to create file
              OSD-04002: unable to open file
              O/S-Error: (OS 3) The system cannot find the path specified.

              RMAN> show all;

              RMAN-00571: ===========================================================
              RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
              RMAN-00571: ===========================================================
              RMAN-03002: failure of show command at 03/28/2012 11:38:14
              RMAN-03014: implicit resync of recovery catalog failed
              RMAN-03009: failure of full resync command on default channel at 03/28/2012 11:3
              8:14
              ORA-01580: error creating control backup file G:\DATABASE\X7AGK\BACKUPS\CONTROLF
              ILE \SNCFX7AGK.ORA
              ORA-27040: file create error, unable to create file
              OSD-04002: unable to open file
              O/S-Error: (OS 3) The system cannot find the path specified.

              :(
              • 4. Re: ora-01580: error creating control backup file
                922156
                look:

                RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'G:\DATABASE\X7AGK\BACKUPS\CONTROLF
                ILE\SNCFX7AGK.ORA';

                RMAN-00571: ===========================================================
                RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
                RMAN-00571: ===========================================================
                RMAN-03002: failure of configure command at 03/28/2012 11:41:06
                RMAN-03014: implicit resync of recovery catalog failed
                RMAN-03009: failure of full resync command on default channel at 03/28/2012 11:4
                1:06
                ORA-01580: error creating control backup file G:\DATABASE\X7AGK\BACKUPS\CONTROLF
                ILE \SNCFX7AGK.ORA
                ORA-27040: file create error, unable to create file
                OSD-04002: unable to open file
                O/S-Error: (OS 3) The system cannot find the path specified.

                :(
                • 5. Re: ora-01580: error creating control backup file
                  LKBrwn_DBA
                  user12992860 wrote:
                  look:
                  RMAN-03014: implicit resync of recovery catalog failed
                  RMAN-03009: failure of full resync command on default channel at 03/28/2012 11:41:06
                  I said: DO NOT CONNECT TO THE CATALOG_
                  :p