执行了SHUTDOWN ABORT命令后，数据库文件打不开

ALLSTARS_ORACLE

哪位高手请帮忙！
执行了SHUTDOWN ABORT命令后，数据库文件打不开，
sql>alter datafile ' D：\oracle\QAS\sapdata1\system_1\SYSTEM.DATA1' offline drop;
database altered
sql>alter datafile ' D：\oracle\QAS\sapdata1\qasusr_1\QASUSR.DATA1' offline drop;
database altered
sql>alter datafile 'D：\oracle\QAS\sapdata1\cntrl\CNTRLQAS.DBF offline drop;
ORA-00940： invalid  alter command
sql>ALTER DATABASE OPEN RESETLOGS；
ora-01245ffline file 1 will be lost if resetlogs is done
ora-01110:data file 1: 'd:\oracle\qas\sapdata1\system_1\system.data1'
ORACLE日志文件中显示磁盘空间不足，sap登陆时disp+work启动变绿后不到一分钟就变灰了，请问我该如 何打开数据库，删除表空间重建数据库，解决硬盘的空间和DISP+WORK的启动问题(没有备份文件)，我用 的是WINDOWS2003+ORACLE9I+SAP4.7。我是新手，哪位高手能告知详细步奏，不胜感激。

下面是我的SAP日志文件dev_disp内容
---------------------------------------------------
trc file: "dev_disp", trc level: 1, release: "620"
---------------------------------------------------

