- 最后登录
- 2017-5-4
- 在线时间
- 81 小时
- 威望
- 999
- 金钱
- 2391
- 注册时间
- 2013-9-11
- 阅读权限
- 150
- 帖子
- 1124
- 精华
- 5
- 积分
- 999
- UID
- 1220
|
1#
发表于 2017-4-13 13:51:35
|
查看: 1102 |
回复: 0
重建控制文件时,发现有一个表空间对应的数据文件损坏了,忽略之后生成控制文件,但alter database open 打不开数据库,报ora-600错。这个该怎么办啊!oracle 8.1.7 windows平台
Wed Jul 20 18:34:38 2016
ALTER DATABASE RECOVER LOGFILE 'D:\zdgl\tools\oracle\oradata\zdgl\redo07.log'
Media Recovery Log D:\zdgl\tools\oracle\oradata\zdgl\redo07.log
Incomplete recovery applied all redo ever generated.
Recovery completed through change %s51983435
Media Recovery Complete
Completed: ALTER DATABASE RECOVER LOGFILE 'D:\zdgl\tools\o
Wed Jul 20 18:34:43 2016
alter database open resetlogs
RESETLOGS after complete recovery through change 51983435
Online log 2 of thread 1 was previously cleared
Online log 3 of thread 1 was previously cleared
Online log 4 of thread 1 was previously cleared
Online log 5 of thread 1 was previously cleared
Online log 6 of thread 1 was previously cleared
Online log 8 of thread 1 was previously cleared
Online log 9 of thread 1 was previously cleared
Online log 10 of thread 1 was previously cleared
Wed Jul 20 18:34:49 2016
Thread 1 opened at log sequence 1
Current log# 7 seq# 1 mem# 0: D:\ZDGL\TOOLS\ORACLE\ORADATA\ZDGL\REDO07.LOG
Successful open of redo thread 1.
Wed Jul 20 18:34:49 2016
SMON: enabling cache recovery
Wed Jul 20 18:34:49 2016
Errors in file D:\zdgl\tools\oracle\admin\zdgl\udump\ORA07432.TRC:
ORA-00600: ??????????: [25012], [1], [2], [], [], [], [], []
Wed Jul 20 18:34:50 2016
Errors in file D:\zdgl\tools\oracle\admin\zdgl\udump\ORA07432.TRC:
ORA-00600: ??????????: [25012], [1], [2], [], [], [], [], []
Wed Jul 20 18:34:50 2016
Error 600 happened during db open, shutting down database
USER: terminating instance due to error 600
Wed Jul 20 18:34:51 2016
Errors in file D:\zdgl\tools\oracle\admin\zdgl\bdump\zdglPMON.TRC:
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []
Instance terminated by USER, pid = 7432
ORA-1092 signalled during: alter database open resetlogs
...
Starting up ORACLE RDBMS Version: 8.1.7.4.1.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 524288000
large_pool_size = 52428800
java_pool_size = 20971520
control_files = D:\zdgl\tools\oracle\oradata\zdgl\control01.ctl, D:\zdgl\tools\oracle\oradata\zdgl\control02.ctl, D:\zdgl\tools\oracle\oradata\zdgl\control03.ctl
db_block_buffers = 131072
db_block_size = 8192
compatible = 8.1.0
log_buffer = 14700544
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
db_files = 1024
db_file_multiblock_read_count= 8
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
db_domain = com
global_names = TRUE
distributed_transactions = 500
instance_name = zdgl
service_names = zdgl.com
mts_dispatchers = (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
open_links = 4
sort_area_size = 1073741824
sort_area_retained_size = 1073741824
db_name = zdgl
open_cursors = 300
ifile = D:\zdgl\tools\oracle\admin\zdgl\pfile\init.ora
os_authent_prefix =
job_queue_processes = 6
job_queue_interval = 10
_system_trig_enabled = FALSE
parallel_max_servers = 5
background_dump_dest = D:\zdgl\tools\oracle\admin\zdgl\bdump
user_dump_dest = D:\zdgl\tools\oracle\admin\zdgl\udump
max_dump_file_size = 10240
oracle_trace_collection_name=
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
SNP0 started with pid=8
SNP1 started with pid=9
SNP2 started with pid=10
SNP3 started with pid=11
SNP4 started with pid=12
SNP5 started with pid=13
Wed Jul 20 18:36:15 2016
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed Jul 20 18:36:15 2016
ALTER DATABASE MOUNT
Wed Jul 20 18:36:21 2016
Successful mount of redo thread 1, with mount id 2814122149.
Wed Jul 20 18:36:21 2016
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Wed Jul 20 18:36:21 2016 |
|