Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

user584948May 10 2016 — edited May 11 2016

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.

This post has been answered by Levi Pereira on May 10 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 8 2016

Added on May 10 2016

#performance-availability, #recovery-manager-rman

2 comments

3,611 views