Fri Jul 14 00:50:45 2006
kernel runs with dp version 3(ext=1) (@(#) DPLIB-INT-VERSION-3)
length of sys_adm_ext is 304 bytes
systemid   560 (PC with Windows NT)
relno      6200
patchlevel 0
patchno    674
intno      20020600
pid        2924

***LOG Q00=> DpSapEnvInit, DPStart (00 2924) [dpxxdisp.c   978]
        shared lib "dw_xml.dll" version 674 successfully loaded
        shared lib "dw_xtc.dll" version 674 successfully loaded
        shared lib "dw_stl.dll" version 674 successfully loaded

Fri Jul 14 00:50:57 2006
*** WARNING => DpNetCheck: NiHostToAddr(www.doesnotexist0001.qqq.nxst) took 12 seconds

Fri Jul 14 00:51:23 2006
*** WARNING => DpNetCheck: NiAddrToHost(1.0.0.0) took 26 seconds
***LOG GZZ=> 2 possible network problems detected - check tracefile and adjust the DNS settings [dpxxtool2.c  3212]
MtxInit: -2 0 0
DpShMCreate: sizeof(wp_adm)                9776        (752)
DpShMCreate: sizeof(tm_adm)                1690816        (8412)
DpShMCreate: sizeof(wp_ca_adm)        18000        (60)
DpShMCreate: sizeof(appc_ca_adm)        6000        (60)
DpShMCreate: sizeof(comm_adm)        192000        (384)
DpShMCreate: sizeof(wall_adm)        (22440/34344/56/100)
DpShMCreate: SHM_DP_ADM_KEY                (addr: 03340040, size: 1974816)
DpShMCreate: allocated sys_adm at 03340040
DpShMCreate: allocated wp_adm at 03340560
DpShMCreate: allocated tm_adm_list at 03342B90
DpShMCreate: allocated tm_adm at 03342BB8
DpShMCreate: allocated wp_ca_adm at 034DF878
DpShMCreate: allocated appc_ca_adm at 034E3EC8
DpShMCreate: allocated comm_adm_list at 034E5638
DpShMCreate: allocated comm_adm at 034E5650
DpShMCreate: allocated ca_info at 03514450
DpShMCreate: allocated wall_adm at 03514458
MBUF state OFF
EmInit: MmSetImplementation( 2 ).
<ES> client 0 initializing ....
<ES> InitFreeList
<ES> block size is 1024 kByte.
Using implementation std
<EsNT> Memory Reset enabled as NT default
<EsNT> EsIUnamFileMapInit: Initialize the memory 268 MB
<ES> 267 blocks reserved for free list.
ES initialized.

Fri Jul 14 00:51:24 2006
***LOG Q0K=> DpMsAttach, mscon ( usa2006) [dpxxdisp.c   9115]

Fri Jul 14 00:51:37 2006
CCMS: Initalizing shared memory of size 20000000 for monitoring segment.

Fri Jul 14 00:51:47 2006
CCMS: start to initalize 3.X shared alert area (first segment).
DpMsgAdmin: Set release to 6200, patchlevel 0

Fri Jul 14 00:51:48 2006
MBUF state PREPARED
MBUF component UP
DpMBufHwIdSet: set Hardware-ID
***LOG Q1C=> DpMBufHwIdSet [dpxxmbuf.c   941]
DpMsgAdmin: Set patchno for this platform to 674
Release check o.K.

Fri Jul 14 00:52:49 2006
*** ERROR => W0 (pid 2988) died [dpxxdisp.c   11523]
force unlock of wp_adm mutex W0
*** ERROR => W1 (pid 2996) died [dpxxdisp.c   11523]
force unlock of wp_adm mutex W1
*** ERROR => W2 (pid 3004) died [dpxxdisp.c   11523]
force unlock of wp_adm mutex W2
*** ERROR => W3 (pid 3012) died [dpxxdisp.c   11523]
force unlock of wp_adm mutex W3
*** ERROR => W4 (pid 3020) died [dpxxdisp.c   11523]
force unlock of wp_adm mutex W4
*** ERROR => W5 (pid 3028) died [dpxxdisp.c   11523]
force unlock of wp_adm mutex W5
*** ERROR => W6 (pid 3036) died [dpxxdisp.c   11523]
force unlock of wp_adm mutex W6
*** ERROR => W7 (pid 3044) died [dpxxdisp.c   11523]
force unlock of wp_adm mutex W7
*** ERROR => W8 (pid 3052) died [dpxxdisp.c   11523]
force unlock of wp_adm mutex W8
*** ERROR => W9 (pid 3060) died [dpxxdisp.c   11523]
force unlock of wp_adm mutex W9
*** ERROR => W10 (pid 3068) died [dpxxdisp.c   11523]
force unlock of wp_adm mutex W10
*** ERROR => W11 (pid 3076) died [dpxxdisp.c   11523]
force unlock of wp_adm mutex W11
*** ERROR => W12 (pid 3084) died [dpxxdisp.c   11523]
force unlock of wp_adm mutex W12
my types changed after wp death/restart 0xbf --> 0x80
*** DP_FATAL_ERROR => DpEnvCheck: no more work processes
*** DISPATCHER EMERGENCY SHUTDOWN ***
DpModState: change server state from STARTING to SHUTDOWN

Fri Jul 14 00:52:56 2006
***LOG Q0M=> DpMsDetach, ms_detach () [dpxxdisp.c   9341]
MBUF state OFF
MBUF component DOWN

Fri Jul 14 00:52:57 2006
***LOG Q05=> DpHalt, DPStop ( 2924) [dpxxdisp.c   7883]

------------------------------------------------------------------------------------------------
ORACLE日志文件alert_qas.log显示如下(部分)：

Sun Jul 02 14:30:11 2006
ARC1: Evaluating archive   log 2 thread 1 sequence 1146
ARC1: Beginning to archive log 2 thread 1 sequence 1146
Creating archive destination LOG_ARCHIVE_DEST_1: 'C:\ORACLE\QAS\ORAARCH\QASARCHARC01146.001'
ARC1: Completed archiving  log 2 thread 1 sequence 1146
Sun Jul 02 14:30:58 2006
Beginning log switch checkpoint up to RBA [0x47c.2.10], SCN: 0x0000.00236b6b
Thread 1 advanced to log sequence 1148
  Current log# 4 seq# 1148 mem# 0: D:\ORACLE\QAS\ORIGLOGB\LOG_G14M1.DBF
  Current log# 4 seq# 1148 mem# 1: D:\ORACLE\QAS\MIRRLOGB\LOG_G14M2.DBF
Sun Jul 02 14:30:58 2006
ARC0: Evaluating archive   log 3 thread 1 sequence 1147
ARC0: Beginning to archive log 3 thread 1 sequence 1147
Creating archive destination LOG_ARCHIVE_DEST_1: 'C:\ORACLE\QAS\ORAARCH\QASARCHARC01147.001'
Sun Jul 02 14:31:03 2006
Completed checkpoint up to RBA [0x47b.2.10], SCN: 0x0000.0023695f
Sun Jul 02 14:31:07 2006
ARC0: Completed archiving  log 3 thread 1 sequence 1147
Sun Jul 02 14:31:55 2006
Completed checkpoint up to RBA [0x47c.2.10], SCN: 0x0000.00236b6b
Sun Jul 02 14:31:57 2006
Beginning log switch checkpoint up to RBA [0x47d.2.10], SCN: 0x0000.00236d58
Thread 1 advanced to log sequence 1149
  Current log# 1 seq# 1149 mem# 0: D:\ORACLE\QAS\ORIGLOGA\LOG_G11M1.DBF
  Current log# 1 seq# 1149 mem# 1: D:\ORACLE\QAS\MIRRLOGA\LOG_G11M2.DBF
Sun Jul 02 14:31:57 2006
ARC1: Evaluating archive   log 4 thread 1 sequence 1148
ARC1: Beginning to archive log 4 thread 1 sequence 1148
Creating archive destination LOG_ARCHIVE_DEST_1: 'C:\ORACLE\QAS\ORAARCH\QASARCHARC01148.001'
ARC1: Error 19504 Creating archive log file to 'C:\ORACLE\QAS\ORAARCH\QASARCHARC01148.001'
Sun Jul 02 14:32:01 2006
Errors in file d:\oracle\qas\saptrace\background\qas_arc1_1844.trc:
ORA-19504: failed to create file "C:\ORACLE\QAS\ORAARCH\QASARCHARC01148.001"
ORA-19504: failed to create file "C:\ORACLE\QAS\ORAARCH\QASARCHARC01148.001"
ORA-27044: unable to write the header block of file
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 112) 磁盘空间不足。

ARC1: Archiving not possible: error count exceeded
ARC1: Failed to archive log 4 thread 1 sequence 1148
ARCH: Archival stopped, error occurred. Will continue retrying
ARCH:
Sun Jul 02 14:32:08 2006
ORA-16038: log 4 sequence# 1148 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 4 thread 1: 'D:\ORACLE\QAS\ORIGLOGB\LOG_G14M1.DBF'
ORA-00312: online log 4 thread 1: 'D:\ORACLE\QAS\MIRRLOGB\LOG_G14M2.DBF'

Sun Jul 02 14:32:08 2006
Errors in file d:\oracle\qas\saptrace\background\qas_arc1_1844.trc:
ORA-16038: log 4 sequence# 1148 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 4 thread 1: 'D:\ORACLE\QAS\ORIGLOGB\LOG_G14M1.DBF'
ORA-00312: online log 4 thread 1: 'D:\ORACLE\QAS\MIRRLOGB\LOG_G14M2.DBF'

Sun Jul 02 14:32:20 2006
ARC1: Evaluating archive   log 4 thread 1 sequence 1148
ARC1: Beginning to archive log 4 thread 1 sequence 1148
Creating archive destination LOG_ARCHIVE_DEST_1: 'C:\ORACLE\QAS\ORAARCH\QASARCHARC01148.001'
ARC1: Error 19504 Creating archive log file to 'C:\ORACLE\QAS\ORAARCH\QASARCHARC01148.001'
Sun Jul 02 14:32:20 2006
Errors in file d:\oracle\qas\saptrace\background\qas_arc1_1844.trc:
ORA-19504: failed to create file "C:\ORACLE\QAS\ORAARCH\QASARCHARC01148.001"
ORA-19504: failed to create file "C:\ORACLE\QAS\ORAARCH\QASARCHARC01148.001"
ORA-27044: unable to write the header block of file
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 112) 磁盘空间不足。

