数据库启动问题，在线等

ALLSTARS_ORACLE

数据库启动失败，出现如下错误

SQL> startup
ORACLE instance started.

Total System Global Area  789350088 bytes
Fixed Size                   280264 bytes
Variable Size             268435456 bytes
Database Buffers          520093696 bytes
Redo Buffers                 540672 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 17 - see DBWR trace file
ORA-01110: data file 17: '/export/home2/oradata/dmgc.dbf'

我查了一下，dmgc.dbf几经不存在了，我怎么才能启动数据库呢？

楼上的各位，你们说的我都试过了，提示以下错误：
alter database datafile '/export/home2/oradata/dmgc.dbf' offline drop
*
ERROR at line 1:
ORA-01516: nonexistent log file, datafile or tempfile
'/export/home2/oradata/dmgc.dbf'


SQL>ecover datafile '/home/oracle/dwbx_wmstat.dbf'；

ORA-01179: file /export/home2/oradata/dmgc.dbf does not exist

这个文件都不存在了，怎么办



我用select name from v$datafile查看，其中有一行
/export/home2/oradata/dmgc.dbf

我是非归档模式，急啊！

实际上已经看不到/export/home2/oradata/dmgc.dbf 这个文件了
我用alter database open 命令，提示：
ORA-01589: 要打开数据库则必须使用 RESETLOGS 或 NORESETLOGS 选项


我用alter database open noresetlogs;提示
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done




我已经把那个数据文件offline drop了，然后怎么做？


我用alter database open 命令，提示：
ORA-01589: 要打开数据库则必须使用 RESETLOGS 或 NORESETLOGS 选项

我用alter database open noresetlogs;提示
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done


alter databse open  resetlogs出以下提示：
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'D:\ORACLE\ORADATA\ORACLECT\SYSTEM01.DBF'


我现在，alter database open ,系统长期等待


没有ok，打开数据库出以下错误
ORA-03113: end-of-file on communication channel

ALLSTARS_ORACLE

之前的操作在上面我都说了，现在我启用的隐含参数_allow_resetlogs_corruption=true,想强行打开数据库，就变成这样了，以下是alert文件的信息
Ended recovery at
Thread 1: logseq 2, block 3, scn 3.2247867976
0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Sun Aug 19 12:08:55 2007
Thread 1 advanced to log sequence 3
Thread 1 opened at log sequence 3
  Current log# 2 seq# 3 mem# 0: /export/home/oracle/OraHome1/oradata/cy4dc02/red

o02.log
Successful open of redo thread 1.
Sun Aug 19 12:08:55 2007
SMON: enabling cache recovery
Sun Aug 19 12:08:55 2007
ARC0: Media recovery disabled
Sun Aug 19 12:08:55 2007
Errors in file /export/home/oracle/OraHome1/admin/cy4dc02/udump/cy4dc02_ora_1395

8.trc:
ORA-00600: internal error code, arguments: [2662], [3], [2247867981], [3], [2248

361909], [8388613], [], []
Sun Aug 19 12:08:57 2007
Errors in file /export/home/oracle/OraHome1/admin/cy4dc02/udump/cy4dc02_ora_1395

8.trc:
ORA-00600: internal error code, arguments: [2662], [3], [2247867981], [3], [2248

361909], [8388613], [], []
Sun Aug 19 12:08:57 2007
Error 600 happened during db open, shutting down database
USER: terminating instance due to error 600
Instance terminated by USER, pid = 13958
ORA-1092 signalled during: ALTER DATABASE OPEN...
Sun Aug 19 12:13:57 2007
USER: terminating instance due to error 1092
Instance terminated by USER, pid = 13958
Sun Aug 19 12:13:57 2007
Errors in file /export/home/oracle/OraHome1/admin/cy4dc02/udump/cy4dc02_ora_1395

8.trc:
ORA-27302: failure occurred at: skgpwreset1
ORA-27303: additional information: invalid shared ctx
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00600: internal error code, arguments: [2662], [3], [2247867981], [3], [2248

361909], [8388613], [], []
$ tail -200 alert_cy4dc02.log
  _allow_resetlogs_corruption= TRUE
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = cy4.dqyt.petrochina
  instance_name            = cy4dc02
  dispatchers              = (PROTOCOL=TCP)(SER=MODOSE), (PROTOCOL=TCP)(PRE=orac

le.aurora.server.GiopServer), (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServe

r)
  job_queue_processes      = 14
  background_dump_dest     = /export/home/oracle/OraHome1/admin/cy4dc02/bdump
  user_dump_dest           = /export/home/oracle/OraHome1/admin/cy4dc02/udump
  core_dump_dest           = /export/home/oracle/OraHome1/admin/cy4dc02/cdump
  sort_area_size           = 109715200
  db_name                  = cy4dc02
  open_cursors             = 300
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
Sun Aug 19 11:01:14 2007
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL

=TCP))'...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL

=TCP))'...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL

