环境
WinXP
Oracle 10g（安装路径D:\ORACLE\PRODUCT\10.1.0\）
错误，
ORA-01033: ORACLE initialization or shutdown in progress
原因
删除SID时，删除了一个表空间的数据文件
处理过程
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:\Documents and Settings\xxxx>sqlplus system/yang@ora
SQL*Plus: Release 10.1.0.2.0 - Production on 火 1月 15 12:19:18 2008
Copyright (c) 1982, 2004, Oracle. All rights reserved.
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
NOLOG登录数据库
C:\Documents and Settings\xxxx>sqlplus /nolog
SQL*Plus: Release 10.1.0.2.0 - Production on 火 1月 15 12:35:54 2008
Copyright (c) 1982, 2004, Oracle. All rights reserved.
使用SYSDBA连接数据库
SQL> connect sys/yang as sysdba
Connected.
关闭数据库
SQL> shutdown normal
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
重启到MOUNT状态
SQL> startup mount
ORACLE instance started.
Total System Global Area 171966464 bytes
Fixed Size 787988 bytes
Variable Size 145488364 bytes
Database Buffers 25165824 bytes
Redo Buffers 524288 bytes
Database mounted.
ALTER 数据库 OPEN状态
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01147: SYSTEM tablespace file 1 is offline
ORA-01110: data file 1: 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORA\SYSTEM01.DBF'
显示出 datafile 1发生错误
修改datafile 1的状态
SQL> alter database datafile 1 online;
Database altered.
数据库状态
SQL> alter database open;
Database altered.
数据库正常
SQL> conn system/yang@ora
Connected.
SQL> select * from state;
CNT_C ST_ ST_NAME
----- --- ----------
1 11 123
1 11 123