> 有备份时，一定要以使用备份恢复为首选，下面仅在11.2.0.4版本测试验证，其他版本未做严格测试验证，希望所有库都永不宕机，远离bbed等特殊恢复工具，保平安。 文章结构： 1. 修改前基础知识结构 - 段头块结构说明 - 字节序endian说明 2. ORA-01190报错以及使用bbed修复完整过程 # 1. 修改前基础知识 ## 1.1 段头块结构 > bbed工具不支持查询Segment Header的物理结构，不过可以对照block dump与bbed二进制大致判断结构。 ```shell # 下面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字节序 ```shell 不同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数据文件报错 ```shell # 本次报错主要为下面操作 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 需要修改的信息 ```shell # 使用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文件拷贝到文件系统 ```shell # 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准备 ```shell # 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修改 ```shell # 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修改 ```shell # 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修改 ```shell # 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则，使用相同方法修改即可 ```shell # 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修改 ```shell # 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修改 ```shell # 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修改 ```shell # 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 验证修改 ```shell # 验证修改效果 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数据库 ```shell 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. ``` ##