ARC1: Archiving not possible: error count exceeded
ARC1: Failed to archive log 4 thread 1 sequence 1148
Sun Jul 02 14:32:21 2006
Errors in file d:\oracle\qas\saptrace\background\qas_arc1_1844.trc:
ORA-16038: log 4 sequence# 1148 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 4 thread 1: 'D:\ORACLE\QAS\ORIGLOGB\LOG_G14M1.DBF'
ORA-00312: online log 4 thread 1: 'D:\ORACLE\QAS\MIRRLOGB\LOG_G14M2.DBF'

ALLSTARS_ORACLE

Sun Jul 02 14:32:52 2006
Completed checkpoint up to RBA [0x47d.2.10], SCN: 0x0000.00236d58
Sun Jul 02 14:32:55 2006
Beginning log switch checkpoint up to RBA [0x47e.2.10], SCN: 0x0000.00236fb1
Thread 1 advanced to log sequence 1150
  Current log# 2 seq# 1150 mem# 0: D:\ORACLE\QAS\ORIGLOGB\LOG_G12M1.DBF
  Current log# 2 seq# 1150 mem# 1: D:\ORACLE\QAS\MIRRLOGB\LOG_G12M2.DBF
Sun Jul 02 14:32:55 2006
ARC1: Evaluating archive   log 4 thread 1 sequence 1148
ARC1: Beginning to archive log 4 thread 1 sequence 1148
Creating archive destination LOG_ARCHIVE_DEST_1: 'C:\ORACLE\QAS\ORAARCH\QASARCHARC01148.001'
ARC1: Error 19504 Creating archive log file to 'C:\ORACLE\QAS\ORAARCH\QASARCHARC01148.001'
Sun Jul 02 14:32:55 2006
Errors in file d:\oracle\qas\saptrace\background\qas_arc1_1844.trc:
ORA-19504: failed to create file "C:\ORACLE\QAS\ORAARCH\QASARCHARC01148.001"
ORA-19504: failed to create file "C:\ORACLE\QAS\ORAARCH\QASARCHARC01148.001"
ORA-27044: unable to write the header block of file
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 112) 磁盘空间不足。

