Oracle Ora-27072 File I/o Error
Contents |
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message and ora-27072 file i/o error additional information 4 try again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion ora-19502 write error on file ora-27072 file i/o error is archived 10 Replies Latest reply on Apr 28, 2010 12:01 PM by user8211869 ORA-27072: File I/O error Additional information: 2 dsmoljanovic Feb ora-19502 ora-27072 file i/o error 25, 2008 7:32 AM Recently we keep getting this error in our data warehouse. I can not pin point the cause of this. It's not easily reproducible, just happens from time to time. Anyone knows anything about
Ora-27072: File I/o Error Linux-x86_64 Error: 5: Input/output Error
this? We are running aix 5.3. Could this have anything to do with aioservers? 34921Views Tags: none (add) errorsContent tagged with errors, ora-604-27072-Content tagged with ora-604-27072- This content has been marked as final. Show 10 replies 1. Re: ORA-27072: File I/O error Additional information: 2 Maran Viswarayar Feb 25, 2008 7:41 AM (in response to dsmoljanovic) Can we have full error messages Soemtimes this could be due to a corrupted datafile... Like Show 0 Likes(0) ora-19502 write error on file blockno (blocksize=8192) Actions 2. Re: ORA-27072: File I/O error Additional information: 2 96843 Feb 25, 2008 7:42 AM (in response to dsmoljanovic) Can you post the full error message from your alert log file. Like Show 0 Likes(0) Actions 3. Re: ORA-27072: File I/O error Additional information: 2 585179 Feb 25, 2008 7:42 AM (in response to dsmoljanovic) When this error happen again could you check AIX error report? See any correlation from this report Cheers http://fiedizheng.blogspot.com/ Like Show 0 Likes(0) Actions 4. Re: ORA-27072: File I/O error Additional information: 2 dsmoljanovic Feb 25, 2008 7:51 AM (in response to Maran Viswarayar) The strange thing is i don't have anything in alert log. My procedure just brakes with this error: ORA-27072: File I/O error Additional information: 2 Like Show 0 Likes(0) Actions 5. Re: ORA-27072: File I/O error Additional information: 2 Maran Viswarayar Feb 25, 2008 7:57 AM (in response to dsmoljanovic) hat does the procedure doesW? whats the ULIMIT for the Oracle USer? is it unlimited? probably will be set... Is your file system full? Like Show 0 Likes(0) Actions 6. Re: ORA-27072: File I/O error Additional information: 2 96843 Feb 25, 2008 7:57 AM (in response to dsmoljanovic) Looks like you are hitting a bug. One of metalink notes suggests that you apply some AIX patches. The metalink note id is Note
No Comments Tweet We rman ora-27072: file i/o error got the following error when backing up an 11.2.0.3
Linux-x86_64 Error: 25: Inappropriate Ioctl For Device
database to an external disk. RMAN> run 2> { 3> allocate channel
Ora-27072 Skgfdisp I/o Error
d1_disk_backup device type disk ; 4> crosscheck backup; 5> backup incremental level 1 cumulative as COMPRESSED BACKUPSET copies=1 tag 'DAILY_BCK' database https://community.oracle.com/thread/624079 format '/external_usb/mesutt_daily_%U.bkp'; 6> backup tag '%ARCTAG' archivelog all not backed up since time 'SYSDATE-5' format '/external_usb/mesutt_arc_%U.bkp'; 7> backup current controlfile tag 'CTL' format '/external_usb/mesutt_cntl_%U.bkp'; 8> backup spfile tag 'SPF' format '/external_usb/mesutt_spfile_%U.bkp'; 9> release channel d1_disk_backup; 10> } allocated channel: d1_disk_backup channel d1_disk_backup: SID=576 http://www.oracle-class.com/?p=3162 device type=DISK ... .... released channel: d1_disk_backup RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of backup command on d1_disk_backup channel at 10/06/2014 03:55:55 ORA-19502: write error on file "/external_usb/mesutt_arc_pvpkbj7m_1_1.bkp", block number 16388096 (block size=512) ORA-27072: File I/O error Additional information: 4 Additional information: 16388096 Additional information: 339968 Let s check user permissions to this mount point, vmuttora1(mesutt):/home/oracle>df -h Filesystem Size Used Avail Use% Mounted on /dev/mapper/VolGroup-lv_root 36G 27G 6.8G 80% / tmpfs 16G 276M 16G 2% /dev/shm /dev/sda1 485M 59M 402M 13% /boot /dev/mapper/vg01-jv01 32G 18G 13G 58% /jv01 /dev/mapper/vg02-rman 197G 17G 171G 9% /rman vmuttora1(mesutt):/home/oracle> The disk is not showing; /external_usb/ not mounted. Let s mount it and give oracle user permission to write on it. [root@vmuttora1 external_usb]#
I/O error [message #476408] Thu, 23 September 2010 02:40 sferreira72 Messages: 8Registered: September 2010 Junior Member Our database seems to work ok (we http://www.orafaq.com/forum/t/161778/ can stop, start, query, populate it) but when we try to alter a tablespace we get the following scary error message. Disk space is ok. Server has been rebooted without problem. Help would appreciate! --- ALTER DATABASE DATAFILE '/home/oracle/app/oracle/product/11.1.0/db_1/dbs/sde.dbf' RESIZE 4614912K Error at line 2 ORA-01237: cannot extend datafile 5 ORA-01110: data file 5: '/home/oracle/app/oracle/product/11.1.0/db_1/dbs/sde.dbf' ORA-19502: i/o error write error on file "/home/oracle/app/oracle/product/11.1.0/db_1/dbs/sde.dbf", block number 454912 (block size=8192) ORA-27072: File I/O error Additional information: 4 Additional information: 454912 Additional information: 962560 Report message to a moderator Re: ORA-27072: File I/O error [message #476415 is a reply to message #476408] Thu, 23 September 2010 03:32 Michel Cadot Messages: 63912Registered: March 2007 Location: Nanterre, file i/o error France, http://... Senior MemberAccount Moderator Most likely there is no space available on your file system. Regards Michel Report message to a moderator Re: ORA-27072: File I/O error [message #476417 is a reply to message #476415] Thu, 23 September 2010 03:47 sferreira72 Messages: 8Registered: September 2010 Junior Member I was pretty sure that was not the issue. I rechecked and... @#$!! you are right! Problem solved. Thanks. Report message to a moderator Previous Topic: Instance name on imaged server Next Topic: Splitting partitions Goto Forum: - SQL & PL/SQLSQL & PL/SQLClient Tools- RDBMS ServerServer AdministrationBackup & RecoveryPerformance TuningSecurityNetworking and GatewaysEnterprise ManagerServer Utilities- Server OptionsRAC & FailsafeData GuardReplicationStreams & AQSpatialText & interMedia- Developer & ProgrammerApplication Express, ORDS & MOD_PLSQLFormsReports & DiscovererDesignerJDeveloper, Java & XMLWarehouse BuilderPrecompilers, OCI & OCCI- Fusion Middleware & Colab SuiteWeblogic & Application ServerBusiness IntelligenceWebCenter Suite & PortalCollaboration & Content ManagementSOA Suite, BPEL and OWSM- ApplicationsOracle Fusion Apps & E-Business SuitePeopleSoft, JD Edwards & SiebelPrimaveraOther Application Suites- InfrastructureHardwareUnix