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

SQL> create table test as select * from dba_objects where rownum create index idx_test on test(object_id);

Index created.

SQL> select file_id, block_id, blocks from dba_extents where owner = 'LILC' and segment_name = 'IDX_TEST';

FILE_ID BLOCK_ID BLOCKS

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

6 6032 8

Storing from the fourth block to construct bad blocks,

RMAN> recover datafile 6 block 6035 clear;

Starting recover at 23-SEP-15

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=75 device type=DISK

allocated channel: ORA_DISK_2

channel ORA_DISK_2: SID=14 device type=DISK

Finished recover at 23-SEP-15

[oracle@cwogg ~]$ dbv userid=grid/grid file=+DATA/phub/datafile/llc01.dbf

DBVERIFY: Release 11.2.0.4.0 - Production on Wed Sep 23 08:51:16 2015

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

DBVERIFY - Verification starting : FILE = +DATA/phub/datafile/llc01.dbf

Page 6035 is marked corrupt

Corrupt block relative dba: 0x01801793 (file 6, block 6035)

Bad check value found during dbv:

Data in bad block:

type: 6 format: 2 rdba: 0x01801793

last change scn: 0x0000.001e13c3 seq: 0x1 flg: 0x04

spare1: 0x0 spare2: 0x0 spare3: 0x0

consistency value in tail: 0x13c30601

check value in block header: 0xc307

computed block checksum: 0x5f27

DBVERIFY - Verification complete

Total Pages Examined : 655360

Total Pages Processed (Data) : 7507

Total Pages Failing (Data) : 0

Total Pages Processed (Index): 1181

Total Pages Failing (Index): 0

Total Pages Processed (Other): 646167

Total Pages Processed (Seg) : 0

Total Pages Failing (Seg) : 0

Total Pages Empty : 504

Total Pages Marked Corrupt : 1

Total Pages Influx : 0

Total Pages Encrypted : 0

Highest block SCN : 0 (0.0)

Verify that there are bad blocks in this index:

SQL> SELECT tablespace_name, segment_type, owner,segment_name, partition_name FROM dba_extents WHERE file_id=6 and 6035 between block_id AND block_id+blocks-1;TABLESPACE_NAME SEGMENT_TY OWNER SEGMENT_NAME PARTITION_NAME--------------- ---------- -------- -------------- ------------------------------LLCINDEX LILC IDX_TEST

At this time, if the full table scan is normal, index scan error:

SQL> select object_id from test;

1000 rows selected.

Execution Plan

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

Plan hash value: 1357081020

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

| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |

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

| 0 | SELECT STATEMENT | | 1000 | 13000 | 6 (0)| 00:00:01 |

| 1 | TABLE ACCESS FULL| TEST | 1000 | 13000 | 6 (0)| 00:00:01 |

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

Note

-----

- dynamic sampling used for this statement (level=2)

Statistics

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

0 recursive calls

0 db block gets

81 consistent gets

0 physical reads

0 redo size

17797 bytes sent via SQL*Net to client

1250 bytes received via SQL*Net from client

68 SQL*Net roundtrips to/from client

0 sorts (memory)

0 sorts (disk)

1000 rows processed

SQL> select object_id from test where object_id

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.