oracle-09925,ORA-09925&ORA-01075错误处理

一服务器出现无法使用sqlplus

oracle@hostname>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jul 13 08:52:45 2009

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

ERROR:

ORA-09925: Unable to create audit trail file

IBM AIX RISC System/6000 Error: 89: Invalid file system control data detected

Additional information: 9925

ORA-01075: you are currently logged on

检查对应的错误说明:

$oerr ora 9925

09925, 00000, "Unable to create audit trail file"

// *Cause: ORACLE was not able to create the file being used to hold

// audit trail records.

// *Action: Check the UNIX error number for a possible operating system error.

// If there is no error, contact ORACLE customer support.

$oerr ora 1075

01075, 00000, "you are currently logged on"

// *Cause: Attempt to login while logged in.

// *Action:

再检查OS出现的错误日志:

7B82439B 0710100509 U U SYSJ2 FILE SYSTEM CORRUPTION

B6DB68E0 0710100509 I O SYSJ2 FILE SYSTEM RECOVERY REQUIRED

提示文件系统有报错.

因为无法正常停库,要求测试业务先停止,直接kill smon进程停止数据库.

检查使用此 #fuser -uc /oradata

/oradata:

#umount /oradata

#fsck -y /oradata

The current volume is: /dev/fslv08

Primary superblock is valid.

*** Phase 1 - Initial inode scan

*** Phase 2 - Process remaining directories

*** Phase 3 - Process remaining files

*** Phase 4 - Check and repair inode allocation map

*** Phase 5 - Check and repair block allocation map

Block allocation map is corrupt (FIXED)

Superblock marked dirty because repairs are about to be written.

File system is clean.

Superblock is marked dirty (FIXED)

All observed inconsistencies have been repaired.

#mount

#su - oracle

ORACLE_SID=xxx

sql / as sysdba

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jul 13 09:44:11 2009

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 1258291200 bytes

Fixed Size 2070944 bytes

Variable Size 285214304 bytes

Database Buffers 956301312 bytes

Redo Buffers 14704640 bytes

Database mounted.

Database opened.

SQL> exit

[@more@]