4 Replies Latest reply on Apr 25, 2019 9:46 AM by user9348010

    RMAN-06172: no autobackup found or specified handle is not a valid copy or piece

    user9348010

      Hi,

       

      We have a latest controlfile autobackup piece stored in ASM as follows:

       

      +FRA/<db name>/autobackup/2019_04_15/s_1005617692.279.1005617693

       

      When attempting to restore the SPFILE from this autobackup piece during a disaster recovery exercise using 'restore spfile from autobackup;' within the RMAN run block, the following error is returned:

       

      RMAN-06172: no autobackup found or specified handle is not a valid copy or piece

       

      However when we use 'restore spfile from '+FRA/<db name>/autobackup/2019_04_15/s_1005617692.279.1005617693';' within the RMAN run block it is successful

       

      I have noted the name of the autobackup piece stored in the FRA is prefixed with 's_'. Is this the reason the 'from autobackup' feature returns the error above?

       

      We currently have the following RMAN persistent configuration settings in relation to the controlfile autobackups so I cannot understand the prefix of 's_' on the autobackup piece stored in the FRA, unless the RMAN format is being ignored when the ASM file name is generated:

       

      CONFIGURE CONTROLFILE AUTOBACKUP ON;

      CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO '%F';

      CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default

       

      Once we have restored the spfile using 'restore spfile from '+FRA/sprsdms/autobackup/2019_04_15/s_1005617692.279.1005617693';', any subsequent restores of the spfile work successfully using the 'restore spfile from autobackup;' method. Please can anyone explain this behaviour?

       

      Thanks in advance

       

      Steve