ARC1: Archiving not possible: error count exceeded
ARC1: Failed to archive log 4 thread 1 sequence 1148
Sun Jul 02 14:32:56 2006
Errors in file d:\oracle\qas\saptrace\background\qas_arc1_1844.trc:
ORA-16038: log 4 sequence# 1148 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 4 thread 1: 'D:\ORACLE\QAS\ORIGLOGB\LOG_G14M1.DBF'
ORA-00312: online log 4 thread 1: 'D:\ORACLE\QAS\MIRRLOGB\LOG_G14M2.DBF'

Sun Jul 02 14:33:22 2006
ARC1: Evaluating archive   log 4 thread 1 sequence 1148
ARC1: Beginning to archive log 4 thread 1 sequence 1148
Creating archive destination LOG_ARCHIVE_DEST_1: 'C:\ORACLE\QAS\ORAARCH\QASARCHARC01148.001'
ARC1: Error 19504 Creating archive log file to 'C:\ORACLE\QAS\ORAARCH\QASARCHARC01148.001'
Sun Jul 02 14:33:22 2006
Errors in file d:\oracle\qas\saptrace\background\qas_arc1_1844.trc:
ORA-19504: failed to create file "C:\ORACLE\QAS\ORAARCH\QASARCHARC01148.001"
ORA-19504: failed to create file "C:\ORACLE\QAS\ORAARCH\QASARCHARC01148.001"
ORA-27044: unable to write the header block of file
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 112) 磁盘空间不足。

