- 最后登录
- 2017-5-4
- 在线时间
- 81 小时
- 威望
- 999
- 金钱
- 2391
- 注册时间
- 2013-9-11
- 阅读权限
- 150
- 帖子
- 1124
- 精华
- 5
- 积分
- 999
- UID
- 1220
|
1#
发表于 2017-4-16 13:33:15
|
查看: 1788 |
回复: 0
平台: ORACLE 8.05 恢复时报错,只能采用DUL方式。
最重要的数据在:USR1ORCL.ora 文件4G中。无法找开,也无法恢复。(没归档,没有备份)
采用DUL工具,整了一天,没有整出来,,,,晕晕晕的了。
DUL: Warning: Recreating file "EXT.dat"
DUL: Warning: Recreating file "SEG.dat"
DUL: Warning: Recreating file "COMPATSEG.dat"
tablespace 0, data file 1: 29778 blocks scanned
tablespace 1, data file 2: 6050 blocks scanned
tablespace 2, data file 3: 2080792 blocks scanned
tablespace 3, data file 4: 94400 blocks scanned
tablespace 4, data file 5: 5119 blocks scanned
. unloading table ZYB
DUL: Warning: Block is never used, DBA is zero
DUL: Error: While processing block ts#=2, file#=3, block#=242768
DUL: Error: While processing block ts#=2, file#=3, block#=242768
DUL: Error: Could not read/parse segment header
DUL: Warning: Recreating file "TJ122_ZYB.ctl"
0 rows unloaded
. unloading table ZYXXB
DUL: Warning: Block is never used, DBA is zero
DUL: Error: While processing block ts#=2, file#=3, block#=242818
DUL: Error: While processing block ts#=2, file#=3, block#=242818
DUL: Error: Could not read/parse segment header
DUL: Warning: Recreating file "TJ122_ZYXXB.ctl" 0 rows unloaded
. unloading table ZZZCDZP
DUL: Warning: Block is never used, DBA is zero
DUL: Error: While processing block ts#=2, file#=3, block#=242868
DUL: Error: While processing block ts#=2, file#=3, block#=242868
DUL: Error: Could not read/parse segment header
DUL: Warning: Recreating file "TJ122_ZZZCDZP.ctl"
0 rows unloaded
================control.dul=========================
0 1 I:\ORANT\DATABASE\SYS1ORCL.ORA
1 2 I:\ORANT\DATABASE\RBS1ORCL.ORA
2 3 I:\ORANT\DATABASE\USR1ORCL.ORA
3 4 I:\ORANT\DATABASE\TMP1ORCL.ORA
4 5 I:\ORANT\DATABASE\INDX1ORCL.ORA
============================init.dul====================
db_block_size=2048
osd_big_endian_flag=false
compatible=8
export_mode=true
dc_columns=20000000
osd_dba_file_bits=10
osd_c_struct_alignment=32
osd_file_leader_size= 1
osd_word_size = 32
dc_columns=20000000
dc_tables=100000
dc_objects=1000000
dc_users=400
dc_segments=1000000
control_file =control.dul
=========================================
unload user sys 用户的数据库可以出来,其它出来不了???
但同样的参数,可以DUL 一个正常的数据库。。。。。。数据能正常出来。。。。
NND, 搞晕了,,,,,
重新扫描过N次了
主要是:USR1ORCL.ORA 文件的头坏了。。。
|
|