Q

RMAN vs. dbverify utility

You have mentioned the use of the dbverify utility to check for errors in a datafile. Can we not also use RMAN to detect corrupt blocks and also to spot bad spots on disks? If we can use RMAN to cover both the above cases, what is the advantage/disadvantage of using RMAN vs. dbv?

This is in regards to "Input/Output errors" (31 Aug 05). You mentioned the use of the dbverify utility to check for errors in a datafile in this discussion.

Can we not also use RMAN to detect corrupt blocks and also to spot bad spots on disks? If we can use RMAN to cover both the above cases, what is the advantage/disadvantage of using RMAN vs. dbv? Thanks.

RMAN can be used to detect block corruption when performing a backup. There are also initialization parameters (like DB_BLOCK_CHECKING) which will detect block corruption on block access. There is nothing wrong with using these two techniques for detecting block corruption. The dbverify utility will check the entire datafile for block corruption on demand. You can fire up the dbverify utility and have it verify the datafile. Or, you can ensure that you perform a datafile backup with RMAN or read each and every block in the datafile with SQL statements for the other two options. Personally, when I need to verify blocks, it is easier to fire up one utility (dbv) to determine if corruption exists. The other two methods are primarily used to determine block corruption at other times so as to catch it as early as possible.
This was first published in September 2005
This Content Component encountered an error

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close