Error 27037
Contents |
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson Blog
ora-27037 rman ORA-27037: unable to obtain file status tips Oracle ora-27037 unable to obtain file status impdp Database Tips by Burleson Consulting May 13, 2015 Question: I'm getting the error "ORA-27037: unable to obtain file status" ora-27037 unable to obtain file status redo log at shutdown time: Sun May 11 18:39:13 2015 Errors in file /oracle/PRD/saptrace/background/prd_arc0_4631.trc: ORA-27037: unable to obtain file status HP-UX Error: 2: No such file or directory Additional information: 4 Sun May 11 18:39:14 2015 Completed: ora 27037 unable to obtain file status rman archivelog ALTER DATABASE CLOSE NORMAL Sun May 11 18:39:14 2015 ALTER DATABASE DISMOUNT Completed: ALTER DATABASE DISMOUNT What causes the "ORA-27037: unable to obtain file status" error? Answer: It's a missing file, usually an archived redo log or a parm file: ORA-27037: unable to obtain file status Cause: Stat system call returned an error. Additional information indicates which function encountered the error. Action: Examine errno. First, a quick look atControl File Backup Creation Failed Failure To Open Backup Target File
the trace file will tell you the exact file name. The ORA-27037 often happens when you clone a database, and forget to copy a file. HP-UX Error: 2: No such file or directory This is a missing file somewhere. - It could be a missing archivelog file . . . . . - It could be a file mentioned in your init.ora file . . . . �� Burleson is the American Team Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals. Feel free to ask questions on our Oracle forum. Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications. Errata? Oracle technology is changing and we strive to update our BC Oracle support information. If you find an error or have a suggestion for improving our content, we would appreciate your feedback. Just e-mail: and include the URL fo
Scenario:RMAN error RMAN> backup archivelog
Ora-00308
from sequence 4 until sequence 79; Starting backup at 10-JUL-12 ora-19625 error identifying file rman using channel ORA_DISK_1 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== ora-27037 orion RMAN-03002: failure of backup command at 07/10/2012 22:48:00 RMAN-06059: expected archived log not found, loss of archived log compromises recoverability ORA-19625: error identifying http://www.dba-oracle.com/t_ora_27037_unable_to_obtain_file_status.htm file /u02/pune/archivelog/ARC_1_4_787996832.dbf ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3 RMAN> backup archivelog all; Starting backup at 10-JUL-12 using channel ORA_DISK_1 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of backup command http://oraclegurukul.blogspot.com/2012/07/ora-27037-unable-to-obtain-file-status.html at 07/10/2012 22:49:22 RMAN-06059: expected archived log not found, loss of archived log compromises recoverability ORA-19625: error identifying file /u02/pune/archivelog/ARC_1_4_787996832.dbf ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3 RMAN> backup archivelog from SCN 917572 until SCN 1131578; Starting backup at 10-JUL-12 using channel ORA_DISK_1 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of backup command at 07/10/2012 22:56:19 RMAN-06059: expected archived log not found, loss of archived log compromises recoverability ORA-19625: error identifying file /u02/pune/archivelog/ARC_1_4_787996832.dbf ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3 ======= Solution: ======= I have placed primary to standby starting 3 logfiles 1 2 3 they have been register on standby database but again check the rman show error: RMAN> backup
Thu, 26 Aug 2004 14:34:35 -0400 Has anyone pointed out that the correct syntax of the command is CREATE PFILE = 'my_init.ora' FROM SPFILE http://www.freelists.org/post/oracle-l/ORA27037-unable-to-obtain-file-status,2 = 's_params.ora'; HTH -- Mark D Powell -- -----Original Message----- From: http://grokbase.com/t/freelists.org/oracle-l/048nefxbg8/ora-27037-unable-to-obtain-file-status oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Ruth Gramolini Sent: Thursday, August 26, 2004 2:08 PM To: oracle-l@xxxxxxxxxxxxx Subject: RE: ORA-27037: unable to obtain file status 27037, 00000, "unable to obtain file status" // *Cause: stat system call returned an error, additional information // indicates which function unable to encountered the error // *Action: check errno Did you check the accompanying error message? What was it? Regards, Ruth -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of jaysingh1@xxxxxxxxxxxxx Sent: Saturday, August 21, 2004 10:46 AM To: oracle-l@xxxxxxxxxxxxx Subject: ORA-27037: unable to obtain file status Hi All, I am trying to create PFILE for my ASM instance and unable to obtain getting the following error. Could someone shed some light on this? [oracle@rac1pub bdump]$ export ORACLE_SID=+ASM1 [oracle@rac1pub bdump]$ sqlplus /nolog SQL*Plus: Release 10.1.0.2.0 - Production on Sat Aug 21 10:34:04 2004 Copyright (c) 1982, 2004, Oracle. All rights reserved. SQL> connect / as sysdba Connected. SQL> select instance_name from v$instance; INSTANCE_NAME ---------------- +ASM1 SQL> create pfile from spfile; create pfile from spfile * ERROR at line 1: ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3 ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- Other related posts:» ORA-27037: unable to obtain file status » RE: ORA-27037: unable to obtain file status » RE: ORA-27037: unable to obtain file status Home oracle-l Archive 08-2004 » Previous by Date» Next by Date » Related Posts » View list details » Manage your subscription © Avenir Technologies, LLC 2015
for my ASM instance and getting the following error. Could someone shed some light on this?[oracle_at_rac1pub bdump]$ export ORACLE_SID=+ASM1[oracle_at_rac1pub bdump]$ sqlplus /nologSQL*Plus: Release 10.1.0.2.0 - Production on Sat Aug 21 10:34:04 2004Copyright (c) 1982, 2004, Oracle. All rights reserved.SQL> connect / as sysdbaConnected.SQL> select instance_name from v$instance;INSTANCE_NAME+ASM1SQL> create pfile from spfile;create pfile from spfile*ERROR at line 1:ORA-27037: unable to obtain file statusLinux Error: 2: No such file or directoryAdditional information: 3Please see the official ORACLE-L FAQ: http://www.orafaq.comTo unsubscribe send email to: oracle-l-request_at_freelists.orgput 'unsubscribe' in the subject line.--Archives are at http://www.freelists.org/archives/oracle-l/FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html----------------------------------------------------------------- reply Tweet Search Discussions Search All Groups oracle-l 2 responses Oldest Nested Ruth Gramolini 27037, 00000, "unable to obtain file status" // *Cause: stat system call returned an error, additional information // indicates which function encountered the error // *Action: check errno Did you check the accompanying error message? What was it? Regards, Ruth -----Original Message----- From: oracle-l-bounce_at_freelists.org On Behalf Of jaysingh1_at_optonline.net Sent: Saturday, August 21, 2004 10:46 AM To: oracle-l_at_freelists.org Subject: ORA-27037: unable to obtain file status Hi All, I Ruth Gramolini at Aug 26, 2004 at 1:03 pm ⇧ 27037, 00000, "unable to obtain file status"// *Cause: stat system call returned an error, additional information// indicates which function encountered the error// *Action: check errnoDid you check the accompanying error message? What was it?Regards,Ruth-----Original Message-----From: oracle-l-bounce_at_freelists.orgOn Behalf Ofjaysingh1_at_optonline.netSent: Saturday, August 21, 2004 10:46 AMTo: oracle-l_at_freelists.orgSubject: ORA-27037: unable to obtain file statusHi All,I am trying to create PFILE for my ASM instance and getting the followingerror. Could someone shed some light on this?[oracle_at_rac1pub bdump]$ export ORACLE_SID=+ASM1[oracle_at_rac1pub bdump]$ sqlplus /nologSQL*Plus: Release 10.1.0.2.0 - Producti