Ora-27072 File I/o Error Additional Information 4
Contents |
No Comments Tweet We got the following ora-27072 file i/o error additional information 2 error when backing up an 11.2.0.3 database to an
Ora-19502 Ora-27072 File I/o Error
external disk. RMAN> run 2> { 3> allocate channel d1_disk_backup device type disk
Ora-27072: File I/o Error Linux-x86_64 Error: 5: Input/output Error
; 4> crosscheck backup; 5> backup incremental level 1 cumulative as COMPRESSED BACKUPSET copies=1 tag 'DAILY_BCK' database format '/external_usb/mesutt_daily_%U.bkp'; 6> backup tag '%ARCTAG'
Ora-19502 Write Error On File Blockno (blocksize=8192)
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 device type=DISK ... .... released channel: d1_disk_backup RMAN-00571: rman ora-27072: file i/o error =========================================================== 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]# mount /dev/sde1 /external_usb/ [root@vmuttora1 external_usb]# chown oracle:dba /external_usb/ [root@vmuttora1 external_usb]# df -h Filesystem Size Used
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 linux-x86_64 error: 25: inappropriate ioctl for device type your message and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database ora-27072: skgfdisp: i/o error Discussions This discussion is archived 10 Replies Latest reply on Apr 28, 2010 12:01 PM by user8211869 ORA-27072: File I/O error ora-27072: file i/o error linux-x86_64 error: 9: bad file descriptor Additional information: 2 dsmoljanovic Feb 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 http://www.oracle-class.com/?p=3162 to time. Anyone knows anything about this? We are running aix 5.3. Could this have anything to do with aioservers? 34911Views 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 https://community.oracle.com/thread/624079 be due to a corrupted datafile... Like Show 0 Likes(0) 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 hit
nothing to do with your database, its just a space https://access.redhat.com/solutions/463103 issue with the OS..by the way I was taking backup on Linux RHEL4..Solution:use linux command df -k i/o error to see where at the OS level is space is been eaten up ..as in my case my /opt was 99% full... i just cleaned the unneccesary files , freed up space..by using the file i/o error command rm -rf (this command must never be used unless absolutely needed..double care should be taken while working on Prodcuction).. and then took the backup....this time backup worked absolutely fine....BTW the rman block I used for simple backup...run{allocate channel diskchan device type disk;configure controlfile autobackup on;configure channel device type disk format '/opt/%U';backup database;backup archivelog all;release channel diskchan;};where diskchan is the diskname..... Posted by Kartik at 11:51 AM No comments: Post a Comment Home Subscribe to: Post Comments (Atom) Followers Blog Archive ▼ 2010 (1) ▼ May (1) ORA-27072: File I/O error Additional information About Me Kartik View my complete profile
Red Hat Certificate System Red Hat Satellite Subscription Asset Manager Red Hat Update Infrastructure Red Hat Insights Ansible Tower by Red Hat Cloud Computing Back Red Hat CloudForms Red Hat OpenStack Platform Red Hat Cloud Infrastructure Red Hat Cloud Suite Red Hat OpenShift Container Platform Red Hat OpenShift Online Red Hat OpenShift Dedicated Storage Back Red Hat Gluster Storage Red Hat Ceph Storage JBoss Development and Management Back Red Hat JBoss Enterprise Application Platform Red Hat JBoss Data Grid Red Hat JBoss Web Server Red Hat JBoss Portal Red Hat JBoss Operations Network Red Hat JBoss Developer Studio JBoss Integration and Automation Back Red Hat JBoss Data Virtualization Red Hat JBoss Fuse Red Hat JBoss A-MQ Red Hat JBoss BPM Suite Red Hat JBoss BRMS Mobile Back Red Hat Mobile Application Platform Services Back Consulting Technical Account Management Training & Certifications Red Hat Enterprise Linux Developer Program Support Get Support Production Support Development Support Product Life Cycle & Update Policies Knowledge Search Documentation Knowledgebase Videos Discussions Ecosystem Browse Certified Solutions Overview Partner Resources Tools Back Red Hat Insights Learn More Red Hat Access Labs Explore Labs Configuration Deployment Troubleshooting Security Additional Tools Red Hat Access plug-ins Red Hat Satellite Certificate Tool Security Back Product Security Center Security Updates Security Advisories Red Hat CVE Database Security Labs Resources Overview Security Blog Security Measurement Severity Ratings Backporting Policies Product Signing (GPG) Keys Community Back Discussions Red Hat Enterprise Linux Red Hat Virtualization Red Hat Satellite Customer Portal Private Groups All Discussions Start a Discussion Blogs Customer Portal Red Hat Product Security Red Hat Access Labs Red Hat Insights All Blogs Events Customer Events Red Hat Summit Stories Red Hat Subscription Benefits You Asked. We Acted. Open Source Communities Subscriptions Downloads Support Cases Account Back Log In Register Red Hat Account Number: Account Details Newsletter and Contact Preferences User Management Account Maintenance My Profile Notifications Help Log Out Language Back English español Deutsch italiano 한국어 français 日本語 português 中文 (中国) русский Customer Portal Search Products & Services Back View All Products Infrastructure and Management Back Red Hat Enterprise Linux Red Hat Virtualization Red Hat Identity Management Red Hat Directory Server Red Hat Certificate System Red Hat Satellite Subscription Asset Manager Red Hat Update Infrastructure Red Hat Insights Ansible Tower by Red Hat Cloud Computing Back