oracle+media,ORA-01075: you are currently logged on

rm删除文件后alert中出现错误

Mon Apr 16 21:36:59 2012

Errors in file /home/oracle/oracle/admin/XGS/bdump/xgs_j000_1349.trc:

ORA-00603: ORACLE server session terminated by fatal error

ORA-01116: error in opening database file 3

ORA-01110: data file 3: '/home/oracle/oracle/oradata/XGS/sysaux01.dbf'

ORA-27041: unable to open file

Linux Error: 2: No such file or directory

Additional information: 3

ORA-01116: error in opening database file 3

ORA-01110: data file 3: '/home/oracle/oracle/oradata/XGS/sysaux01.dbf'

ORA-27041: unable to open file

Linux Error: 2: No such file or directory

Additional information: 3

ORA-01116: error in opening database file 6

ORA-01110: data file 6: '/home/oracle/oracle/oradata/XGS/undotbs02.dbf'

ORA-27041: unable to open file

Linux Error: 2: No such file or directory

Additional information: 3

数据库进程还在运行

oracle 779 1 0 21:21 ? 00:00:01 ora_pmon_XGS

oracle 781 1 0 21:21 ? 00:00:10 ora_psp0_XGS

oracle 783 1 0 21:21 ? 00:00:00 ora_mman_XGS

oracle 785 1 0 21:21 ? 00:00:00 ora_dbw0_XGS

oracle 787 1 0 21:21 ? 00:00:00 ora_lgwr_XGS

oracle 789 1 0 21:21 ? 00:00:00 ora_ckpt_XGS

oracle 791 1 0 21:21 ? 00:00:00 ora_smon_XGS

oracle 793 1 0 21:21 ? 00:00:00 ora_reco_XGS

oracle 795 1 0 21:21 ? 00:00:00 ora_cjq0_XGS

oracle 797 1 0 21:21 ? 00:00:01 ora_mmon_XGS

oracle 799 1 0 21:21 ? 00:00:00 ora_mmnl_XGS

oracle 801 1 0 21:21 ? 00:00:00 ora_d000_XGS

oracle 803 1 0 21:21 ? 00:00:00 ora_s000_XGS

尝试登陆数据库

[oracle@dbtest ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Apr 16 21:40:06 2012

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

ERROR:

ORA-01075: you are currently logged on

Enter user-name: sys

Enter password:

ERROR:

ORA-00604: error occurred at recursive SQL level 2

ORA-01116: error in opening database file 1

ORA-01110: data file 1: '/home/oracle/oracle/oradata/XGS/system01.dbf'

ORA-27041: unable to open file

Linux Error: 2: No such file or directory

Additional information: 3

ORA-00604: error occurred at recursive SQL level 1

ORA-01116: error in opening database file 6

ORA-01110: data file 6: '/home/oracle/oracle/oradata/XGS/undotbs02.dbf'

ORA-27041: unable to open file

Linux Error: 2: No such file or directory

Additional information: 3

问题原因

Internal triggers are trying to fire but one or more datafiles for the SYSAUX tablespace is offline,

this is preventing the database from allowing new connections.

NOTE: At this point, you cannot connect to verify the status in V$DATAFILE,

but you may find an indication of the offline datafile(s) in the alert.log file.

For example:

In one case, a media problem occurred which made disks unavailable.

This caused several files to be taken offline automatically including a SYSAUX datafile.

解决方法

kill进程,重启数据库到mount状态,然后根据特定情况恢复数据库或者online相关文件