[wydb2#/oracle/oracle/oracle/product/10.2.0/db_1/rdbms/lib]bbed parfile=/oracle/oracle/bbed.par

Password: 

BBED: Release 2.0.0.0.0 - Limited Production on Wed Jan 16 07:23:03 2019

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

************* !!! For Oracle Internal Use only !!! ***************

BBED> set dba 53,1

        DBA             0x0d400001 (222298113 53,1)

BBED> show

        FILE#           53

        BLOCK#          1

        OFFSET          0

        DBA             0x0d400001 (222298113 53,1)

        FILENAME        /oracle/oracle/oradata/cqwydb/noap_data07.dbf

        BIFILE          bifile.bbd

        LISTFILE        /oracle/oracle/file.txt

        BLOCKSIZE       16384

        MODE            Edit

        EDIT            Unrecoverable

        IBASE           Dec

        OBASE           Dec

        WIDTH           80

        COUNT           512

        LOGFILE         log.bbd

        SPOOL           No

BBED>  p kcvfhckp

struct kcvfhckp, 36 bytes                   @484     

   struct kcvcpscn, 8 bytes                 @484     

      ub4 kscnbas                           @484      0x78c9466e

      ub2 kscnwrp                           @488      0x003c

   ub4 kcvcptim                             @492      0x3b6d6eba

   ub2 kcvcpthr                             @496      0x0001

   union u, 12 bytes                        @500     

      struct kcvcprba, 12 bytes             @500     

         ub4 kcrbaseq                       @500      0x000b509c

         ub4 kcrbabno                       @504      0x00000002

         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> d /v dba 53,1 offset 484 count 64 

 File: /oracle/oracle/oradata/cqwydb/noap_data07.dbf (53)

 Block: 1       Offsets:  484 to  547  Dba:0x0d400001

-------------------------------------------------------

 78c9466e 003c0023 3b6d6eba 00010000 l x.Fn.<.#;mn.....

 000b509c 00000002 00100000 02000000 l ..P.............

 00000000 00000000 00000000 00000000 l ................

 00000000 00000000 00000000 00000000 l ................

 <16 bytes per line>

BBED> 

BBED> d /v dba 1,1 offset 484 count 64 

 File: /oracle/oracle/oradata/cqwydb/system01.dbf (1)

 Block: 1       Offsets:  484 to  547  Dba:0x00400001

-------------------------------------------------------

 78c9466e 003c0023 3b6d6eba 00010000 l x.Fn.<.#;mn.....

 000b509c 00000002 00100000 02000000 l ..P.............

 00000000 00000000 00000000 00000000 l ................

 00000000 00000000 00000000 00000000 l ................

 <16 bytes per line>

BBED> exit

查看文件头scn正确，

尝试officeline drop 数据文件

SQL>  recover database using backup controlfile until cancel;

ORA-00279: change 259724494446 generated at 01/08/2019 16:05:14 needed for

thread 1

ORA-00289: suggestion : /oracle/oracle/arch1_741532_685040001.dbf

ORA-00280: change 259724494446 for thread 1 is in sequence #741532

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

/oracle/oracle/oradata/cqwydb/system01.dbf

ORA-00317: file type 16384 in header is not log file

ORA-00334: archived log: '/oracle/oracle/oradata/cqwydb/system01.dbf'

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: '/oracle/oracle/oradata/cqwydb/system01.dbf'

SQL> alter database open resetlogs;

alter database open resetlogs

*

ERROR at line 1:

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: '/oracle/oracle/oradata/cqwydb/system01.dbf'

SQL>  recover database using backup controlfile until cancel;

ORA-00279: change 259724494446 generated at 01/08/2019 16:05:14 needed for

thread 1

ORA-00289: suggestion : /oracle/oracle/arch1_741532_685040001.dbf

ORA-00280: change 259724494446 for thread 1 is in sequence #741532

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

CANCEL

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: '/oracle/oracle/oradata/cqwydb/system01.dbf'

ORA-01112: media recovery not started