Ora-27072 Skgfdisp I/o Error Rman
Contents |
No Comments Tweet We got the following error when backing up an 11.2.0.3 rman ora-27072: file i/o error database to an external disk. RMAN> run 2> { 3> allocate
Ora-27072: File I/o Error Linux-x86_64 Error: 9: Bad File Descriptor
channel d1_disk_backup device type disk ; 4> crosscheck backup; 5> backup incremental level 1 cumulative
Ora-19501: Read Error On File
as COMPRESSED BACKUPSET copies=1 tag 'DAILY_BCK' database 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 http://dbaforums.org/oracle/index.php?showtopic=21429 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-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of backup command on d1_disk_backup channel at http://www.oracle-class.com/?p=3162 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 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 /dev/sde1 1.8T 74G 1.7T 5% /exter
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project https://www.experts-exchange.com/questions/20075060/ORA-27072-skgfdisp-I-O-error.html Hire for a Full Time Job Ways to Get Help Expand Search Submit http://kb.dbatoolz.com/tp/4530.io_error_for_database_file_.html Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > ORA-27072: skgfdisp: I/O error Want to Advertise Here? Solved ORA-27072: skgfdisp: I/O error Posted on 2001-02-09 Oracle Database 1 Verified Solution 7 Comments 8,926 Views Last Modified: i/o error 2012-08-13 Hi, a friend of mine has a problem. ORACLE V8.1.5.0.0 - Production vsnsta=0 vsnsql=d vsnxtr=3 Windows NT V4.0, OS V5.101, CPU type 586 Starting up ORACLE RDBMS Version: 8.1.5.0.0. .... Errors in file d:\Oracle\admin\orcl\bdump\orclLGWR.TRC: ORA-01110: data file 9: 'E:\ORACLE\ORADATA\ORCL\DF_PER_LARGE1' ORA-01114: IO error writing block to file 9 (block # 1) ORA-27072: skgfdisp: I/O error OSD-04008: WriteFile() failure, unable to write to file file i/o error O/S-Error: (OS 5) Access is denied. Drive E: is a NTFS partition and the size of the datafile should be ~20 GB. 0 Question by:Hauke Facebook Twitter LinkedIn Google LVL 1 Best Solution byMoondancer Zero response to my Jun 5th request. 200 points charged, item moved to our PAQ at zero points and closed. Thanks for your help here, Dan. Moondancer - EE Moderator Go to Solution 7 Comments LVL 4 Overall: Level 4 Oracle Database 4 Message Expert Comment by:srikant0331002001-02-09 This error seems have cause because there is not enough space left on the specified disk or there is no write permision on the specified file Cheers Srikant 0 Message Expert Comment by:yujk2001-02-09 I would suggest first checking to make sure that there are not any hardware errors on the disk level. Next, check to make sure that there are no logical filesystem errors. Check to see that it is not a space issue and also make sure that the datafile is not corrupt. If all this checks out, it may be a security issue. Good luck 0 LVL 1 Ove
community › Ask DBA › Question Id: 4530 | Permalink I/O error for database file Question ID: 4530 Created By: 2011-DEC-19 10:38:30 [Kurapatiram] Updated By: 2011-DEC-21 23:05:37 [Kurapatiram] Status: Open Severity: Normal Read Only: No 14600 2011-DEC-19 10:38:30 Kurapatiram User Registered On: Jun 2011 Total Posts: 6 Hi After connecting to RMAN catalog database when I say "resync catalog", throwing the below error. RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of configure command at 12/19/2011 10:52:27 RMAN-03014: implicit resync of recovery catalog failed RMAN-03009: failure of full resync command on default channel at 12/19/2011 10:52:27 ORA-01115: IO error reading block from file 5 (block # 497) ORA-01110: data file 5: '/u08/oradata/RMAN/data/users01.dbf' ORA-27091: skgfqio: unable to queue I/O ORA-27072: skgfdisp: I/O error NOTE: Able to access the database and bounce the database also nothing is there in alert log any ideas on how to resolve this pls ? OS: AIX Database: 10g 14607 2011-DEC-20 12:39:01 Vitaliy Moderator Registered On: Mar 2006 Total Posts: 347 When you say you are able to connect to the database and bounce it are you connecting to the TARGET or CATALOG database? I think your issue is with the CATALOG (RMAN) database. -HTH 14613 2011-DEC-21 23:05:37 Kurapatiram User Registered On: Jun 2011 Total Posts: 6 > When you say you are able to connect to the database and bounce it are you > connecting to the TARGET or CATALOG database? I think your issue is with > the CATALOG (RMAN) database. > > -HTH Thanks for your reply and the problem is with OS I/O not with the database and we need to change some maxservers using aiio command. now its resolved ta Permalink Copyright© 1998-2016 dbatoolz All rights reserved | Powered by hashjoin.com | Sitemap