|
|
| Re: getting the bad blocks [message #148647 is a reply to message #148598] |
Fri, 25 November 2005 14:28  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
