企业官网建设流程全解析

--其中两个文件头损坏

File#62: E:\sr3_54\sr3.data54 (1280000 blocks) - Started: 2026-07-28 23:57:53

File#62: rfile=0 (0x00000000) header_block_num=0 (0x00000000) filesize_status:NO

file62, block 0: block all zero

file62, block 1: block all zero

File#84: E:\sr3_76\sr3.data76 (4185601 blocks) - Started: 2026-07-29 00:55:32

File#84: rfile=638937491 (0x26156993) header_block_num=77152556 (0x0499412C) filesize_status:NO

file84, block 1: rdba error (expected 1, got 69760), bad block

file84, block 2: rdba error (expected 2, got 589836), bad block

--坏块汇总

DBV completed at: 2026-07-29 00:58:10

===============================================

DBV Summary:

Total blocks checked: 196287237

Total all zero blocks found: 337417

Total all rdba error blocks found: 1062468

Total all tailchk error blocks found: 1

Total all soft corrupted blocks found: 0

Total all checksum error blocks found: 0

Total bad blocks found: 1399886

Executiontime: 10507.00 seconds

===============================================

sapprd2:oraprd 8> sqlplus /assysdba

SQL*Plus: Release 11.2.0.4.0 ProductiononMon Aug 3 18:41:28 2026

Copyright (c) 1982, 2013, Oracle.Allrights reserved.

Connectedto:

OracleDatabase11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

Withthe Partitioning, OLAP, Data MiningandRealApplication Testing options

SQL>selectstatusfromv$instance;

STATUS

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

STARTED

SQL>alterdatabasemount;

alterdatabasemount

*

ERRORatline 1:

ORA-00214: control file'/oracle/PRD/origlogA/cntrl/cntrlPRD.dbf'version

9742943 inconsistentwithfile'/oracle/PRD/sapdata1/cntrl/cntrlPRD.dbf'

version 9742931

sapprd2:oraprd 11> sqlplus /assysdba

SQL*Plus: Release 11.2.0.4.0 ProductiononMon Aug 3 18:42:53 2026

Copyright (c) 1982, 2013, Oracle.Allrights reserved.

Connectedto:

OracleDatabase11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

Withthe Partitioning, OLAP, Data MiningandRealApplication Testing options

SQL>alterdatabasemount;

Databasealtered.

SQL>alterdatabasedatafile 62,84 offline;

Databasealtered.

SQL> recoverdatabase;

Media recovery complete.

SQL>alterdatabaseopen;

Databasealtered.

BBED> copyfile83 block 1 tofile84 block 1

File:/oracle/PRD/sapdata3/sr3_76/sr3.data76 (84)

Block: 1 Offsets: 0 to 31 Dba:0x15000001

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

0ba20000 14c00001 00000000 00000104 22250000 00000000 0b200000 72bc991d

<32 bytes per line>

BBED>setoffset 368

OFFSET 368

BBED> d

File:/oracle/PRD/sapdata3/sr3_76/sr3.data76 (84)

Block: 1 Offsets: 368 to 399 Dba:0x15000001

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

00000053 00000000 00000000 495dc097 00000000 00000000 00000000 00000000

<32 bytes per line>

BBED> m/x00000054

File:/oracle/PRD/sapdata3/sr3_76/sr3.data76 (84)

Block: 1 Offsets: 368 to 399 Dba:0x15000001

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

00000054 00000000 00000000 495dc097 00000000 00000000 00000000 00000000

<32 bytes per line>

BBED>setoffset 52

OFFSET 52

BBED> d

File:/oracle/PRD/sapdata3/sr3_76/sr3.data76 (84)

Block: 1 Offsets: 52 to 83 Dba:0x15000001

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

00530003 00000000 00000000 00000000 00000000 00000000 00000000 00000000

<32 bytes per line>

BBED> m/x0054

File:/oracle/PRD/sapdata3/sr3_76/sr3.data76 (84)

Block: 1 Offsets: 52 to 83 Dba:0x15000001

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

00540003 00000000 00000000 00000000 00000000 00000000 00000000 00000000

<32 bytes per line>

BBED>setoffset 4

OFFSET 4

BBED> d

File:/oracle/PRD/sapdata3/sr3_76/sr3.data76 (84)

Block: 1 Offsets: 4 to 35 Dba:0x15000001

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

