mysql ora-09925_orache运行时产生非常多的aud文件：ORA-09925

oracle运行的时候产生非常多的aud文件，沾满磁盘空间，然后导致运行的数据库宕机，请各位帮忙看看，错误信息如下：

错误信息：

-bash-3.00$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu Mar 1 20:41:46 2012

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

ERROR:

ORA-09925: Unable to create audit trail file

SVR4 Error: 28: No space left on device

Additional information: 9925

ORA-09925: Unable to create audit trail file

SVR4 Error: 28: No space left on device

Additional information: 9925

告警日志文件信息：

pidcl aborting process unknown ospid (15611) as a result of ORA-9925

OS Audit file could not be created; failing after 5 retries

opidcl aborting process unknown ospid (15613) as a result of ORA-9925

OS Audit file could not be created; failing after 5 retries

opidcl aborting process unknown ospid (15615) as a result of ORA-9925

Retry Iteration No: 5   OS Error: 28

Retry Iteration No: 2   OS Error: 28

Retry Iteration No: 3   OS Error: 28

OS Audit file could not be created; failing after 5 retries

opidcl aborting process unknown ospid (15621) as a result of ORA-9925

Retry Iteration No: 4   OS Error: 28

Retry Iteration No: 2   OS Error: 28

Retry Iteration No: 5   OS Error: 28

Thu Mar 01 18:14:21 2012

Could not open audit file: /u01/app/oracle/admin/uniondb/adump/uniondb_ora_15652_9b.aud

Retry Iteration No: 1   OS Error: 28

Retry Iteration No: 2   OS Error: 28

OS Audit file could not be created; failing after 5 retries

opidcl aborting process unknown ospid (15627) as a result of ORA-9925

Thu Mar 01 18:14:21 2012

Could not open audit file: /u01/app/oracle/admin/uniondb/adump/uniondb_ora_15658_a1.aud

Retry Iteration No: 1   OS Error: 28

Retry Iteration No: 3   OS Error: 28

Retry Iteration No: 4   OS Error: 28

Retry Iteration No: 5   OS Error: 28

Retry Iteration No: 3   OS Error: 28

OS Audit file could not be created; failing after 5 retries

opidcl aborting process unknown ospid (15631) as a result of ORA-9925

Retry Iteration No: 2   OS Error: 28

Retry Iteration No: 3   OS Error: 28

Retry Iteration No: 2   OS Error: 28

Retry Iteration No: 4   OS Error: 28

Retry Iteration No: 5   OS Error: 28

OS Audit file could not be created; failing after 5 retries

opidcl aborting process unknown ospid (15635) as a result of ORA-9925

Retry Iteration No: 4   OS Error: 28

Retry Iteration No: 3   OS Error: 28

Retry Iteration No: 4   OS Error: 28

Retry Iteration No: 3   OS Error: 28

Retry Iteration No: 5   OS Error: 28

OS Audit file could not be created; failing after 5 retries

opidcl aborting process unknown ospid (15619) as a result of ORA-9925

Retry Iteration No: 5   OS Error: 28

Thu Mar 01 18:14:23 2012

Could not open audit file: /u01/app/oracle/admin/uniondb/adump/uniondb_ora_15664_9d.aud

Retry Iteration No: 1   OS Error: 28

Thu Mar 01 18:14:23 2012

Could not open audit file: /u01/app/oracle/admin/uniondb/adump/uniondb_ora_15666_a0.aud

Retry Iteration No: 1   OS Error: 28

Retry Iteration No: 4   OS Error: 28

Retry Iteration No: 5   OS Error: 28

Retry Iteration No: 4   OS Error: 28

OS Audit file could not be created; failing after 5 retries

opidcl aborting process unknown ospid (15644) as a result of ORA-9925

OS Audit file could not be created; failing after 5 retries

opidcl aborting process unknown ospid (15650) as a result of ORA-9925

Retry Iteration No: 2   OS Error: 28

Retry Iteration No: 2   OS Error: 28

Retry Iteration No: 5   OS Error: 28

OS Audit file could not be created; failing after 5 retries

