2 Replies Latest reply on May 11, 2016 1:15 PM by user584948

    RMAN Backup Failing - ORA-01565: error in identifying file

    user584948

      I am having a strange error with an RMAN backup failing due to a missing spfile

      Starting Control File and SPFILE Autobackup at 10/05/2016 15:19:08

      released channel: d1

      RMAN-00571: ===========================================================

      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

      RMAN-00571: ===========================================================

      RMAN-03009: failure of Control File and SPFILE Autobackup command on d1 channel at 05/10/2016 15:19:09

      ORA-01565: error in identifying file '/apps/oracle/product/11.2/db_1/dbs/spfileppptt1r.ora'

      ORA-27037: unable to obtain file status

      Linux-x86_64 Error: 2: No such file or directory

      Additional information: 3

      I am using Oracle 11.2.0.3 and an ASM file system.  We are using an spfile, but since it is an ASM filesystem , it is located at +DATA/PPPTT1R/PARAMETERFILE/spfile.303.911472519. Why would it looking for an non-existing spfile, and how can I remove it from RMAN?  Thanks so much.