数据库启动问题，在线等
数据库启动失败，出现如下错误
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 之前的操作在上面我都说了，现在我启用的隐含参数_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: , , , , [2248
361909], , [], []
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: , , , , [2248
361909], , [], []
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: , , , , [2248
361909], , [], []
$ 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: , , , , [2248
361909], , [], []
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: , , , , [2248
361909], , [], []
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: , , , , [2248
361909], , [], []
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: , , , , [2248
361909], , [], []
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: , , , , [2248
361909], , [], []
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: , , , , [2248
361909], , [], []
$
页:
[1]