> 有备份时，一定要以使用备份恢复为首选，下面仅在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.
```

##

ITPub博客

ORA-01190使用bbed强制online数据文件

最新文章