有备份时，一定要以使用备份恢复为首选，下面仅在11.2.0.4版本测试验证，其他版本未做严格测试验证，希望所有库都永不宕机，远离bbed等特殊恢复工具，保平安。
文章结构：
- 修改前基础知识结构
- 段头块结构说明
- 字节序endian说明
- ORA-01190报错以及使用bbed修复完整过程
1. 修改前基础知识
1.1 段头块结构
bbed工具不支持查询Segment Header的物理结构，不过可以对照block dump与bbed二进制大致判断结构。
# 下面segment header来自于网络，经过11.2.0.4测试验证：
struct kcbh, 20 bytes @0
ub1 type_kcbh @0 0x23
Block type
ub1 frmt_kcbh @1 0xa2
Block format a2=oracle 112
ub1 spare1_kcbh @2 0x00 # not used
ub1 spare2_kcbh @3 0x00 # not used
ub4 rdba_kcbh @4 0x01400a0a # RDBA-Relative Data Block Address
ub4 bas_kcbh @8 0x0029cbc7 # SCN Base
ub2 wrp_kcbh @12 0x0000 # SCN Wrap
ub1 seq_kcbh @14 0x02 # sequence number
ub1 flg_kcbh @15 0x04
# Flag:
# 0x01 New Block
# 0x02 Delayed Loging Change advanced SCN/seq
# 0x04 Check value saved-block XOR's to zero
# 0x08 Temporary block
ub2 chkval_kcbh @16 0xe395 # Optional block checksum(if DB_BLOCK_CHECKSUM=TRUE)
ub2 spare3_kcbh @18 0x0000 # not used
struct ech(Extent Control Header) @36 # Extent Control Header
# High High water marker
ub4 extents_ech @36 0x00000012 # extents
ub4 blocks_ech @40 0x00000180 # blocks
ub4 offset_ech @44 0x00000a9c # offset
ub4 @48 # ext#
ub4 blk_ech @52 0x00000080 # blk#
ub4 extsize_ech @56 0x00000080 # ext size
ub4 hw_ech @60 0x01401f80 # Highwater dba
# Low High water marker
ub4 lhwmext_ech @92 0x00000010 # ext# of Low HighWater Mark
ub4 lhwmblk_ech @96 0x00000010 # blk# of Low HighWater Mark
ub4 lhwmextsize_ech @100 0x00000080 # ext size of Low HighWater Mark
ub4 lhwm_ech @104 0x01401e90 # Low HighWater Mark dba
ub4 lhwmbmb1_ech @124 0x01401e80 # Level 1 BMB for Low HWM block
ub4 hhwmbmb1_ech @128 0x01401f01 # Level 1 BMB for High HWM block
ub4 segtype_ech @208 0x00000001 # Segment Type
ub4 blksz_ech @212 0x00002000 # blksz
ub4 fbsz_echo @216 0x00000000 # fbsz
ub4 l2asoffset_ech @220 0x00001434 # L2 Array start offset
ub4 firstbmb3_echo @224 0x00000000 # First Level 3 BMB
ub4 l2hfinsert_ech @228 0x01400a09 # L2 Hint for inserts
ub4 nl2_echo @232 0x00000001 # nl2
ub4 lastBMB1_echo @236 0x01401f01 # Last Level 1 BMB
ub4 lastBMB2_echo @240 0x01400a09 # Last Level 2 BMB
ub4 lastBMB3_echo @244 0x00000000 # Last Level 3 BMB
ub4 mhnext_echo @260 0x00000000 # next of Map Header
ub4 mhext_echo @264 0x00000012 # extents of Map Header
ub4 mhobj_ech @272 0x00015781 # obj# of Map Header
ub4 mhflag_ech @276 0x10000000 # flag of Map Header
struct em(Extent Map) @280 # Extent Map
ub4 dba_em[0] @280 0x01400a08 ub4 len_em[0] @284 0x00000008
ub4 dba_em[1] @288 0x01400a10 ub4 len_em[1] @292 0x00000008
...
struct am(Auxillary Map) @2736 # Auxillary Map
ub4 fdba_am[0] @2736 0x01400a08 ub4 datadba_am[0] @2740 0x01400a0b
ub4 fdba_am[1] @2744 0x01400a08 ub4 datadba_am[1] @2748 0x01400a10
...
ub4 slbbdba1_am @5192 0x01400a09 # Second Level Bitmap block DBAs
1.2 endian字节序
不同OS平台具有不同字节序，可以查询v$transportable_platform查看具体OS是big或little。
对于little endian，在存储时，低位在前，高位在后，例如，下面为Linux中：
# 可以看到，kcvfhccc值为0x0000001a，由于为little endian，所以存储时，低位在前，存储为1a000000。
BBED> p file 18 block 1 kcvfhccc
ub4 kcvfhccc @148 0x0000001a
BBED> d /v file 18 block 1 offset 148
File: /veridata/rman/test_resize.dbf (18)
Block: 1 Offsets: 148 to 157 Dba:0x04800001
-------------------------------------------------------
1a000000 00000000 0000 l ..........
2. ORA-01190使用bbed强制online数据文件
有了上面的基础知识，当我们有数据文件offline，或者创建控制文件时，遗漏了某个数据文件，最后resetlogs打开数据库后，无法online数据文件，可以通过bbed修改文件头欺骗Oracle，达到online数据文件目的
2.1 online数据文件报错
# 本次报错主要为下面操作
1.重建控制文件恢复数据库，在CREATE CONTROLFILE语句中遗漏了下面表空间数据文件。
2.遗漏之后，文件变成unnamed文件，通过ALTER DATABASE RENAME将文件可以修正，但是由于进行了ALTER DATABASE OPEN RESETLOGS，导致无法online数据文件。
# 报错
SYS@honor1 > alter tablespace test_resize online;
alter tablespace test_resize online
*
ERROR at line 1:
ORA-01190: control file or data file 18 is from before the last RESETLOGS
ORA-01110: data file 18: '+DATADG/honor/datafile/test_resize.270.1088865031'
2.2 需要修改的信息
# 使用bbed来修改文件头信息
# 有4个属性来判断datafile是否和其他的datafile 一致，如果都一致，可以正常online
kcvfhsta (at offset 138) - fuzzy status
kcvfhcpc (at offset 140) - Checkpoint count.
kcvfhccc (at offset 148) - Unknown, but is always 1 less than thecheckpoint point count.
kscnbas (at offset 484) - SCN of last change to the datafile.
kcvcptim (at offset 492) -Time of the last change to the datafile.
# 还有2个跟resetlog相关的属性：
kcvfhrlc - resetlogs count
kcvfhrls - resetlogs scn
2.3 检查状态以及将ASM文件拷贝到文件系统
# 1. 查看数据文件状态信息
SYS@honor1 > select file#,status,checkpoint_change#,CHECKPOINT_COUNT,CHECKPOINT_TIME,RESETLOGS_CHANGE#,RESETLOGS_TIME,fuzzy from v$datafile_header;
FILE# STATUS CHECKPOINT_CHANGE# CHECKPOINT_COUNT CHECKPOINT_TIME RESETLOGS_CHANGE# RESETLOGS_TIME FUZ
----- ---------- ------------------ ---------------- ------------------- ----------------- ------------------- ---
1 ONLINE 21484872432 2867 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
2 ONLINE 21484872432 2860 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
3 ONLINE 21484872432 2784 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
4 ONLINE 21484872432 2882 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
5 ONLINE 21484872432 2786 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
6 ONLINE 21484872432 1459 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
7 ONLINE 21484872432 2729 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
8 ONLINE 21484872432 2715 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
9 ONLINE 21484872432 1356 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
10 ONLINE 21484872432 214 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
11 ONLINE 21484872432 1356 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
12 ONLINE 21484872432 789 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
13 ONLINE 21484872432 606 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
14 ONLINE 21484872432 471 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
15 ONLINE 21484872432 331 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
16 ONLINE 21484872432 165 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
17 ONLINE 21484872432 84 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
18 OFFLINE 21484852691 27 2021-11-30 10:37:30 21474861774 2021-04-14 21:50:34 NO
# 2. 使用RMAN将ASM文件拷贝到文件系统
$ rman target /
RMAN> shutdown immediate;
RMAN> startup mount;
RMAN> backup as copy tablespace test_resize format '/veridata/rman/test_resize.dbf';
RMAN> switch tablespace test_resize to copy;
# 下面文件是为了作为参考，拷贝两个文件，可以在bbed修改时互为参考。
RMAN> backup as copy tablespace test_aut format '/veridata/rman/test_aut.dbf';
RMAN> switch tablespace test_aut to copy;
RMAN> exit;
2.4 BBED准备
# bbed配置文件编辑
$ cat datafile.list
17 /veridata/rman/test_aut.dbf
18 /veridata/rman/test_resize.dbf
$ cat bbed.par
blocksize=8192
listfile=/home/oracle/datafile.list
mode=edit
$ bbed parfile=bbed.par
Password: blockedit
BBED> info all
File# Name Size(blks)
----- ---- ----------
17 /veridata/rman/test_aut.dbf 0
18 /veridata/rman/test_resize.dbf 0
2.5 kcvfhsta修改
# kcvfhsta状态，一致则不需要修改
BBED> set file 17 block 1
FILE# 17
BLOCK# 1
BBED> p kcvfhsta
ub2 kcvfhsta @138 0x0000 (NONE)
BBED> set file 18 block 1
FILE# 18
BLOCK# 1
BBED> p kcvfhsta
ub2 kcvfhsta @138 0x0000 (NONE)
2.6 kcvfhcpc修改
# kcvfhcpc状态修改
BBED> d file 17 block 1 offset 140 count 10
File: /veridata/rman/test_aut.dbf (17)
Block: 1 Offsets: 140 to 149 Dba:0x04400001
------------------------------------------------------------------------
54000000 467dfa40 5300
<32 bytes per line>
BBED> m /x 54
Warning: contents of previous BIFILE will be lost. Proceed? (Y/N) y
File: /veridata/rman/test_resize.dbf (18)
Block: 1 Offsets: 140 to 149 Dba:0x04800001
------------------------------------------------------------------------
54000000 0d41f640 1a00
<32 bytes per line>
# 每次修改一项之后，应用之后verify，防止错误修改
BBED> sum apply
Check value for File 18, Block 1:
current = 0x43a8, required = 0x43a8
BBED> verify
2.7 kcvfhccc修改
# kcvfhccc修改
BBED> p file 17 block 1 kcvfhccc
ub4 kcvfhccc @148 0x00000053
BBED> p file 18 block 1 kcvfhccc
ub4 kcvfhccc @148 0x0000001a
BBED> d /v file 18 block 1 offset 148
File: /veridata/rman/test_resize.dbf (18)
Block: 1 Offsets: 148 to 157 Dba:0x04800001
-------------------------------------------------------
1a000000 00000000 0000 l ..........
<16 bytes per line>
BBED> m /x 53 file 18 block 1 offset 148
File: /veridata/rman/test_resize.dbf (18)
Block: 1 Offsets: 148 to 157 Dba:0x04800001
------------------------------------------------------------------------
53000000 00000000 0000
<32 bytes per line>
BBED> p file 18 block 1 kcvfhccc
ub4 kcvfhccc @148 0x00000053
BBED> sum apply
Check value for File 18, Block 1:
current = 0x43e1, required = 0x43e1
BBED> verify
2.8 kscnbas修改
如果SCN差距巨大，需要修改kscnwrp则，使用相同方法修改即可
# kscnbas以及kcvcptim修改
BBED> p file 17 block 1 kcvfhckp
struct kcvfhckp, 36 bytes @484
struct kcvcpscn, 8 bytes @484
ub4 kscnbas @484 0x009922f0
ub2 kscnwrp @488 0x0005
ub4 kcvcptim @492 0x40faabce
ub2 kcvcpthr @496 0x0001
union u, 12 bytes @500
struct kcvcprba, 12 bytes @500
ub4 kcrbaseq @500 0x00000001
ub4 kcrbabno @504 0x00011f34
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 file 18 block 1 kcvfhckp
struct kcvfhckp, 36 bytes @484
struct kcvcpscn, 8 bytes @484
ub4 kscnbas @484 0x0098d5d3
ub2 kscnwrp @488 0x0005
ub4 kcvcptim @492 0x40f7afea
ub2 kcvcpthr @496 0x0001
union u, 12 bytes @500
struct kcvcprba, 12 bytes @500
ub4 kcrbaseq @500 0x00000207
ub4 kcrbabno @504 0x00000007
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> m /x f02299 file 18 block 1 offset 484
File: /veridata/rman/test_resize.dbf (18)
Block: 1 Offsets: 484 to 515 Dba:0x04800001
------------------------------------------------------------------------
f0229900 05000000 eaaff740 01000000 07020000 07000000 10009804 02000000
<32 bytes per line>
BBED> sum apply
Check value for File 18, Block 1:
current = 0xb4c3, required = 0xb4c3
BBED> verify
2.9 kcvcptim修改
# kcvcptim状态修改
BBED> set file 18 block 1 offset 492
# 由于其他kcvcptim为ceabfa40，尾号为0，无法直接整个字符串修改，所以分两次修改，才能修改40
BBED> m /x ceabfa
File: /veridata/rman/test_resize.dbf (18)
Block: 1 Offsets: 492 to 523 Dba:0x04800001
------------------------------------------------------------------------
ceabfaa4 01000000 07020000 07000000 10009804 02000000 00000000 00000000
<32 bytes per line>
BBED> set offset 495
OFFSET 495
BBED> d
File: /veridata/rman/test_resize.dbf (18)
Block: 1 Offsets: 495 to 526 Dba:0x04800001
------------------------------------------------------------------------
a4010000 00070200 00070000 00100098 04020000 00000000 00000000 00000000
<32 bytes per line>
BBED> m /x 4001
File: /veridata/rman/test_resize.dbf (18)
Block: 1 Offsets: 495 to 526 Dba:0x04800001
------------------------------------------------------------------------
40010000 00070200 00070000 00100098 04020000 00000000 00000000 00000000
<32 bytes per line>
BBED> set offset 492
OFFSET 492
BBED> d
File: /veridata/rman/test_resize.dbf (18)
Block: 1 Offsets: 492 to 523 Dba:0x04800001
------------------------------------------------------------------------
ceabfa40 01000000 07020000 07000000 10009804 02000000 00000000 00000000
<32 bytes per line>
BBED> sum apply
Check value for File 18, Block 1:
current = 0xb0ea, required = 0xb0ea
BBED> verify
2.10 kcvfhrlc修改
# kcvfhrlc修改
BBED> p file 17 block 1 kcvfhrlc
ub4 kcvfhrlc @112 0x40fa7d53
BBED> p file 18 block 1 kcvfhrlc
ub4 kcvfhrlc @112 0x3fc5202a
BBED> d /v file 17 block 1 offset 112
File: /veridata/rman/test_aut.dbf (17)
Block: 1 Offsets: 112 to 143 Dba:0x04400001
-------------------------------------------------------
537dfa40 e8d59800 05000000 00000000 l S}.@............
00000000 00000000 00000000 54000000 l ............T...
<16 bytes per line>
BBED> d /v file 18 block 1 offset 112
File: /veridata/rman/test_resize.dbf (18)
Block: 1 Offsets: 112 to 143 Dba:0x04800001
-------------------------------------------------------
2a20c53f ce620000 05000000 00000000 l * .?.b..........
00000000 00000000 00000000 54000000 l ............T...
<16 bytes per line>
BBED> m /x 537dfa file 18 block 1 offset 112
File: /veridata/rman/test_resize.dbf (18)
Block: 1 Offsets: 112 to 143 Dba:0x04800001
------------------------------------------------------------------------
537dfa3f ce620000 05000000 00000000 00000000 00000000 00000000 54000000
<32 bytes per line>
BBED> set offset 115
OFFSET 115
BBED> d
File: /veridata/rman/test_resize.dbf (18)
Block: 1 Offsets: 115 to 146 Dba:0x04800001
------------------------------------------------------------------------
3fce6200 00050000 00000000 00000000 00000000 00000000 00540000 000d41f6
<32 bytes per line>
BBED> m /x 40ce
File: /veridata/rman/test_resize.dbf (18)
Block: 1 Offsets: 115 to 146 Dba:0x04800001
------------------------------------------------------------------------
40ce6200 00050000 00000000 00000000 00000000 00000000 00540000 000d41f6
<32 bytes per line>
BBED> p file 18 block 1 kcvfhrlc
ub4 kcvfhrlc @112 0x40fa7d53
BBED> sum apply
Check value for File 18, Block 1:
current = 0x92ac, required = 0x92ac
BBED> verify
2.11 kcvfhrl修改
# kcvfhrl修改
# resetlogs scn只需要修改scn base即可，scn wrap一致，不需要修改
# 如果scn wrap不一致，参照同样方法修改即可
BBED> p file 17 block 1 kcvfhrls
struct kcvfhrls, 8 bytes @116
ub4 kscnbas @116 0x0098d5e8
ub2 kscnwrp @120 0x0005
BBED> p file 18 block 1 kcvfhrls
struct kcvfhrls, 8 bytes @116
ub4 kscnbas @116 0x000062ce
ub2 kscnwrp @120 0x0005
BBED> set file 18 block 1 offset 116
FILE# 18
BLOCK# 1
OFFSET 116
BBED> d
File: /veridata/rman/test_resize.dbf (18)
Block: 1 Offsets: 116 to 147 Dba:0x04800001
------------------------------------------------------------------------
ce620000 05000000 00000000 00000000 00000000 00000000 54000000 0d41f640
<32 bytes per line>
BBED> m /x e8d598
File: /veridata/rman/test_resize.dbf (18)
Block: 1 Offsets: 116 to 147 Dba:0x04800001
------------------------------------------------------------------------
e8d59800 05000000 00000000 00000000 00000000 00000000 54000000 0d41f640
<32 bytes per line>
BBED> sum apply
Check value for File 18, Block 1:
current = 0x2512, required = 0x2512
BBED> verify
2.12 验证修改
# 验证修改效果
SYS@honor1 > col file# for 99
SYS@honor1 > col checkpoint_change# for 99999999999999999
SYS@honor1 > col checkpoint_count for 99999
SYS@honor1 > col resetlogs_change# for 9999999999999999
SYS@honor1 > select file#,status,checkpoint_change#,CHECKPOINT_COUNT,CHECKPOINT_TIME,RESETLOGS_CHANGE#,RESETLOGS_TIME,fuzzy from v$datafile_header;
FILE# STATUS CHECKPOINT_CHANGE# CHECKPOINT_COUNT CHECKPOINT_TIME RESETLOGS_CHANGE# RESETLOGS_TIME FUZ
----- ---------- ------------------ ---------------- ------------------- ----------------- ------------------- ---
1 ONLINE 21484872432 2867 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
2 ONLINE 21484872432 2860 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
3 ONLINE 21484872432 2784 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
4 ONLINE 21484872432 2882 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
5 ONLINE 21484872432 2786 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
6 ONLINE 21484872432 1459 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
7 ONLINE 21484872432 2729 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
8 ONLINE 21484872432 2715 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
9 ONLINE 21484872432 1356 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
10 ONLINE 21484872432 214 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
11 ONLINE 21484872432 1356 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
12 ONLINE 21484872432 789 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
13 ONLINE 21484872432 606 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
14 ONLINE 21484872432 471 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
15 ONLINE 21484872432 331 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
16 ONLINE 21484872432 165 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
17 ONLINE 21484872432 84 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
18 OFFLINE 21484872432 84 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
2.13 恢复数据文件open数据库
SYS@honor1 > alter database datafile 18 online;
Database altered.
SYS@honor1 > select file#,status,checkpoint_change#,CHECKPOINT_COUNT,CHECKPOINT_TIME,RESETLOGS_CHANGE#,RESETLOGS_TIME,fuzzy from v$datafile_header;
FILE# STATUS CHECKPOINT_CHANGE# CHECKPOINT_COUNT CHECKPOINT_TIME RESETLOGS_CHANGE# RESETLOGS_TIME FUZ
----- ---------- ------------------ ---------------- ------------------- ----------------- ------------------- ---
1 ONLINE 21484872432 2867 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
2 ONLINE 21484872432 2860 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
3 ONLINE 21484872432 2784 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
4 ONLINE 21484872432 2882 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
5 ONLINE 21484872432 2786 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
6 ONLINE 21484872432 1459 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
7 ONLINE 21484872432 2729 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
8 ONLINE 21484872432 2715 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
9 ONLINE 21484872432 1356 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
10 ONLINE 21484872432 214 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
11 ONLINE 21484872432 1356 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
12 ONLINE 21484872432 789 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
13 ONLINE 21484872432 606 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
14 ONLINE 21484872432 471 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
15 ONLINE 21484872432 331 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
16 ONLINE 21484872432 165 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
17 ONLINE 21484872432 84 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
18 ONLINE 21484872432 84 2021-12-01 16:56:46 21484852712 2021-12-01 13:38:27 NO
# 由于未修改控制文件数据文件相关信息以及kcvcprba的rba相关信息，所以需要media recovery
SYS@honor1 > alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 18 needs media recovery
ORA-01110: data file 18: '/veridata/rman/test_resize.dbf'
SYS@honor1 > recover datafile 18;
Media recovery complete.
SYS@honor1 > alter database open;
Database altered.
最后修改时间：2021-12-18 20:54:09
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
