ORA-01081: cannot start already-…

机器启动后就是这个样子了，有时重启机器可以启动DB，有时也不行，需重起多次

Microsoft Windows XP [版本 5.1.2600]
(C) 版权所有 1985-2001 Microsoft Corp.

C:\Documents and Settings\Administrator>sqlplus /nolog

SQL*Plus: Release 10.1.0.2.0 - Production on 星期一 10月 25 12:47:43 2010

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

SQL> connect / as sysdba
已连接到空闲例程。
SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shutdown immediate
ORA-24324: 未初始化服务句柄
ORA-24323: 不允许此值
ORA-00020: 超出最大进程数 (%s)
SQL> shutdown abort
ORA-01031: insufficient privileges
SQL> shutdown abort
ORA-01031: insufficient privileges
SQL> 已断开连接

C:\Documents and Settings\Administrator>sqlplus /nolog

SQL*Plus: Release 10.1.0.2.0 - Production on 星期一 10月 25 12:48:18 2010

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

SQL> connect / as sysdba
已连接到空闲例程。
SQL> shutdown abort
ORACLE 例程已经关闭。
SQL> startup
ORA-27102: out of memory
OSD-00025: 附加错误信息
O/S-Error: (OS 1453) 配额不足，无法完成请求的服务。
SQL>


Alertlog:

Errors in file d:\oracle\product\10.1.0\admin\myoracle\bdump\myoracle_smon_1584.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-00376: file 7 cannot be read at this time
ORA-01110: data file 7: 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\MYORACLE\JY_UNDO.DBF'

Mon Oct 25 12:36:38 2010
KTSMG_UPDATE_MQL(): MMNL absent for 3521 secs; Foregrounds taking over
KTSMG_UPDATE_MQL(): MMNL absent for 3521 secs; Foregrounds taking over
KTSMG_UPDATE_MQL(): MMNL absent for 3521 secs; Foregrounds taking over
Mon Oct 25 12:37:39 2010
KTSMG_UPDATE_MQL(): MMNL absent for 3583 secs; Foregrounds taking over
KTSMG_UPDATE_MQL(): MMNL absent for 3583 secs; Foregrounds taking over
KTSMG_UPDATE_MQL(): MMNL absent for 3583 secs; Foregrounds taking over
Mon Oct 25 12:38:41 2010
KTSMG_UPDATE_MQL(): MMNL absent for 3644 secs; Foregrounds taking over
KTSMG_UPDATE_MQL(): MMNL absent for 3644 secs; Foregrounds taking over
KTSMG_UPDATE_MQL(): MMNL absent for 3644 secs; Foregrounds taking over
Mon Oct 25 12:39:42 2010
KTSMG_UPDATE_MQL(): MMNL absent for 3706 secs; Foregrounds taking over
KTSMG_UPDATE_MQL(): MMNL absent for 3706 secs; Foregrounds taking over
KTSMG_UPDATE_MQL(): MMNL absent for 3706 secs; Foregrounds taking over
Mon Oct 25 12:40:44 2010
KTSMG_UPDATE_MQL(): MMNL absent for 3767 secs; Foregrounds taking over
KTSMG_UPDATE_MQL(): MMNL absent for 3767 secs; Foregrounds taking over
KTSMG_UPDATE_MQL(): MMNL absent for 3767 secs; Foregrounds taking over
Mon Oct 25 12:41:03 2010
Errors in file d:\oracle\product\10.1.0\admin\myoracle\bdump\myoracle_smon_1584.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-00376: file 7 cannot be read at this time
ORA-01110: data file 7: 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\MYORACLE\JY_UNDO.DBF'

Mon Oct 25 12:41:46 2010
KTSMG_UPDATE_MQL(): MMNL absent for 3829 secs; Foregrounds taking over
KTSMG_UPDATE_MQL(): MMNL absent for 3829 secs; Foregrounds taking over
KTSMG_UPDATE_MQL(): MMNL absent for 3829 secs; Foregrounds taking over
Mon Oct 25 12:42:47 2010
KTSMG_UPDATE_MQL(): MMNL absent for 3890 secs; Foregrounds taking over
KTSMG_UPDATE_MQL(): MMNL absent for 3890 secs; Foregrounds taking over
KTSMG_UPDATE_MQL(): MMNL absent for 3890 secs; Foregrounds taking over
Mon Oct 25 12:43:49 2010
KTSMG_UPDATE_MQL(): MMNL absent for 3952 secs; Foregrounds taking over
KTSMG_UPDATE_MQL(): MMNL absent for 3952 secs; Foregrounds taking over
KTSMG_UPDATE_MQL(): MMNL absent for 3952 secs; Foregrounds taking over
Mon Oct 25 12:44:50 2010
KTSMG_UPDATE_MQL(): MMNL absent for 4013 secs; Foregrounds taking over
KTSMG_UPDATE_MQL(): MMNL absent for 4013 secs; Foregrounds taking over
KTSMG_UPDATE_MQL(): MMNL absent for 4013 secs; Foregrounds taking over
Mon Oct 25 12:45:52 2010
KTSMG_UPDATE_MQL(): MMNL absent for 4075 secs; Foregrounds taking over
KTSMG_UPDATE_MQL(): MMNL absent for 4075 secs; Foregrounds taking over
KTSMG_UPDATE_MQL(): MMNL absent for 4075 secs; Foregrounds taking over
Mon Oct 25 12:46:13 2010
Errors in file d:\oracle\product\10.1.0\admin\myoracle\bdump\myoracle_smon_1584.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-00376: file 7 cannot be read at this time
ORA-01110: data file 7: 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\MYORACLE\JY_UNDO.DBF'

