Originally posted by: sajid1

Hi,

DB 10.2.0.4
AIX 5.3

When i trying to connect sys user with the database i got below error. I am also not able to do anything with application. I tried to connect other than sys user it connected but some statement is not running some are running as below.

Enter user-name: sys as sysdba
Enter password:
ERROR:
ORA-09817: Write to audit file failed.
IBM AIX RISC System/6000 Error: 89: Invalid file system control data detected
ORA-09945: Unable to initialize the audit trail file
IBM AIX RISC System/6000 Error: 89: Invalid file system control data detected

---

Enter user-name: dev14
Enter password:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select distinct restart_time from restart_booktime
2 ;

RESTART_TIME--------------------------------------------------
sedfrcvb
SQL> select * from program_status where PROGRAM'ready for start'
2 ;
ERROR:
ORA-00376: file 38 cannot be read at this time
ORA-01110: data file 38: '/vol04/oracle/oradata/dev09.dbf'
no rows selected

Thanks

Originally posted by: sajid1

For your information

$ errpt | more
IDENTIFIER TIMESTAMP T C RESOURCE_NAME DESCRIPTION
E86653C3 0416155211 P H LVDD I/O ERROR DETECTED BY LVM
2E493F13 0416155211 P H hdisk4 ARRAY OPERATION ERROR
E86653C3 0416155211 P H LVDD I/O ERROR DETECTED BY LVM
E86653C3 0416155211 P H LVDD I/O ERROR DETECTED BY LVM
E86653C3 0416155111 P H LVDD I/O ERROR DETECTED BY LVM
EA88F829 0416155111 I O SYSJ2 USER DATA I/O ERROR
EA88F829 0416155111 I O SYSJ2 USER DATA I/O ERROR
E86653C3 0416155111 P H LVDD I/O ERROR DETECTED BY LVM
EA88F829 0416155111 I O SYSJ2 USER DATA I/O ERROR
E86653C3 0416155111 P H LVDD I/O ERROR DETECTED BY LVM
EA88F829 0416155111 I O SYSJ2 USER DATA I/O ERROR
E86653C3 0416155111 P H LVDD I/O ERROR DETECTED BY LVM
EA88F829 0416155111 I O SYSJ2 USER DATA I/O ERROR
E86653C3 0416155111 P H LVDD I/O ERROR DETECTED BY LVM
EA88F829 0416155111 I O SYSJ2 USER DATA I/O ERROR
E86653C3 0416155111 P H LVDD I/O ERROR DETECTED BY LVM
EA88F829 0416155111 I O SYSJ2 USER DATA I/O ERROR
E86653C3 0416155111 P H LVDD I/O ERROR DETECTED BY LVM
EA88F829 0416155111 I O SYSJ2 USER DATA I/O ERROR
E86653C3 0416155111 P H LVDD I/O ERROR DETECTED BY LVM
EA88F829 0416155111 I O SYSJ2 USER DATA I/O ERROR
E86653C3 0416155111 P H LVDD I/O ERROR DETECTED BY LVM
EA88F829 0416155111 I O SYSJ2 USER DATA I/O ERROR

Originally posted by: sajid1

Any expert one can update this

Originally posted by: shargus

You've lost a disk.

According to your errpt listing, it's hdisk4.

The rest of the errpt messages indicate LVM isn't happy.

The "Invalid file system control data detected" messages indicate the filesystem isn't happy, either.

You will need to recover the disk, then reactivate the volume group, then run a full fsck on the filesystem.