Home » RDBMS Server » Backup & Recovery » getting the bad blocks
getting the bad blocks [message #148598] Fri, 25 November 2005 04:29 Go to next message
varaprasad_1261
Messages: 34
Registered: September 2005
Member
Hi all,

How can i get the badblocks list for oracle 9i using SQL query.
Thanx in advance.

With Regards
Vara Prasad
Re: getting the bad blocks [message #148647 is a reply to message #148598] Fri, 25 November 2005 14:28 Go to previous message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
hi,

If i m not wrong then you want to find the bad portion of of datafile & than want to repari it right.. i dont know any query but there is one utility by which you can find the corrupt block of datafile and you can repair it...

The name of the utiliy is dbverify.

• DBVERIFY is an external command-line utility that perform physical data structure integrity check.

• It can be used on offline or online database as well as backup files.

• Primarily when we need to ensure that backup database (or datafile) is valid before it is restored we use this utility.

• This utility can be run against an offline database, integrity check checks are significantly faster.

• DBVERIFY is only for use with datafiles , it will not work against control files or redo logs.


Example: - Using DBVERIFY to validate Disk Block of a Single Data file.
(When block size is of 2k)

D:\oracle\oradata\hclsunil>dbv FILE=system01.dbf feedback=100

below is output...
======================================================================================
DBVERIFY: Release 10.1.0.2.0 - Production on Thu Sep 15 11:36:48 2005

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

DBVERIFY - Verification starting: FILE = system01.dbf
................................................................................

........................................

DBVERIFY - Verification complete

Total Pages Examined : 52480
Total Pages Processed (Data) : 36535
Total Pages Failing (Data) : 0
Total Pages Processed (Index) : 4430
Total Pages Failing (Index) : 0
Total Pages Processed (Other) : 1633
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 9882
Total Pages Marked Corrupt : 0
Total Pages Influx : 0

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

Please read regarding dbverify utlity

Regard
Always Friend sunilkumar
Previous Topic: segmentation fault
Next Topic: While Taking Exp in 9.2.0.6
Goto Forum:
  


Current Time: Thu Dec 01 14:40:16 CST 2022