ORA-09817小记

今天登陆测试库时报ORA-09817错误，查了下原来是操作系统没空间了..囧

过程记录如下：

 

oracle@wimngNB_test:~ $ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Thu Feb 23 09:55:22 2012

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

SQL> conn / as sysdba
ERROR:
ORA-09817: Write to audit file failed.
Linux Error: 28: No space left on device
Additional information: 12
ORA-01075: you are currently logged on

SQL> show user

USER is ""

SQL> exit

bash-2.05$ oerr ora 09817
09817, 00000, "Write to audit file failed."
// *Cause:  ORACLE was unable to write an entry to the file used as the
//          audit trail.
// *Action: Check the UNIX error number for a possible operating system error.
//          If there is no error, contact Oracle Support Services.
bash-2.05$

 

oracle@wimngNB_test:~ $df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sdc1              15G   15G     0 100% /
/dev/sda1              99M   14M   80M  15% /boot
/dev/sdb1              60G   53G  4.5G  93% /data
none                  7.0G  1.4G  5.7G  19% /dev/shm

 

到闪回区，删除部分归档日志，让系统暂时可用

oracle@wimngNB_test:/orasys/flash_recovery_area/WIMNG2/archivelog $ ls
2012_01_20  2012_01_24  2012_01_28  2012_02_09  2012_02_13  2012_02_17  2012_02_21
2012_01_21  2012_01_25  2012_01_29  2012_02_10  2012_02_14  2012_02_18  2012_02_22
2012_01_22  2012_01_26  2012_01_30  2012_02_11  2012_02_15  2012_02_19  2012_02_23
2012_01_23  2012_01_27  2012_02_08  2012_02_12  2012_02_16  2012_02_20

oracle@wimngNB_test:/orasys/flash_recovery_area/WIMNG2/archivelog $rm -rf 2012_01_20
oracle@wimngNB_test:/orasys/flash_recovery_area/WIMNG2/archivelog $rm -rf 2012_01_24

oracle@wimngNB_test:/orasys/flash_recovery_area/WIMNG2/archivelog $ df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sdc1              15G   14G  191M  99% /
/dev/sda1              99M   14M   80M  15% /boot
/dev/sdb1              60G   53G  4.5G  93% /data
none                  7.0G  1.4G  5.7G  19% /dev/shm

oracle@wimngNB_test:/orasys/flash_recovery_area/WIMNG2/archivelog $ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Thu Feb 23 10:01:17 2012

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

SQL> conn / as sysdba
Connected.

SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

SQL>