ARC0 Encountered disk IO error 19502

一个二级客户的一个备份库,所以平时没怎么关注,今天去处理ntpdbug的时候想到顺便看看oracle运行情况,结果一看告警日志一大堆错误信息,显示归档进程无法完成:
Fri Jun 22 22:00:22 CST 2012
ARC0: Encountered disk I/O error 19502
Fri Jun 22 22:00:22 CST 2012
ARC0: Closing local archive destination LOG_ARCHIVE_DEST_1: '/u01/oracle/10g/arch/1_507_780753325.dbf' (error 19502)
 (<ORACLE-SID>)
Fri Jun 22 22:00:22 CST 2012
Errors in file /u01/oracle/10g/admin/<ORACLE-SID>/bdump/<ORACLE-SID>_arc0_28109.trc:
ORA-19502: Message 19502 not found; No message file for product=RDBMS, facility=ORA; arguments: [/u01/oracle/10g/arch/1_507_780753325.dbf] [376833] [512]
ORA-27072: Message 27072 not found; No message file for product=RDBMS, facility=ORA
Linux-x86_64 Error: 9: Bad file descriptor
Additional information: 4
Additional information: 376833
Additional information: 581120
ORA-19502: Message 19502 not found; No message file for product=RDBMS, facility=ORA; arguments: [/u01/oracle/10g/arch/1_507_780753325.dbf] [376833] [512]
Fri Jun 22 22:00:22 CST 2012
Errors in file /u01/oracle/10g/admin/<ORACLE-SID>/bdump/<ORACLE-SID>_arc0_28109.trc:
ORA-19502: Message 19502 not found; No message file for product=RDBMS, facility=ORA; arguments: [/u01/oracle/10g/arch/1_507_780753325.dbf] [376833] [512]
ORA-27072: Message 27072 not found; No message file for product=RDBMS, facility=ORA
Linux-x86_64 Error: 9: Bad file descriptor
Additional information: 4
Additional information: 376833
Additional information: 581120
ORA-19502: Message 19502 not found; No message file for product=RDBMS, facility=ORA; arguments: [/u01/oracle/10g/arch/1_507_780753325.dbf] [376833] [512]
ARC0: I/O error 19502 archiving log 3 to '/u01/oracle/10g/arch/1_507_780753325.dbf'
ARCH: Archival stopped, error occurred. Will continue retrying
Fri Jun 22 22:00:22 CST 2012
ORACLE Instance <ORACLE-SID> - Archival Error
Fri Jun 22 22:00:22 CST 2012
ORA-16038: Message 16038 not found; No message file for product=RDBMS, facility=ORA; arguments: [3] [507]
ORA-19502: Message 19502 not found; No message file for product=RDBMS, facility=ORA
ORA-00312: Message 312 not found; No message file for product=RDBMS, facility=ORA; arguments: [3] [1] [/u01/oracle/10g/oradata/<ORACLE-SID>/redo03.log]
Fri Jun 22 22:00:22 CST 2012
Errors in file /u01/oracle/10g/admin/<ORACLE-SID>/bdump/<ORACLE-SID>_arc0_28109.trc:
ORA-16038: Message 16038 not found; No message file for product=RDBMS, facility=ORA; arguments: [3] [507]
ORA-19502: Message 19502 not found; No message file for product=RDBMS, facility=ORA
ORA-00312: Message 312 not found; No message file for product=RDBMS, facility=ORA; arguments: [3] [1] [/u01/oracle/10g/oradata/<ORACLE-SID>/redo03.log]
Fri Jun 22 22:00:26 CST 2012
ARCH: Archival stopped, error occurred. Will continue retrying
Fri Jun 22 22:00:26 CST 2012
ORACLE Instance <ORACLE-SID> - Archival Error
Fri Jun 22 22:00:26 CST 2012
ORA-16014: Message 16014 not found; No message file for product=RDBMS, facility=ORA; arguments: [3] [507]
ORA-00312: Message 312 not found; No message file for product=RDBMS, facility=ORA; arguments: [3] [1] [/u01/oracle/10g/oradata/<ORACLE-SID>/redo03.log]
Fri Jun 22 22:00:26 CST 2012
Errors in file /u01/oracle/10g/admin/<ORACLE-SID>/bdump/<ORACLE-SID>_arc1_28111.trc:
ORA-16014: Message 16014 not found; No message file for product=RDBMS, facility=ORA; arguments: [3] [507]
ORA-00312: Message 312 not found; No message file for product=RDBMS, facility=ORA; arguments: [3] [1] [/u01/oracle/10g/oradata/<ORACLE-SID>/redo03.log]

重要信息在:Linux-x86_64 Error: 9: Bad file descriptor,这个是操作系统的异常错误,马上想到了磁盘空间,果然空间不够了:
[oracle@oradbbak bdump]$ df -h
文件系统              容量  已用 可用 已用% 挂载点
/dev/cciss/c0d0p2     128G  121G     0 100% /
/dev/cciss/c0d0p1     193M   22M  162M  12% /boot
tmpfs                 7.9G     0  7.9G   0% /dev/shm

这个备库本来就没必要开启归档,将其关闭即可:
SQL> shutdown immediate;
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area 1610612736 bytes
Fixed Size            2096632 bytes
Variable Size          805306888 bytes
Database Buffers      788529152 bytes
Redo Buffers           14680064 bytes
Database mounted.

SQL> alter database noarchivelog;

Database altered.

SQL> alter database open;

Database altered.

SQL> archive log list;
Database log mode           No Archive Mode
Automatic archival           Disabled
Archive destination           /u01/oracle/10g/arch
Oldest online log sequence     514
Current log sequence           516
并将其归档文件删除。
-The End-


  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值