Mon Oct 25 12:46:54 2010
KTSMG_UPDATE_MQL(): MMNL absent for 4136 secs; Foregrounds taking over
KTSMG_UPDATE_MQL(): MMNL absent for 4136 secs; Foregrounds taking over
KTSMG_UPDATE_MQL(): MMNL absent for 4136 secs; Foregrounds taking over
Mon Oct 25 12:47:52 2010
Starting ORACLE instance (normal)
Mon Oct 25 12:47:56 2010
KTSMG_UPDATE_MQL(): MMNL absent for 4198 secs; Foregrounds taking over
KTSMG_UPDATE_MQL(): MMNL absent for 4198 secs; Foregrounds taking over
KTSMG_UPDATE_MQL(): MMNL absent for 4198 secs; Foregrounds taking over
Mon Oct 25 12:48:26 2010
Shutting down instance (abort)
License high water mark = 130
Mon Oct 25 12:48:39 2010
Instance terminated by USER, pid = 10008
Mon Oct 25 12:48:43 2010
Starting ORACLE instance (normal)

重启机器后
(C) 版权所有 1985-2001 Microsoft Corp.

C:\Documents and Settings\Administrator>sqlplus /nolog

SQL*Plus: Release 10.1.0.2.0 - Production on 星期一 10月 25 13:12:55 2010

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

SQL> connect / as sysdba
已连接。
SQL> select *
  2  from v$recover_file;

     FILE# ONLINE  ONLINE_
---------- ------- -------
ERROR                                                                CHANGE#
----------------------------------------------------------------- ----------
TIME
--------------
         3 OFFLINE OFFLINE
                                                                    62026560
21-10月-10

         7 OFFLINE OFFLINE
                                                                    62026560
21-10月-10

     FILE# ONLINE  ONLINE_
---------- ------- -------
ERROR                                                                CHANGE#
----------------------------------------------------------------- ----------
TIME
--------------


SQL> recover database;
ORA-00283: 恢复会话因错误而取消
ORA-01124: 无法恢复数据文件 1 - 文件在使用中或在恢复中
ORA-01110: 数据文件 1: 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\MYORACLE\SYSTEM01.DBF'

SQL> recover datafile 7;
ORA-00279: 更改 62026560 (在 10/21/2010 15:03:19 生成) 对于线程 1 是必需的
ORA-00289: 建议:
D:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\MYORACLE\ARCHIVELOG\2010_10_25\O1_M

F_1_31_%U_.ARC
ORA-00280: 更改 62026560 (用于线程 1) 在序列 #31 中


指定日志: {<RET>=suggested | filename | AUTO | CANCEL}
auto
已应用的日志。
完成介质恢复。
SQL> recover datafile 1;
ORA-00283: 恢复会话因错误而取消
ORA-01124: 无法恢复数据文件 1 - 文件在使用中或在恢复中
ORA-01110: 数据文件 1: 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\MYORACLE\SYSTEM01.DBF'
SQL> shutdown immediate    ------没反应

新开个CMD

SQL> connect / as sysdba
已连接到空闲例程。
SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL>

唉 不该shutdown的
再重启一下服务

SQL> connect / as sysdba
已连接。
SQL> show sga

Total System Global Area  524288000 bytes
Fixed Size                   789692 bytes
Variable Size             472642372 bytes
Database Buffers           50331648 bytes
Redo Buffers                 524288 bytes
SQL> select *
  2  from v$recoverfile;
from v$recoverfile
     *
第 2 行出现错误:
ORA-00942: 表或视图不存在



SQL> select *
  2  from v$recover_file;

     FILE# ONLINE  ONLINE_
---------- ------- -------
ERROR                                                                CHANGE#
----------------------------------------------------------------- ----------
TIME
--------------
         3 OFFLINE OFFLINE
                                                                    62026560
21-10月-10


SQL> recover database;
ORA-00283: 恢复会话因错误而取消
ORA-01124: 无法恢复数据文件 1 - 文件在使用中或在恢复中
ORA-01110: 数据文件 1: 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\MYORACLE\SYSTEM01.DBF'


SQL> recover datafile 3;
ORA-00279: 更改 62026560 (在 10/21/2010 15:03:19 生成) 对于线程 1 是必需的
ORA-00289: 建议:
D:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\MYORACLE\ARCHIVELOG\2010_10_25\O1_M

F_1_31_%U_.ARC
ORA-00280: 更改 62026560 (用于线程 1) 在序列 #31 中


指定日志: {<RET>=suggested | filename | AUTO | CANCEL}
auto
已应用的日志。
完成介质恢复。
SQL> /

未选定行

SQL> shutdown immediate;
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup
ORACLE 例程已经启动。

Total System Global Area  524288000 bytes
Fixed Size                   789692 bytes
Variable Size             472642372 bytes
Database Buffers           50331648 bytes
Redo Buffers                 524288 bytes
数据库装载完毕。
数据库已经打开。
SQL>

关闭启动正常了

看来是有些数据文件需要恢复引起的，不过不知道怎么就需要恢复数据文件了，也没动什么