8.0.5恢复问题
只有数据文件,控制文件和重做日志文件,在新服务器上安装创建好新数据库后,关闭数据库,将原来所有数据文件覆盖,相当于冷备份恢复.现恢复失败.操作系统: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
创建控制文件
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
页:
[1]