1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
|
ORA-16038: log 5 sequence# 5477 cannot be archived
ORA-19502: write error on file "", block number (block size=)
ORA-00312: online log 5 thread 1: '/oracle/oradata/PORTALOA/redo05.log'
ORA-00312: online log 5 thread 1: '/oracle/oradata/PORTALOA/redo05_b.log'
Tue Dec 25 09:34:12 2012
ARCH: Archival stopped, error occurred. Will continue retrying
ORACLE Instance PORTALOA - Archival Error
ORA-16014: log 5 sequence# 5477 not archived, no available destinations
ORA-00312: online log 5 thread 1: '/oracle/oradata/PORTALOA/redo05.log'
ORA-00312: online log 5 thread 1: '/oracle/oradata/PORTALOA/redo05_b.log'
Tue Dec 25 09:39:12 2012
ARCH: Archival stopped, error occurred. Will continue retrying
ORACLE Instance PORTALOA - Archival Error
ORA-16038: log 5 sequence# 5477 cannot be archived
ORA-19502: write error on file "", block number (block size=)
ORA-00312: online log 5 thread 1: '/oracle/oradata/PORTALOA/redo05.log'
ORA-00312: online log 5 thread 1: '/oracle/oradata/PORTALOA/redo05_b.log'
Tue Dec 25 09:39:12 2012
ARC0: LGWR is actively archiving destination LOG_ARCHIVE_DEST_2
ARCH: Archival stopped, error occurred. Will continue retrying
ORACLE Instance PORTALOA - Archival Error
ORA-16014: log 5 sequence# 5477 not archived, no available destinations
ORA-00312: online log 5 thread 1: '/oracle/oradata/PORTALOA/redo05.log'
ORA-00312: online log 5 thread 1: '/oracle/oradata/PORTALOA/redo05_b.log'
|
今天早上 刚刚到公司,就收到邮件,发现Oracle 数据库报警。如上
遇到归档不能归档 Write error 和 Block error 首先应该有如下解决思路:
1、磁盘IO 出故障。
2、归档日志进程所在的在磁盘组磁盘满载。
1
2
3
4
5
6
|
[root@bsportal ~]
# df
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
253G 240G 27M 100% /
/dev/sda1
99M 13M 81M 14%
/boot
tmpfs 4.9G 2.6G 2.4G 53%
/dev/shm
|
解决方法:
1. 清理磁盘
2.手工归档
1
2
3
|
SQL>
alter
system switch logfile;
System altered.
|