程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 數據庫知識 >> Oracle數據庫 >> Oracle教程 >> RMAN備份失敗: ORA-19502 & ORA-27072: File I/O error,rmanora-19502

RMAN備份失敗: ORA-19502 & ORA-27072: File I/O error,rmanora-19502

編輯:Oracle教程

RMAN備份失敗: ORA-19502 & ORA-27072: File I/O error,rmanora-19502


早上檢查一ORACLE數據庫的RMAN備份的郵件時,發現出現了ORA-27072: File I/O error等錯誤,具體信息如下所示:

channel ORA_DISK_1: starting piece 1 at 23-MAR-15
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 03/23/2015 03:48:02
ORA-19502: write error on file "/u04/backup/backupsets/ora_df875072537_s15615_s1", blockno 182657 (blocksize=8192)
ORA-27072: File I/O error
Linux-x86_64 Error: 9: Bad file descriptor
Additional information: 4
Additional information: 182657
Additional information: 700416
 
Recovery Manager complete.

 

關於ORA-03002與ORA-27072錯誤的描述,如下所示

[oracle@DB-Server-03 ~]$ oerr ora 19502

19502, 00000, "write error on file \"%s\", blockno %s (blocksize=%s)"

// *Cause: write error on output file

// *Action: check the file

 

[oracle@DB-Server-03 ~]$ oerr ora 27072

27072, 00000, "File I/O error"

// *Cause: read/write/readv/writev system call returned error, additional

// information indicates starting block number of I/O

// *Action: check errno

 

RMAN備份出現這個錯誤是在生成備份集時,文件I/O發生錯誤,因為/u04分區空間不足導致RMAN備份無法寫入數據,我們也收到了磁盤分區告警的郵件。如下所示。

  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved