ALLSTARS_ORACLE 发表于 2017-4-13 13:51:35

重建控制文件,但有个表空间对应的数据文件损坏


重建控制文件时,发现有一个表空间对应的数据文件损坏了,忽略之后生成控制文件,但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: ??????????: , , , [], [], [], [], []

Wed Jul 20 18:34:50 2016
Errors in file D:\zdgl\tools\oracle\admin\zdgl\udump\ORA07432.TRC:
ORA-00600: ??????????: , , , [], [], [], [], []

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
页: [1]
查看完整版本: 重建控制文件,但有个表空间对应的数据文件损坏