ARC1: Archiving not possible: error count exceeded
ARC1: Failed to archive log 4 thread 1 sequence 1148
Sun Jul 02 14:33:23 2006
Errors in file d:\oracle\qas\saptrace\background\qas_arc1_1844.trc:
ORA-16038: log 4 sequence# 1148 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 4 thread 1: 'D:\ORACLE\QAS\ORIGLOGB\LOG_G14M1.DBF'
ORA-00312: online log 4 thread 1: 'D:\ORACLE\QAS\MIRRLOGB\LOG_G14M2.DBF'

Sun Jul 02 14:34:24 2006
ARC1: Evaluating archive   log 4 thread 1 sequence 1148
ARC1: Beginning to archive log 4 thread 1 sequence 1148
Creating archive destination LOG_ARCHIVE_DEST_1: 'C:\ORACLE\QAS\ORAARCH\QASARCHARC01148.001'
ARC1: Error 19504 Creating archive log file to 'C:\ORACLE\QAS\ORAARCH\QASARCHARC01148.001'
Sun Jul 02 14:34:25 2006
Errors in file d:\oracle\qas\saptrace\background\qas_arc1_1844.trc:
ORA-19504: failed to create file "C:\ORACLE\QAS\ORAARCH\QASARCHARC01148.001"
ORA-19504: failed to create file "C:\ORACLE\QAS\ORAARCH\QASARCHARC01148.001"
ORA-27044: unable to write the header block of file
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 112) 磁盘空间不足。



我开始不想把system表空间的文件给offline drop的。但是每次我执行
sql>alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'D:\ORACLE\QAS\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'
我没有备份文件。

不知该如何做，大侠救命



D：\oracle\QAS\sapdata1\cntrl\CNTRLQAS.DBF没删掉
D：\oracle\QAS\sapdata1\system_1\SYSTEM.DATA1'
D：\oracle\QAS\sapdata1\qasusr_1\QASUSR.DATA1'
这两个数据文件物理文件还在
CNTRLQAS.DBF 大小  6.55MB
QASUSR.DATA1           40MB
SYSTEM.DATA1           1.25KB

谢谢大家的热情帮助，难怪这方面的人才工资高，很难学啊，我要打退堂鼓了，又不甘心放弃，怎么办呢？等待救世主的出现

各位大侠，我不想保留以前的数据，那是用来做实验的不重要。只想删除数据，让磁盘恢复到刚装好SAP系统前的大小，以便我再建实例和数据库文件（我不想重装SAP系统）。我只是希望SAP能用，能将DDIC权限复制给我建立的用户后，可以修改“计量单位”的内容。
也就是说只要数据库能打开，最好能删除数据资料，让我的SAP能登陆进行配置就行了


SYSTEM.DATA1 1.25KB
这个文件怎么这么小?
可能是执行了
SQL>alter datafile ' D：\oracle\QAS\sapdata1\system_1\SYSTEM.DATA1' offline drop;的缘故。

我之前建立了3个集团，并把CLIENT800拷贝给它们，SAP系统开始是正常的，但是当我将DDIC权限复制给我新建的用户后，很长时间都没反应，我就直接退出了。可能这时磁盘空间已经快没有了。然后在运行那里启动实例，显示数据库没打开，我就用了SHUTDOWN ABORT。结果SAP登陆时DISP+WORK就启动不了了。
我只想让DISP+WORK能启动起来，数据库最好是恢复到刚装好SAP系统前的大小（不重装SAP），以便我再建实例和数据库文件，让SAP能进行配置。
所以最重要的是数据库能打开，让我删除了它。或着直接在系统中物理删除也行（我一直不敢这么做）。各位大哥有没有什么好方法。救救我吧！



我的WINDOWS2003系统划分了两个区：
C盘  9 GB  （左右）
D盘  63GB （左右）
SAP系统装在C盘，数据库ORACLE9I装在D盘

重建控制文件请指点

各位大侠：请指点如何重建控制文件


谢谢各位的帮助，数据库用DBCA终于删除了。但磁盘上的空间没变小，旧的数据库的文件都还在硬盘上。是否还要删除表空间呢