opidcl aborting process unknown ospid (15646) as a result of ORA-9925

Retry Iteration No: 5   OS Error: 28

Thu Mar 01 18:14:25 2012

Could not open audit file: /u01/app/oracle/admin/uniondb/adump/uniondb_ora_15679_ac.aud

Retry Iteration No: 1   OS Error: 28

Retry Iteration No: 3   OS Error: 28

Retry Iteration No: 3   OS Error: 28

OS Audit file could not be created; failing after 5 retries

opidcl aborting process unknown ospid (15652) as a result of ORA-9925

Thu Mar 01 18:14:26 2012

Could not open audit file: /u01/app/oracle/admin/uniondb/adump/uniondb_ora_15685_ac.aud

Retry Iteration No: 1   OS Error: 28

Thu Mar 01 18:14:26 2012

Could not open audit file: /u01/app/oracle/admin/uniondb/adump/uniondb_ora_15689_99.aud

Retry Iteration No: 1   OS Error: 28

OS Audit file could not be created; failing after 5 retries

opidcl aborting process unknown ospid (15658) as a result of ORA-9925

Retry Iteration No: 2   OS Error: 28

Retry Iteration No: 4   OS Error: 28

Retry Iteration No: 4   OS Error: 28

Retry Iteration No: 2   OS Error: 28

Thu Mar 01 18:14:27 2012

Could not open audit file: /u01/app/oracle/admin/uniondb/adump/uniondb_ora_15693_9d.aud

Retry Iteration No: 1   OS Error: 28

Retry Iteration No: 2   OS Error: 28

Retry Iteration No: 3   OS Error: 28

Retry Iteration No: 5   OS Error: 28

Retry Iteration No: 5   OS Error: 28

Retry Iteration No: 3   OS Error: 28

Retry Iteration No: 2   OS Error: 28

Retry Iteration No: 3   OS Error: 28

Retry Iteration No: 4   OS Error: 28

OS Audit file could not be created; failing after 5 retries

opidcl aborting process unknown ospid (15664) as a result of ORA-9925

OS Audit file could not be created; failing after 5 retries

opidcl aborting process unknown ospid (15666) as a result of ORA-9925

Thu Mar 01 18:14:29 2012

Could not open audit file: /u01/app/oracle/admin/uniondb/adump/uniondb_ora_15697_a1.aud

Retry Iteration No: 1   OS Error: 28

Thu Mar 01 18:14:29 2012

Could not open audit file: /u01/app/oracle/admin/uniondb/adump/uniondb_ora_15699_9b.aud

Retry Iteration No: 1   OS Error: 28

Retry Iteration No: 4   OS Error: 28

Thu Mar 01 18:14:29 2012

Could not open audit file: /u01/app/oracle/admin/uniondb/adump/uniondb_ora_15701_a5.aud

Retry Iteration No: 1   OS Error: 28

Retry Iteration No: 3   OS Error: 28

Retry Iteration No: 4   OS Error: 28

Retry Iteration No: 5   OS Error: 28

Retry Iteration No: 2   OS Error: 28

Retry Iteration No: 2   OS Error: 28

Retry Iteration No: 5   OS Error: 28

Retry Iteration No: 2   OS Error: 28

Retry Iteration No: 4   OS Error: 28

Retry Iteration No: 5   OS Error: 28

OS Audit file could not be created; failing after 5 retries

opidcl aborting process unknown ospid (15679) as a result of ORA-9925

Thu Mar 01 18:14:30 2012

Could not open audit file: /u01/app/oracle/admin/uniondb/adump/uniondb_ora_15707_a1.aud

Retry Iteration No: 1   OS Error: 28

Retry Iteration No: 3   OS Error: 28

Retry Iteration No: 3   OS Error: 28

OS Audit file could not be created; failing after 5 retries

opidcl aborting process unknown ospid (15685) as a result of ORA-9925

Retry Iteration No: 3   OS Error: 28

Retry Iteration No: 5   OS Error: 28

OS Audit file could not be created; failing after 5 retries

opidcl aborting process unknown ospid (15689) as a result of ORA-9925