14c00001 00000000 00000104 22250000 00000000 0b200000 72bc991d 50524400

<32 bytes per line>

BBED> m/x15000001

File:/oracle/PRD/sapdata3/sr3_76/sr3.data76 (84)

Block: 1 Offsets: 4 to 35 Dba:0x15000001

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

15000001 00000000 00000104 22250000 00000000 0b200000 72bc991d 50524400

<32 bytes per line>

BBED> m/xE1B0

Warning: contents of previous BIFILE will be lost. Proceed? (Y/N) y

File:/oracle/PRD/sapdata3/sr3_76/sr3.data76 (84)

Block: 1 Offsets: 100 to 611 Dba:0x15000001

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

e1b0853f 00040000 4083fcfe 33606b63 02502452 0000ca28 49680fb3 93b9f6b9

<32 bytes per line>

BBED>setoffset +2

OFFSET 102

BBED> m/x8542

File:/oracle/PRD/sapdata3/sr3_76/sr3.data76 (84)

Block: 1 Offsets: 102 to 613 Dba:0x15000001

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

85420004 00004083 fcfe3360 6b630250 24520000 ca284968 0fb393b9 f6b90005

<32 bytes per line>

BBED>sum

Check valueforFile 84, Block 1:

current = 0x2225, required = 0x23e5

BBED>sumapply

Check valueforFile 84, Block 1:

current = 0x23e5, required = 0x23e5

BBED> verify

DBVERIFY - Verification starting

FILE =/oracle/PRD/sapdata3/sr3_76/sr3.data76

BLOCK = 1

DBVERIFY - Verification complete

Total Blocks Examined : 1

Total Blocks Processed (Data) : 0

Total Blocks Failing (Data) : 0

Total Blocks Processed (Index): 0

Total Blocks Failing (Index): 0

Total Blocks Empty : 0

Total Blocks Marked Corrupt : 0

Total Blocks Influx : 0

Message 531 not found; product=RDBMS; facility=BBED

SQL>alterdatabaseopen;

alterdatabaseopen

*

ERRORatline 1:

ORA-01122:databasefile 62 failed verificationcheck

ORA-01110: data file 62:'/oracle/PRD/sapdata2/sr3_54/sr3.data54'

ORA-01200: actual filesizeof1279999issmaller than correctsizeof1280000

Read of datafile'/oracle/PRD/sapdata2/sr3_54/sr3.data54'(fno 62) header failed with ORA-01202

Rereading datafile 62 header failed with ORA-01202

Errorsinfile/oracle/PRD/saptrace/diag/rdbms/prd/PRD/trace/PRD_ora_11272278.trc:

ORA-01122: databasefile62 failed verification check

ORA-01110: datafile62:'/oracle/PRD/sapdata2/sr3_54/sr3.data54'

ORA-01202: wrong incarnation of thisfile- wrong creationtime

Rereading datafile 84 header failed with ORA-01203

Errorsinfile/oracle/PRD/saptrace/diag/rdbms/prd/PRD/trace/PRD_ora_17105252.trc:

ORA-01122: databasefile84 failed verification check

ORA-01110: datafile84:'/oracle/PRD/sapdata3/sr3_76/sr3.data76'

ORA-01203: wrong incarnation of thisfile- wrong creation SCN

Errorsinfile/oracle/PRD/saptrace/diag/rdbms/prd/PRD/trace/PRD_ora_17105278.trc:

ORA-01122: databasefile62 failed verification check

ORA-01110: datafile62:'/oracle/PRD/sapdata2/sr3_54/sr3.data54'

ORA-01207:fileismorerecent than controlfile- old controlfile

ORA-1122 signalled during: alter databaseopen.

SQL> startup mount;

ORA-32004: obsoleteordeprecated parameter(s) specifiedforRDBMS instance

ORACLE instance started.

Total SystemGlobalArea 3.7548E+10 bytes

FixedSize2254136 bytes

VariableSize1.9193E+10 bytes

DatabaseBuffers 1.8254E+10 bytes

Redo Buffers 98996224 bytes

Databasemounted.

SQL>alterdatabaseopen;

Databasealtered.

SQL>selectstatus,count(1)fromv$datafile_headergroupbystatus;

STATUSCOUNT(1)

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

ONLINE 84