目的：使用bbed将已经offline掉的datafile5的scn信息改为与其他datafile一致。(二)
2015-07-24 08:32:37
·
作者:
·
浏览: 1
-----------------------------------
c8b53600
<32 bytes per line>
BBED> set offset +2
OFFSET 486
BBED> m /x 3600
File: /u01/app/oracle/oradata/test/ten01.dbf (5)
Block: 1 Offsets: 486 to 489 Dba:0x01400001
------------------------------------------------------------------------
36000000
<32 bytes per line>
BBED> m /x 5dc94b34 offset 492
File: /u01/app/oracle/oradata/test/ten01.dbf (5)
Block: 1 Offsets: 492 to 495 Dba:0x01400001
------------------------------------------------------------------------
5dc94b34
<32 bytes per line>
BBED> m /x 68010000 offset 140
File: /u01/app/oracle/oradata/test/ten01.dbf (5)
Block: 1 Offsets: 140 to 143 Dba:0x01400001
------------------------------------------------------------------------
68010000
<32 bytes per line>
BBED> m /x 67010000 offset 148
File: /u01/app/oracle/oradata/test/ten01.dbf (5)
Block: 1 Offsets: 148 to 151 Dba:0x01400001
------------------------------------------------------------------------
67010000
<32 bytes per line>
BBED> p kcvfhckp
struct kcvfhckp, 36 bytes @484
struct kcvcpscn, 8 bytes @484
ub4 kscnbas @484 0x0036b5c8
ub2 kscnwrp @488 0x0000
ub4 kcvcptim @492 0x344bc95d
ub2 kcvcpthr @496 0x0001
union u, 12 bytes @500
struct kcvcprba, 12 bytes @500
ub4 kcrbaseq @500 0x00000098
ub4 kcrbabno @504 0x0000b62c
ub2 kcrbabof @508 0x0010
ub1 kcvcpetb[0] @512 0x02
ub1 kcvcpetb[1] @513 0x00
ub1 kcvcpetb[2] @514 0x00
ub1 kcvcpetb[3] @515 0x00
ub1 kcvcpetb[4] @516 0x00
ub1 kcvcpetb[5] @517 0x00
ub1 kcvcpetb[6] @518 0x00
ub1 kcvcpetb[7] @519 0x00
BBED>
p kcvfhcpc
ub4 kcvfhcpc @140 0x00000168
BBED> p kcvfhccc
ub4 kcvfhccc @148 0x00000167
BBED> sum
Check value for File 5, Block 1:
current = 0xc16c, required = 0xbd5a
BBED> sum apply
Check value for File 5, Block 1:
current = 0xbd5a, required = 0xbd5a
BBED>
?
SQL> select file#,to_char(checkpoint_change#,'999999999999'),to_char(RESETLOGS_CHANGE#,'999999999999')
from v$datafile_header; 2
FILE# TO_CHAR(CHECK TO_CHAR(RESET
----- ------------- -------------
1 3585483 3580553
2 3585483 3580553
3 3585483 3580553
4 3585483 3580553
5 3585480 995548 --->3585480跟3585483还是不一样。
6 3585483 3580553
7 3585483 3580553
8 3585483 3580553
9 3585483 3580553
10 3585483 3580553
11 3585483 3580553
12 3395372 995548
12 rows selected.
SQL> recover datafile 5;--->recover是不行滴，原因是该datafile是属于在 resetlog之前就已经offline的数据文件
ORA-00283: recovery session canceled due to errors
ORA-19909: datafile 5 belongs to an orphan incarnation
ORA-01110: data file 5: '/u01/app/oracle/oradata/test/ten01.dbf'