ORACLE Instance rac1 - Archival Error
ORA-16038: log 2 sequence# 98 cannot be archived
ORA-19502: write error on file "", block number (block size=)
ORA-00312: online log 2 thread 1: '+DATA1/rac/onlinelog/group_2.262.761070195'
ORA-00312: online log 2 thread 1: '+DATA2/rac/onlinelog/group_2.258.761070195'
Errors in file /opt/rac/oracle/diag/rdbms/rac/rac1/trace/rac1_arc1_18931.trc:
发现存储空间不足了：
oracle@rac1:/home/oracle>df -h
文件系统 容量 已用 可用 已用% 挂载点
/dev/sda3 21G 20G 9.9M 100% /
/dev/sda1 190M 12M 169M 7% /boot
tmpfs 2.0G 1.2G 842M 58% /dev/shm
/dev/sdb1 5.0G 2.5G 2.3G 53% /home/oracle/tmp
使用rman 删除过期的日志：
oracle@rac1:/opt/rac/oracle/arch>rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Sun Sep 11 20:20:45 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: RAC (DBID=2349052205)
RMAN> crosscheck archivelog all;
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=74 instance=rac1 device type=DISK
validation failed for archived log
archived log file name=/opt/rac/oracle/arch/1_17_761070192.dbf RECID=1 STAMP=761306112
validation failed for archived log
archived log file name=/opt/rac/oracle/arch/1_18_761070192.dbf RECID=6 STAMP=761311351
validation failed for archived log
。。。。。。
205 2 68 X 11-SEP-11
Name: /opt/rac/oracle/arch/2_68_761070192.dbf
206 2 69 X 11-SEP-11
Name: /opt/rac/oracle/arch/2_69_761070192.dbf
Do you really want to delete the above objects (enter YES or NO)? yes
deleted archived log
archived log file name=/opt/rac/oracle/arch/1_17_761070192.dbf RECID=1 STAMP=761306112
deleted archived log
archived log file name=/opt/rac/oracle/arch/1_18_761070192.dbf RECID=6 STAMP=761311351
deleted archived log
archived log file name=/opt/rac/oracle/arch/1_19_761070192.dbf RECID=8 STAMP=761312078
。。。。。。。。。。。。。。
archived log file name=/opt/rac/oracle/arch/2_65_761070192.dbf RECID=197 STAMP=761594829
deleted archived log
archived log file name=/opt/rac/oracle/arch/2_66_761070192.dbf RECID=201 STAMP=761597071
deleted archived log
archived log file name=/opt/rac/oracle/arch/2_67_761070192.dbf RECID=204 STAMP=761597191
deleted archived log
archived log file name=/opt/rac/oracle/arch/2_68_761070192.dbf RECID=205 STAMP=761599326
deleted archived log
archived log file name=/opt/rac/oracle/arch/2_69_761070192.dbf RECID=206 STAMP=761599875
Deleted 120 EXPIRED objects
RMAN> exit
Recovery Manager complete.
oracle@rac1:/opt/rac/oracle/arch>df -h
文件系统 容量 已用 可用 已用% 挂载点
/dev/sda3 21G 19G 849M 96% /
/dev/sda1 190M 12M 169M 7% /boot
tmpfs 2.0G 1.2G 842M 58% /dev/shm
/dev/sdb1 5.0G 2.5G 2.3G 53% /home/oracle/tmp
oracle@rac1:/opt/rac/oracle/arch>sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.1.0 Production on Sun Sep 11 19:30:52 2011
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /opt/rac/oracle/arch
Oldest online log sequence 98
Next log sequence to archive 98
Current log sequence 99
SQL> alter system switch logfile;
System altered.
SQL> exit