Retry Iteration No: 2   OS Error: 28

Retry Iteration No: 4   OS Error: 28

Retry Iteration No: 4   OS Error: 28

Retry Iteration No: 4   OS Error: 28

OS Audit file could not be created; failing after 5 retries

opidcl aborting process unknown ospid (15693) as a result of ORA-9925

Thu Mar 01 18:14:32 2012

Could not open audit file: /u01/app/oracle/admin/uniondb/adump/uniondb_ora_15713_a9.aud

Retry Iteration No: 1   OS Error: 28

Retry Iteration No: 3   OS Error: 28

Retry Iteration No: 5   OS Error: 28

Retry Iteration No: 5   OS Error: 28

Retry Iteration No: 5   OS Error: 28

Retry Iteration No: 2   OS Error: 28

Retry Iteration No: 4   OS Error: 28

OS Audit file could not be created; failing after 5 retries

opidcl aborting process unknown ospid (15697) as a result of ORA-9925

OS Audit file could not be created; failing after 5 retries

opidcl aborting process unknown ospid (15699) as a result of ORA-9925

Thu Mar 01 18:14:34 2012

Could not open audit file: /u01/app/oracle/admin/uniondb/adump/uniondb_ora_15723_a8.aud

Retry Iteration No: 1   OS Error: 28

OS Audit file could not be created; failing after 5 retries

opidcl aborting process unknown ospid (15701) as a result of ORA-9925

Retry Iteration No: 3   OS Error: 28

Retry Iteration No: 5   OS Error: 28

Retry Iteration No: 2   OS Error: 28

Retry Iteration No: 4   OS Error: 28

Thu Mar 01 18:14:35 2012

Could not open audit file: /u01/app/oracle/admin/uniondb/adump/uniondb_ora_15731_bb.aud

Retry Iteration No: 1   OS Error: 28

OS Audit file could not be created; failing after 5 retries

opidcl aborting process unknown ospid (15707) as a result of ORA-9925

Thu Mar 01 18:14:36 2012

Could not open audit file: /u01/app/oracle/admin/uniondb/adump/uniondb_ora_15733_ae.aud

Retry Iteration No: 1   OS Error: 28

Retry Iteration No: 3   OS Error: 28

Thu Mar 01 18:14:36 2012

Could not open audit file: /u01/app/oracle/admin/uniondb/adump/uniondb_ora_15735_c4.aud

Retry Iteration No: 1   OS Error: 28

Retry Iteration No: 5   OS Error: 28

Retry Iteration No: 2   OS Error: 28

Retry Iteration No: 2   OS Error: 28

Retry Iteration No: 4   OS Error: 28

Retry Iteration No: 2   OS Error: 28

OS Audit file could not be created; failing after 5 retries

opidcl aborting process unknown ospid (15713) as a result of ORA-9925

Retry Iteration No: 3   OS Error: 28

Thu Mar 01 18:14:37 2012

Could not open audit file: /u01/app/oracle/admin/uniondb/adump/uniondb_ora_15741_a9.aud

Retry Iteration No: 1   OS Error: 28

Retry Iteration No: 3   OS Error: 28

Retry Iteration No: 5   OS Error: 28

Retry Iteration No: 3   OS Error: 28

Retry Iteration No: 4   OS Error: 28

Thu Mar 01 18:14:38 2012

Could not open audit file: /u01/app/oracle/admin/uniondb/adump/uniondb_ora_15745_aa.aud

Retry Iteration No: 1   OS Error: 28

Retry Iteration No: 2   OS Error: 28

Retry Iteration No: 4   OS Error: 28

OS Audit file could not be created; failing after 5 retries

opidcl aborting process unknown ospid (15723) as a result of ORA-9925

Retry Iteration No: 4   OS Error: 28

Thu Mar 01 18:14:39 2012

Could not open audit file: /u01/app/oracle/admin/uniondb/adump/uniondb_ora_15749_b0.aud

Retry Iteration No: 1   OS Error: 28

Retry Iteration No: 5   OS Error: 28

Retry Iteration No: 2   OS Error: 28

Retry Iteration No: 3   OS Error: 28

