- 最后登录
- 2017-5-4
- 在线时间
- 81 小时
- 威望
- 999
- 金钱
- 2391
- 注册时间
- 2013-9-11
- 阅读权限
- 150
- 帖子
- 1124
- 精华
- 5
- 积分
- 999
- UID
- 1220
|
1#
发表于 2017-4-17 12:38:01
|
查看: 2012 |
回复: 1
哪位高手请帮忙!
执行了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' |
|