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

检查对应的错误说明:

oracle@hostname $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.
oracle@hostname $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进程停止数据库.

检查使用此root@hostname #fuser -uc /oradata
/oradata:
root@hostname #umount /oradata
root@hostname #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.
root@hostname #mount /oradata

root@hostname #su - oracle
export">oracle@hostname>export ORACLE_SID=xxx
sqlsqlplus">plus">oracle@hostname>sqlplus / 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@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/2073/viewspace-1024083/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/2073/viewspace-1024083/