【oracle】ORA-16038: log 2 sequence# 98 cannot be archived

楊奇龍發表於2011-09-11
OracleHive
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

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/22664653/viewspace-707190/，如需轉載，請註明出處，否則將追究法律責任。

相關文章