8.0.5恢复问题

ALLSTARS_ORACLE

只有数据文件,控制文件和重做日志文件,在新服务器上安装创建好新数据库后,关闭数据库,将原来所有数据文件覆盖,相当于冷备份恢复.现恢复失败.
操作系统:windows 2000
数据库ra8.0.5

Alter 日志文件内容

Dump file C:\orant\RDBMS80\trace\orclALRT.LOG
Wed Jul 04 17:22:19 2007
ORACLE V8.0.5.0.0 - Production vsnsta=0
vsnsql=c vsnxtr=3
Windows NT V5.0, OS V8.147, CPU type 586
Starting up ORACLE RDBMS Version: 8.0.5.0.0.
System parameters with non-default values:
  processes                = 59
  shared_pool_size         = 11534336
  control_files            = C:\orant\DATABASE\ctl1ORCL.ora
  db_block_buffers         = 1000
  db_block_size            = 2048
  log_buffer               = 8192
  log_checkpoint_interval  = 10000
  db_files                 = 1024
  db_file_multiblock_read_count= 8
  sequence_cache_entries   = 10
  sequence_cache_hash_buckets= 10
  remote_login_passwordfile= SHARED
  global_names             = TRUE
  distributed_lock_timeout = 300
  distributed_transactions = 5
  open_links               = 4
  db_name                  = ORCL
  text_enable              = TRUE
  job_queue_processes      = 2
  job_queue_interval       = 10
  job_queue_keep_connections= FALSE
  parallel_max_servers     = 5
  background_dump_dest     = %RDBMS80%\trace
  user_dump_dest           = %RDBMS80%\trace
  max_dump_file_size       = 10240
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
Wed Jul 04 17:22:19 2007
alter database "orcl" mount exclusive
***
Corrupt block relative dba: 0x0000001c file=0. blocknum=28.
Completely zero block found during controlfile block read
DBW0: terminating instance due to error 227
Wed Jul 04 17:22:23 2007
ORA-449 signalled during: alter database "orcl" mount exclusive...
Wed Jul 04 17:22:23 2007
Instance terminated by DBW0, pid = 824


orclDBW0文件内容

Dump file C:\orant\RDBMS80\trace\orclDBW0.TRC
Wed Jul 04 17:22:23 2007
ORACLE V8.0.5.0.0 - Production vsnsta=0
vsnsql=c vsnxtr=3
Windows NT V5.0, OS V8.147, CPU type 586
Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production
PL/SQL Release 8.0.5.0.0 - Production
Windows NT V5.0, OS V8.147, CPU type 586
Instance name: orcl

Redo thread mounted by this instance: 0 <none>

Oracle process number: 3

pid: 338


*** SESSION ID2.1) 2007.07.04.17.22.23.718
***
Corrupt block relative dba: 0x0000001c file=0. blocknum=28.
Completely zero block found during controlfile block read
error 227 detected in background process

ALLSTARS_ORACLE

创建控制文件

SQL> CREATE CONTROLFILE REUSE DATABASE "ORCL" NORESETLOGS    NOARCHIVELOG
  2      MAXLOGFILES 32
  3      MAXLOGMEMBERS 2
  4      MAXDATAFILES 32
  5      MAXINSTANCES 16
  6      MAXLOGHISTORY 1630
  7  LOGFILE
  8    GROUP 1 'C:\ORANT\DATABASE\LOG4ORCL.ORA'  SIZE 1M,
  9    GROUP 2 'C:\ORANT\DATABASE\LOG3ORCL.ORA'  SIZE 1M,
10    GROUP 3 'C:\ORANT\DATABASE\LOG2ORCL.ORA'  SIZE 1M,
11    GROUP 4 'C:\ORANT\DATABASE\LOG1ORCL.ORA'  SIZE 1M
12  DATAFILE
13    'C:\ORANT\DATABASE\SYS1ORCL.ORA',
14    'C:\ORANT\DATABASE\USR1ORCL.ORA',
15    'C:\ORANT\DATABASE\RBS1ORCL.ORA',
16    'C:\ORANT\DATABASE\TMP1ORCL.ORA',
17    'D:\DATABASE\SYOA1.ORA',
18    'D:\DATABASE\SYOA2.ORA',
19    'D:\DATABASE\SYOA3',
20    'D:\DATABASE\SYOA3.ORA',
21    'D:\DATABASE\SYOA4.ORA',
22    'D:\DATABASE\SYOA5.ORA',
23    'D:\DATABASE\SYOA6.ORA',
24    'D:\DATABASE\SYOA7.ORA',
25    'D:\DATABASE\SYOA8.ORA'
26  ;
CREATE CONTROLFILE REUSE DATABASE "ORCL" NORESETLOGS    NOARCHIVELOG
*
错误位于第1行：
ORA-01503: CREATE CONTROLFILE ??
ORA-01158: ??????
DBV 控制文件

DBVERIFY: Release 8.0.5.0.0 - Production on 星期一 7月 9 16:17:55 2007

(c) Copyright 1998 Oracle Corporation.  All rights reserved.


DBVERIFY - 检验开始：文件 = E:\新建文件夹\c\c\orant\DATABASE\CTL1ORCL.ORA
汇集的页面27 - 可能是媒体损坏
***
Corrupt block relative dba: 0x0000001b file=0. blocknum=27.
Fractured block found during dbv:
Data in bad block - type:21. format:2. rdba:0x0000001b
last change scn:0xffff.000178d0 seq:0x1 flg:0x04
consistancy value in tail 0x00000000
check value in block header: 0xbac4, calculated check value: 0x6dd1
spare1:0x0, spare2:0x0, spare2:0x0

汇集的页面35 - 可能是媒体损坏
***
Corrupt block relative dba: 0x00000023 file=0. blocknum=35.
Fractured block found during dbv:
Data in bad block - type:0. format:0. rdba:0x00000000
last change scn:0x0000.00000000 seq:0x0 flg:0x00
consistancy value in tail 0x52e71501
check value in block header: 0x0, check value not calculated
spare1:0x0, spare2:0x0, spare2:0x0

汇集的页面59 - 可能是媒体损坏
***
Corrupt block relative dba: 0x0000003b file=0. blocknum=59.
Fractured block found during dbv:
Data in bad block - type:0. format:2. rdba:0x0000003b
last change scn:0x0000.00000000 seq:0x1 flg:0x01
consistancy value in tail 0x00000000
check value in block header: 0x0, check value not calculated
spare1:0x0, spare2:0x0, spare2:0x0

汇集的页面67 - 可能是媒体损坏
***
Corrupt block relative dba: 0x00000043 file=0. blocknum=67.
Fractured block found during dbv:
Data in bad block - type:0. format:0. rdba:0x00000000
last change scn:0x0000.00000000 seq:0x0 flg:0x00
consistancy value in tail 0x00000001
check value in block header: 0x0, check value not calculated
spare1:0x0, spare2:0x0, spare2:0x0

汇集的页面91 - 可能是媒体损坏
***
Corrupt block relative dba: 0x0000005b file=0. blocknum=91.
Fractured block found during dbv:
Data in bad block - type:21. format:2. rdba:0x0000005b
last change scn:0xffff.00015a2f seq:0x1 flg:0x04
consistancy value in tail 0x00000000
check value in block header: 0x87d3, calculated check value: 0x5667
spare1:0x0, spare2:0x0, spare2:0x0