一个二级客户的一个备份库,所以平时没怎么关注,今天去处理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-
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-