=TCP))'...
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=13
Sun Aug 19 11:01:14 2007
ARCH: STARTING ARCH PROCESSES COMPLETE
Sun Aug 19 11:01:14 2007
ARC0: Archival started
ARC0: Thread not mounted
Sun Aug 19 11:01:14 2007
ALTER DATABASE   MOUNT
Sun Aug 19 11:01:21 2007
Successful mount of redo thread 1, with mount id 3059476989.
Sun Aug 19 11:01:21 2007
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE   MOUNT
Sun Aug 19 11:03:19 2007
alter database clear unarchived logfile group 1
Sun Aug 19 11:03:19 2007
Clearing online log 1 of thread 1 sequence number 0
Completed: alter database clear unarchived logfile group 1
Sun Aug 19 11:03:32 2007
alter database open
Sun Aug 19 11:03:32 2007
Beginning crash recovery of 1 threads
Sun Aug 19 11:03:32 2007
Started first pass scan
Sun Aug 19 11:03:32 2007
Completed first pass scan
Sun Aug 19 11:03:32 2007
Started recovery at
Thread 1: logseq 1, block 3, scn 3.2247827972
Recovery of Online Redo Log: Thread 1 Group 3 Seq 1 Reading mem 0
  Mem# 0 errs 0: /export/home/oracle/OraHome1/oradata/cy4dc02/redo03.log
Sun Aug 19 11:03:32 2007
Ended recovery at
Thread 1: logseq 1, block 3, scn 3.2247847973
0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Sun Aug 19 11:03:33 2007
Thread 1 advanced to log sequence 2
Thread 1 opened at log sequence 2
  Current log# 1 seq# 2 mem# 0: /export/home/oracle/OraHome1/oradata/cy4dc02/red

o01.log
Successful open of redo thread 1.
Sun Aug 19 11:03:33 2007
ARC0: Media recovery disabled
Sun Aug 19 11:03:33 2007
SMON: enabling cache recovery
Sun Aug 19 11:03:33 2007
Errors in file /export/home/oracle/OraHome1/admin/cy4dc02/udump/cy4dc02_ora_1382

0.trc:
ORA-00600: internal error code, arguments: [2662], [3], [2247847978], [3], [2248

361909], [8388613], [], []
Sun Aug 19 11:03:34 2007
Errors in file /export/home/oracle/OraHome1/admin/cy4dc02/udump/cy4dc02_ora_1382

0.trc:
ORA-00600: internal error code, arguments: [2662], [3], [2247847978], [3], [2248

361909], [8388613], [], []
Sun Aug 19 11:03:34 2007
Error 600 happened during db open, shutting down database
USER: terminating instance due to error 600
Instance terminated by USER, pid = 13820
ORA-1092 signalled during: alter database open...
Sun Aug 19 11:08:35 2007
USER: terminating instance due to error 1092
Instance terminated by USER, pid = 13820
Sun Aug 19 11:08:35 2007
Errors in file /export/home/oracle/OraHome1/admin/cy4dc02/udump/cy4dc02_ora_1382

0.trc:
ORA-27302: failure occurred at: skgpwreset1
ORA-27303: additional information: invalid shared ctx
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00600: internal error code, arguments: [2662], [3], [2247847978], [3], [2248

361909], [8388613], [], []
Sun Aug 19 12:08:43 2007
Starting ORACLE instance (force)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Starting up ORACLE RDBMS Version: 9.0.1.0.0.
System parameters with non-default values:
  processes                = 150
  timed_statistics         = TRUE
  shared_pool_size         = 117440512
  large_pool_size          = 50857600
  java_pool_size           = 67108864
  resource_manager_plan    = SYSTEM_PLAN
  control_files            = /export/home/oracle/OraHome1/oradata/cy4dc02/contro

l01.ctl, /export/home1/orasysdata/control02.ctl, /export/home2/oradata/control03

.ctl
  db_block_size            = 16384

ARC0: Media recovery disabled
Sun Aug 19 12:08:55 2007
Errors in file /export/home/oracle/OraHome1/admin/cy4dc02/udump/cy4dc02_ora_1395

8.trc:
ORA-00600: internal error code, arguments: [2662], [3], [2247867981], [3], [2248

361909], [8388613], [], []
Sun Aug 19 12:08:57 2007
Errors in file /export/home/oracle/OraHome1/admin/cy4dc02/udump/cy4dc02_ora_1395

8.trc:
ORA-00600: internal error code, arguments: [2662], [3], [2247867981], [3], [2248

361909], [8388613], [], []
Sun Aug 19 12:08:57 2007
Error 600 happened during db open, shutting down database
USER: terminating instance due to error 600
Instance terminated by USER, pid = 13958
ORA-1092 signalled during: ALTER DATABASE OPEN...
Sun Aug 19 12:13:57 2007
USER: terminating instance due to error 1092
Instance terminated by USER, pid = 13958
Sun Aug 19 12:13:57 2007
Errors in file /export/home/oracle/OraHome1/admin/cy4dc02/udump/cy4dc02_ora_1395

8.trc:
ORA-27302: failure occurred at: skgpwreset1
ORA-27303: additional information: invalid shared ctx
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00600: internal error code, arguments: [2662], [3], [2247867981], [3], [2248

361909], [8388613], [], []
$