Retry Iteration No: 5   OS Error: 28

Retry Iteration No: 5   OS Error: 28

Thu Mar 01 18:14:40 2012

Could not open audit file: /u01/app/oracle/admin/uniondb/adump/uniondb_ora_15753_b6.aud

Retry Iteration No: 1   OS Error: 28

Retry Iteration No: 2   OS Error: 28

OS Audit file could not be created; failing after 5 retries

opidcl aborting process unknown ospid (15731) as a result of ORA-9925

Retry Iteration No: 3   OS Error: 28

Retry Iteration No: 4   OS Error: 28

OS Audit file could not be created; failing after 5 retries

opidcl aborting process unknown ospid (15733) as a result of ORA-9925

OS Audit file could not be created; failing after 5 retries

opidcl aborting process unknown ospid (15735) as a result of ORA-9925

Retry Iteration No: 2   OS Error: 28

Retry Iteration No: 3   OS Error: 28

Retry Iteration No: 4   OS Error: 28

Retry Iteration No: 5   OS Error: 28

Retry Iteration No: 3   OS Error: 28

Retry Iteration No: 4   OS Error: 28

Thu Mar 01 18:14:42 2012

Could not open audit file: /u01/app/oracle/admin/uniondb/adump/uniondb_ora_15759_ab.aud

Retry Iteration No: 1   OS Error: 28

Retry Iteration No: 5   OS Error: 28

OS Audit file could not be created; failing after 5 retries

opidcl aborting process unknown ospid (15741) as a result of ORA-9925

Thu Mar 01 18:14:43 2012

Could not open audit file: /u01/app/oracle/admin/uniondb/adump/uniondb_ora_15761_b7.aud

Retry Iteration No: 1   OS Error: 28

Retry Iteration No: 4   OS Error: 28

Retry Iteration No: 5   OS Error: 28

Thu Mar 01 18:14:43 2012

Could not open audit file: /u01/app/oracle/admin/uniondb/adump/uniondb_ora_15765_b2.aud

Retry Iteration No: 1   OS Error: 28

Retry Iteration No: 2   OS Error: 28

OS Audit file could not be created; failing after 5 retries

opidcl aborting process unknown ospid (15745) as a result of ORA-9925

Retry Iteration No: 2   OS Error: 28

Retry Iteration No: 5   OS Error: 28

OS Audit file could not be created; failing after 5 retries

opidcl aborting process unknown ospid (15749) as a result of ORA-9925

Retry Iteration No: 2   OS Error: 28

Retry Iteration No: 3   OS Error: 28

Thu Mar 01 18:14:45 2012

Could not open audit file: /u01/app/oracle/admin/uniondb/adump/uniondb_ora_15769_a8.aud

Retry Iteration No: 1   OS Error: 28

Retry Iteration No: 3   OS Error: 28

OS Audit file could not be created; failing after 5 retries

opidcl aborting process unknown ospid (15753) as a result of ORA-9925

Retry Iteration No: 3   OS Error: 28

Thu Mar 01 18:14:45 2012

Could not open audit file: /u01/app/oracle/admin/uniondb/adump/uniondb_ora_15773_a9.aud

Retry Iteration No: 1   OS Error: 28

Retry Iteration No: 4   OS Error: 28

Retry Iteration No: 2   OS Error: 28

Retry Iteration No: 4   OS Error: 28

Retry Iteration No: 4   OS Error: 28

Retry Iteration No: 2   OS Error: 28

Retry Iteration No: 5   OS Error: 28

Retry Iteration No: 3   OS Error: 28

Thu Mar 01 18:14:47 2012

Could not open audit file: /u01/app/oracle/admin/uniondb/adump/uniondb_ora_15777_ae.aud

Retry Iteration No: 1   OS Error: 28

Retry Iteration No: 5   OS Error: 28

Thu Mar 01 18:14:47 2012

Could not open audit file: /u01/app/oracle/admin/uniondb/adump/uniondb_ora_15779_a8.aud

Retry Iteration No: 1   OS Error: 28

Retry Iteration No: 5   OS Error: 28

