RMAN ORA-27037: unable to obtain file status
Hi experts,
I have a daily cron job that refreshes UAT from production (RMAN’s DUPLICATE). Never had any issues, have not made any changes to scripts/users/backups etc., however, it stopped working.
RMAN gives the following:
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: reading from backup piece
channel ORA_AUX_DISK_1: ORA-19870: error while restoring backup piece
ORA-19505: failed to identify file "..."
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
failover to previous backup
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at...
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06024: no backup or copy of the control file found to restore
RMAN> **end-of-file**
Sure, the files are there – I can see them with LIST BACKUP (CROSSCKECKs are run daily as part of backup procedure); the backup sits on the production box and I can access the files from both boxes no problem (the permissions are 640, backups are created by oracle and cron is run by oracle too); in RMAN I can connect to both databases (rman target / auxiliary).
Both databases are 11g.
Any ideas what else I need to check?..
Thanks,
Galina