Shulou(Shulou.com)06/02 Report--

Problem description

RMAN backup failed with the error as follows:

General bad block handling process

1. First of all, determine which segment is broken, which is the index or the table?

Execute the following statement to see which paragraph is broken

SQL > Select b.segmentationnamejime b.segmentationtype from dba_extents a, dba_segments b

Where a.fileroomid= and between a.block_id and a.block_id+a.blocks-1

And a.segment_name=b.segment_name and a.owner=b.owner

The F here means file#,B, and it means block#.

two。 If it is a physical bad block, you need to replace the disk in several cases:

1) if it is a file system and has done raid, the messages will show which disk has gone wrong. Replace the disk and the system will recover the disk automatically.

2) if it is a file system and there is no raid, but there are backups and archives, the messages will show which disk has gone wrong, replace the disk, and then use data files to back up and archive, and online logs to recover to the last point in time.

3) if it is a file system and there is no raid and no backup, then follow the steps in step 3 below to restore the bad blocks and then replace the disk.

4) if asm manages the disk array, unplug the disk with the red light and replace it with a new one, and the system will automatically recover the disk.

3. If it is a logical bad block, it depends on whether it is an index bad block or a table bad block.

If it is a bad index block, then delete the index directly and rebuild the index.

If it is a bad watch block, there are three situations:

1) there are rman backups, and use rman backups to recover bad blocks. Command: blockrecover datafile file#.

This process

1. Use dbv to check if there are bad blocks of data

[oracle@svr1-219 backup_script] $dbv file=/oradata3/o219g2/income_gs_main_tst_tbs12.dbf

DBVERIFY: Release 10.2.0.4.0-Production on Fri Nov 2 11:52:58 2012

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

DBVERIFY-Verification starting: FILE = / oradata3/o219g2/income_gs_main_tst_tbs12.dbf

Page 386924 is marked corrupt

Corrupt block relative dba: 0x0d85e76c (file 54, block 386924)

Bad check value found during dbv:

Data in bad block:

Type: 6 format: 2 rdba: 0x0d85e76c

Last change scn: 0x02d1.805a7552 seq: 0x1 flg: 0x06

Spare1: 0x0 spare2: 0x0 spare3: 0x0

Consistency value in tail: 0x75520601

Check value in block header: 0x584e

Computed block checksum: 0xfbab

Page 404230 is marked corrupt

Corrupt block relative dba: 0x0d862b06 (file 54, block 404230)

Bad check value found during dbv:

Data in bad block:

Type: 6 format: 2 rdba: 0x0d862b06

Last change scn: 0x02d1.805a7552 seq: 0x1 flg: 0x06

Spare1: 0x0 spare2: 0x0 spare3: 0x0

Consistency value in tail: 0x75520601

Check value in block header: 0x339

Computed block checksum: 0x7b41

DBVERIFY-Verification complete

Total Pages Examined: 512000

Total Pages Processed (Data): 304782

Total Pages Failing (Data): 0

Total Pages Processed (Index): 115775

Total Pages Failing (Index): 0

Total Pages Processed (Other): 9000

Total Pages Processed (Seg): 0

Total Pages Failing (Seg): 0

Total Pages Empty: 82441

Total Pages Marked Corrupt: 2

Total Pages Influx: 0

Highest block SCN: 2163414262 (721.2163414262)

[oracle@svr1-219 backup_script] $

two。 See what object has a bad block

SQL > SELECT segment_type, owner, segment_name

2 FROM dba_extents

3 WHERE file_id = 54

4 and 386924 between block_id AND block_id + blocks-1

SEGMENT_TYPE OWNER SEGMENT_NAME

-

INDEX INCOME_GS_MAIN_TST PK_T_RPT_SOA_RECON_DETAIL

SQL > SELECT segment_type, owner, segment_name

2 FROM dba_extents

3 WHERE file_id = 54

4 and 404230 between block_id AND block_id + blocks-1

SEGMENT_TYPE OWNER SEGMENT_NAME

INDEX INCOME_GS_MAIN_TST PK_T_RPT_SOA_RECON_DETAIL

3. Deal with bad blocks

It is shown above as an index, which is relatively simple to deal with, and can be deleted and rebuilt.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.