Retry Iteration No: 3   OS Error: 28

OS Audit file could not be created; failing after 5 retries

opidcl aborting process unknown ospid (15759) as a result of ORA-9925

Retry Iteration No: 4   OS Error: 28

Retry Iteration No: 2   OS Error: 28

OS Audit file could not be created; failing after 5 retries

opidcl aborting process unknown ospid (15761) as a result of ORA-9925

Retry Iteration No: 2   OS Error: 28

OS Audit file could not be created; failing after 5 retries

opidcl aborting process unknown ospid (15765) as a result of ORA-9925

Retry Iteration No: 4   OS Error: 28

Retry Iteration No: 5   OS Error: 28

Retry Iteration No: 3   OS Error: 28

Thu Mar 01 18:14:49 2012

Could not open audit file: /u01/app/oracle/admin/uniondb/adump/uniondb_ora_15790_ac.aud

Retry Iteration No: 1   OS Error: 28

Retry Iteration No: 3   OS Error: 28

Retry Iteration No: 5   OS Error: 28

OS Audit file could not be created; failing after 5 retries

opidcl aborting process unknown ospid (15769) as a result of ORA-9925

Retry Iteration No: 4   OS Error: 28

Retry Iteration No: 2   OS Error: 28

Retry Iteration No: 4   OS Error: 28

Thu Mar 01 18:14:50 2012

Thread 1 cannot allocate new log, sequence 754538

Private strand flush not complete

Current log# 2 seq# 754537 mem# 0: +DATA/uniondb/onlinelog/group_2.log

Current log# 2 seq# 754537 mem# 1: +FLASH_DG/uniondb/onlinelog/group_2.log

OS Audit file could not be created; failing after 5 retries

opidcl aborting process unknown ospid (15773) as a result of ORA-9925

Retry Iteration No: 5   OS Error: 28

Retry Iteration No: 3   OS Error: 28

Retry Iteration No: 5   OS Error: 28

Thu Mar 01 18:14:51 2012

Could not open audit file: /u01/app/oracle/admin/uniondb/adump/uniondb_ora_15798_bb.aud

Retry Iteration No: 1   OS Error: 28

Thu Mar 01 18:14:51 2012

Could not open audit file: /u01/app/oracle/admin/uniondb/adump/uniondb_ora_15800_ac.aud

Retry Iteration No: 1   OS Error: 28

Thu Mar 01 18:14:52 2012

Could not open audit file: /u01/app/oracle/admin/uniondb/adump/uniondb_ora_15804_a7.aud

Retry Iteration No: 1   OS Error: 28

OS Audit file could not be created; failing after 5 retries

opidcl aborting process unknown ospid (15777) as a result of ORA-9925

Retry Iteration No: 4   OS Error: 28

OS Audit file could not be created; failing after 5 retries

opidcl aborting process unknown ospid (15779) as a result of ORA-9925

Retry Iteration No: 2   OS Error: 28

Retry Iteration No: 2   OS Error: 28

Retry Iteration No: 2   OS Error: 28

Thu Mar 01 18:14:53 2012

Could not open audit file: /u01/app/oracle/admin/uniondb/adump/uniondb_ora_15656_9e.aud

Retry Iteration No: 1   OS Error: 28

Retry Iteration No: 5   OS Error: 28

Retry Iteration No: 3   OS Error: 28

Retry Iteration No: 3   OS Error: 28

Retry Iteration No: 3   OS Error: 28

Retry Iteration No: 2   OS Error: 28

OS Audit file could not be created; failing after 5 retries

opidcl aborting process unknown ospid (15790) as a result of ORA-9925

Retry Iteration No: 4   OS Error: 28

Retry Iteration No: 4   OS Error: 28

Retry Iteration No: 4   OS Error: 28

Retry Iteration No: 3   OS Error: 28

Retry Iteration No: 5   OS Error: 28

Retry Iteration No: 5   OS Error: 28

Retry Iteration No: 5   OS Error: 28

Retry Iteration No: 4   OS Error: 28

OS Audit file could not be created; failing after 5 retries

opidcl aborting process unknown ospid (15798) as a result of ORA-9925

