Showing posts with label identify Oracle corruption by using DBVerify. Show all posts
Showing posts with label identify Oracle corruption by using DBVerify. Show all posts

Saturday, May 17, 2014

How to Identify and Repair Corruption in Oracle Databases if ‘DBVerify’ Utility Fails

DBVerify is an inbuilt utility of Oracle database that runs an integrity check on the database to verify the physical data structure. This utility can be performed for both online and offline Oracle databases as well as on your backup files. It proves to be very useful and comes very handy when you required identifying for corruption issues and ensuring that your database or data file are constant. However, this tool can only used for cache-managed data blocks and it can perform faster checks, but it cannot verify control files or redo logs.