<<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
Post a Comment