OS Audit file could not be created; failing after 5 retries

opidcl aborting process unknown ospid (15800) as a result of ORA-9925

OS Audit file could not be created; failing after 5 retries

opidcl aborting process unknown ospid (15804) as a result of ORA-9925

Retry Iteration No: 5   OS Error: 28

OS Audit file could not be created; failing after 5 retries

opidcl aborting process unknown ospid (15656) as a result of ORA-9925

Non critical error ORA-00001 caught while writing to trace file "/u01/app/oracle/diag/rdbms/uniondb/uniondb/trace/uniondb_lgwr_19076.trc"

Error message: SVR4 Error: 28: No space left on device

Additional information: 1

Writing to the above trace file is disabled for now on...

ERROR: slave communication error with ASM; terminating process 19076

Errors in file /u01/app/oracle/diag/rdbms/uniondb/uniondb/trace/uniondb_lgwr_19076.trc:

Thu Mar 01 18:14:59 2012

PMON (ospid: 19042): terminating the instance due to error 470

Thu Mar 01 18:15:02 2012

ORA-1092 : opitsk aborting process

Thu Mar 01 18:15:02 2012

Could not open audit file: /u01/app/oracle/admin/uniondb/adump/uniondb_ora_15849_a0.aud

Retry Iteration No: 1   OS Error: 0

Instance terminated by PMON, pid = 19042

License high water mark = 82

Non critical error DIA-00001 caught while writing to trace file "/u01/app/oracle/diag/rdbms/uniondb/uniondb/trace/uniondb_ora_15849.trc"

Error message: SVR4 Error: 28: No space left on device

Additional information: 1

Writing to the above trace file is disabled for now on...

USER (ospid: 15849): terminating the instance

Instance terminated by USER, pid = 15849

Fri Mar 02 09:46:58 2012

Starting ORACLE instance (normal)

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Picked latch-free SCN scheme 3

Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST

Autotune of undo retention is turned on.

IMODE=BR

ILAT =249

LICENSE_MAX_USERS = 0

SYS auditing is disabled

Starting up:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options.

Using parameter settings in server-side pfile /u01/app/oracle/11.2file:///C:/Users/unknsnow/AppData/Local/Temp/ksohtml/wps_clip_image-4185.png_1file:///C:/Users/unknsnow/AppData/Local/Temp/ksohtml/wps_clip_image-24908.pngs/inituniondb.ora

System parameters with non-default values:

processes                = 1500

sessions                 = 2272

spfile                   = "+DATA/uniondb/spfileuniondb.ora"

memory_target            = 26240M

control_files            = "+DATA/uniondb/controlfile/current.270.746630173"

control_files            = "+FLASH_DG/uniondb/controlfile/current.256.746630173"

db_block_size            = 8192

db_writer_processes      = 8

compatible               = "11.2.0.0.0"

db_create_file_dest      = "+DATA"

db_recovery_file_dest    = "+FLASH_DG"

db_recovery_file_dest_size= 3852M

undo_tablespace          = "UNDOTBS1"

remote_login_passwordfile= "EXCLUSIVE"

db_domain                = "com.cn"

dispatchers              = "(PROTOCOL=TCP) (SERVICE=uniondbXDB)"

audit_file_dest          = "/u01/app/oracle/admin/uniondb/adump"

audit_trail              = "DB"

db_name                  = "uniondb"

open_cursors             = 300

diagnostic_dest          = "/u01/app/oracle"

Fri Mar 02 09:47:01 2012

PMON started with pid=2, OS id=17478

Fri Mar 02 09:47:01 2012

VKTM started with pid=3, OS id=17480 at elevated priority

VKTM running at (10)millisec precision with DBRM quantum (100)ms

Fri Mar 02 09:47:01 2012

GEN0 started with pid=4, OS id=17484

Fri Mar 02 09:47:01 2012

DIAG started with pid=5, OS id=17486

Fri Mar 02 09:47:01 2012

DBRM started with pid=6, OS id=17488

Fri Mar 02 09:47:01 2012

PSP0 started with pid=7, OS id=17490

