Hi All,
We have been encountering ORA-27037 and have read around the net a few times but i still cant find the answer as to why we are getting this in the alert log.
the most general answer that I have found is from here ORA-27037: unable to obtain file status tips I am not sure if this error arises during the rman backup our operators run but its the activity that is nearest the time in the logs
I have also talked with people around this morning and they said that they have run the archivelog backup script, shown below.
I am also not familiar with RMAN so im not sure if there are any parameter or format errors but as I saw the backup scripts does generate the (archivelog) backup files.
I have also changed some names to **********
Thanks All in Advanced.
Below are server details and files ( alert logs etc)
Oracle Version: 9.2.0.6 Standard Edition
OS Version: Sun Solaris 5.9
Alert log
Completed checkpoint up to RBA [0x439.2.10], SCN: 0x0001.6933b387
Thu Aug 29 09:16:45 2013
Errors in file /DATA/oracle/Ora92/rdbms/log/cardprod_ora_11627.trc:
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 4
Said Trace File
more cardprod_ora_11627.trc
/DATA/oracle/Ora92/rdbms/log/cardprod_ora_11627.trc
Oracle9i Release 9.2.0.6.0 - Production
JServer Release 9.2.0.6.0 - Production
ORACLE_HOME = /DATA/oracle/Ora92
System name: SunOS
Node name: *********
Release: 5.9
Version: Generic_118558-35
Machine: sun4u
Instance name: *********
Redo thread mounted by this instance: 1
Oracle process number: 93
Unix process pid: 11627, image: oracle@********* (TNS V1-V3)
*** 2013-08-29 09:16:45.663
*** SESSION ID:(46.11953) 2013-08-29 09:16:45.187
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 4
Backup scripts
backuparchivelog.sh
date
rman target / catalog rman/rman@rman cmdfile= backuparchivelog.rcv msglog= backuparchivelog.log
date
backuparchivelog.rcv
# connect target sys/sys@********* catalog rman/rman@rman;
# start backup database
run{
allocate channel c1 type disk;
crosscheck archivelog all;
delete noprompt expired archivelog all;
sql 'alter system archive log current';
backup format '/DATA/archivelog/al_%d_t%t_s%s_p%p' (archivelog all);
release channel c1;
resync catalog;
}
# end