We're here to help!

ORA-27072 and ORA-27047 During Standby Recovery in Oracle version 11.2.0.3

Follow
Problem Description

While executing the recovery commend on the standby database ORA-27072 and ORA-27047 is reported in Oracle version 11.2.0.3.

Investigation showed that if you have other files in this location, such as text files or compressed files, you will get errors during recovery: ORA-27072 and ORA-27047.

Solution

The solution is to move these foreign files out of this location or to uncompress the archive logs if they are compressed. Then retry the recovery process.

Below is an example showing how this error can be generated by creating a text file in the archivelog location in the FRA for the TESTDB database.

oracle@dbvlin101[/u01/app/oracle/fast_recovery_area/TESTDB]: cd archivelog/  
oracle@dbvlin101[/u01/app/oracle/fast_recovery_area/TESTDB/archivelog]: ls
2013_11_12 2013_12_12 2013_12_13 2013_12_17 2013_12_18 2013_12_19 2014_01_03 
oracle@dbvlin101[/u01/app/oracle/fast_recovery_area/TESTDB/archivelog]: touch test.txt <<<<<--- creating a dummy text file
oracle@dbvlin101[/u01/app/oracle/fast_recovery_area/TESTDB/archivelog]: sqlplus /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Fri Jan 3 20:31:52 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

20:31:52 SQL> connect / as sysdba
Connected.
20:31:55 SQL> recover standby database;
ORA-00279: change 33314080 generated at 01/03/2014 17:03:36 needed for thread 1
ORA-00289: suggestion : /u01/app/oracle/fast_recovery_area/TESTDB/archivelog/2014_01_03/o1_mf_1_4735_%u_.arc
ORA-27072: File I/O error
Linux-x86_64 Error: 25: Inappropriate ioctl for device
Additional information: 4
Additional information: 1
ORA-27047: unable to read the header block of file
Linux-x86_64 Error: 25: Inappropriate ioctl for device
Additional information: 1
ORA-27047: unable to read the header block of file
Linux-x86_64 Error: 25: Inappropriate ioctl for device
Additional information: 1
ORA-00280: change 33314080 for thread 1 is in sequence #4735


20:31:59 Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

Anton Els January 04, 2014 00:18

Have more questions? Submit a request

Comments