Fri Mar 02 09:47:01 2012

DIA0 started with pid=8, OS id=17492

Fri Mar 02 09:47:01 2012

MMAN started with pid=9, OS id=17494

Fri Mar 02 09:47:01 2012

DBW0 started with pid=10, OS id=17496

Fri Mar 02 09:47:01 2012

DBW1 started with pid=11, OS id=17498

Fri Mar 02 09:47:01 2012

DBW2 started with pid=12, OS id=17500

Fri Mar 02 09:47:01 2012

DBW3 started with pid=13, OS id=17502

Fri Mar 02 09:47:01 2012

DBW4 started with pid=14, OS id=17504

Fri Mar 02 09:47:02 2012

DBW5 started with pid=15, OS id=17506

Fri Mar 02 09:47:02 2012

DBW6 started with pid=16, OS id=17508

Fri Mar 02 09:47:02 2012

DBW7 started with pid=17, OS id=17510

Fri Mar 02 09:47:02 2012

LGWR started with pid=18, OS id=17512

Fri Mar 02 09:47:02 2012

CKPT started with pid=19, OS id=17514

Fri Mar 02 09:47:02 2012

SMON started with pid=20, OS id=17516

Fri Mar 02 09:47:02 2012

RECO started with pid=21, OS id=17518

Fri Mar 02 09:47:02 2012

RBAL started with pid=22, OS id=17520

Fri Mar 02 09:47:02 2012

ASMB started with pid=23, OS id=17522

Fri Mar 02 09:47:02 2012

MMON started with pid=24, OS id=17524

NOTE: initiating MARK startup

Fri Mar 02 09:47:02 2012

MMNL started with pid=25, OS id=17528

Starting background process MARK

starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...

Fri Mar 02 09:47:02 2012

MARK started with pid=26, OS id=17530

NOTE: MARK has subscribed

starting up 1 shared server(s) ...

DISM started, OS id=17540

Fri Mar 02 09:47:21 2012

ORACLE_BASE not set in environment. It is recommended

that ORACLE_BASE be set in the environment

Reusing ORACLE_BASE from an earlier startup = /u01/app/oracle

Fri Mar 02 09:47:21 2012

ALTER DATABASE MOUNT

Fri Mar 02 09:47:22 2012

NOTE: Loaded library: System

Fri Mar 02 09:47:22 2012

SUCCESS: diskgroup DATA was mounted

SUCCESS: diskgroup FLASH_DG was mounted

Fri Mar 02 09:47:22 2012

NOTE: dependency between database uniondb and diskgroup resource ora.DATA.dg is established

NOTE: dependency between database uniondb and diskgroup resource ora.FLASH_DG.dg is established

Fri Mar 02 09:47:26 2012

Successful mount of redo thread 1, with mount id 2950768553

Database mounted in Exclusive Mode

Lost write protection disabled

Completed: ALTER DATABASE MOUNT

ALTER DATABASE OPEN

Beginning crash recovery of 1 threads

parallel recovery started with 31 processes

Started redo scan

Completed redo scan

read 120367 KB redo, 21192 data blocks need recovery

Fri Mar 02 09:47:33 2012

Started redo application at

Thread 1: logseq 754537, block 3457570

Recovery of Online Redo Log: Thread 1 Group 2 Seq 754537 Reading mem 0

Mem# 0: +DATA/uniondb/onlinelog/group_2.log

Mem# 1: +FLASH_DG/uniondb/onlinelog/group_2.log

Completed redo application of 79.27MB

Completed crash recovery at

Thread 1: logseq 754537, block 3698305, scn 3305731147

21192 data blocks read, 21171 data blocks written, 120367 redo k-bytes read

Thread 1 advanced to log sequence 754538 (thread open)

Thread 1 opened at log sequence 754538

Current log# 3 seq# 754538 mem# 0: +DATA/uniondb/onlinelog/group_3.log

Current log# 3 seq# 754538 mem# 1: +FLASH_DG/uniondb/onlinelog/group_3.log

Successful open of redo thread 1

MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set

Fri Mar 02 09:47:35 2012

