Skip to main content

Cannot read block 1 from backup restore failover to read from RMAN


<<Back to Oracle Backup & Recovery Main Page

Cannot read block 1 from /u01/app/oracle/stage/D_20181211_s3tkguui_s3971_p1 - restore failover to read from /u01/app/oracle/stage/bkp/bkp/D_20181211_s3tkguui_s3971_p1

RMAN>RUN {
RESTORE DATABASE;
RECOVER DATABASE;
}

Database alert.log

Cannot read block 1 from /u01/app/oracle/stage/D_20181211_s3tkguui_s3971_p1 - restore failover to read from /u01/app/oracle/stage/bkp/bkp/D_20181211_s3tkguui_s3971_p1
ORA-19505: failed to identify file "/u01/app/oracle/stage/D_20181211_s3tkguui_s3971_p1"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

Cause: RMAN is not able to find the backup pieces at /u01/app/oracle/stage/ location and therefore reading from alternate location. There might be possibility that the backup pieces has been deleted from /u01/app/oracle/stage/ location
Solution:
The error can be ignored because the restore is anyway working however if you want to fix this you can follow the steps below

RMAN> crosscheck backup of database;
RMAN> delete expired backup;

run the restore again
RMAN>RUN {
RESTORE DATABASE;
RECOVER DATABASE;
}

Comments