SMON: enabling cache recovery

Successfully onlined Undo Tablespace 2.

Verifying file header compatibility for 11g tablespace encryption..

Verifying 11g file header compatibility for tablespace encryption completed

SMON: enabling tx recovery

Database Characterset is ZHS16GBK

No Resource Manager plan active

replication_dependency_tracking turned off (no async multimaster replication found)

Starting background process QMNC

Fri Mar 02 09:47:38 2012

QMNC started with pid=67, OS id=17869

Completed: ALTER DATABASE OPEN

Fri Mar 02 09:47:41 2012

db_recovery_file_dest_size of 3852 MB is 0.80% used. This is a

user-specified limit on the amount of space that will be used by this

database for recovery-related files, and does not reflect the amount of

space available in the underlying filesystem or ASM diskgroup.

Fri Mar 02 09:47:41 2012

Starting background process CJQ0

Fri Mar 02 09:47:42 2012

CJQ0 started with pid=70, OS id=17927

Fri Mar 02 09:47:48 2012

Errors in file /u01/app/oracle/diag/rdbms/uniondb/uniondb/trace/uniondb_psp0_17490.trc:

ORA-07274: spdcr: access error, access to oracle denied.

SVR4 Error: 2: No such file or directory

PSP0 (ospid: 17490): terminating the instance due to error 7274

Instance terminated by PSP0, pid = 17490

在trc文件中也能开到如下错误信息：

uniondb_ora_10873.trc -------------------------- *** 2012-02-29 07:15:32.493 --------Dumping Sorted Master Trigger List -------- Trigger Owner : UNIONUSER Trigger Name : TGR_TAC_TASK_MSG --------Dumping Trigger Sublists --------  trigger sublist 0 :  trigger sublist 1 : Trigger Owner : UNIONUSER Trigger Name : TGR_TAC_TASK_MSG  trigger sublist 2 :  trigger sublist 3 :  trigger sublist 4 : ALERT.log ----------- Could not open audit file:  /u01/app/oracle/admin/uniondb/adump/uniondb_pmon_10687_1.aud Retry Iteration No: 1   OS Error: 28 Retry Iteration No: 2   OS Error: 28 Retry Iteration No: 3   OS Error: 28 Retry Iteration No: 4   OS Error: 28 Retry Iteration No: 5   OS Error: 28 OS Audit file could not be created; failing after 5 retries Errors in file  ORA-09925: Unable to create audit trail file SVR4 Error: 28: No space left on device Additional information: 9925 Could not open audit file:  /u01/app/oracle/admin/uniondb/adump/uniondb_pmon_10687_1.aud Retry Iteration No: 1   OS Error: 28 Retry Iteration No: 2   OS Error: 28 Retry Iteration No: 3   OS Error: 28 Retry Iteration No: 4   OS Error: 28 Retry Iteration No: 5   OS Error: 28 Wed Feb 29 07:27:02 2012 OS Audit file could not be created; failing after 5 retries Errors in file  /u01/app/oracle/diag/rdbms/uniondb/uniondb/trace/uniondb_pmon_10687.trc: ORA-09925: Unable to create audit trail file SVR4 Error: 28: No space left on device Additional information: 9925 PMON (ospid: 10687): terminating the instance due to error 470 Wed Feb 29 07:27:04 2012 ORA-1092 : opitsk aborting process Wed Feb 29 07:27:04 2012 Could not open audit file:  /u01/app/oracle/admin/uniondb/adump/uniondb_ora_2533_b5.aud Retry Iteration No: 1   OS Error: 0 Instance terminated by PMON, pid = 10687 Retry Iteration No: 2   OS Error: 28 License high water mark = 455 Non critical error DIA-00001 caught while writing to trace metadata file (.trm) Trace file name:  "/u01/app/oracle/diag/rdbms/uniondb/uniondb/trace/uniondb_ora_2533.trc" Error message: SVR4 Error: 28: No space left on device Writing to trace metadata is disabled for now on... USER (ospid: 2533): terminating the instance Instance terminated by USER, pid = 2533 On 2012-2-29 9:43, 13754812213 wrote: