Link to home
Create AccountLog in
Avatar of jeffrey_b_lee
jeffrey_b_leeFlag for United States of America

asked on

How to check for possible Oracle database 11g corruption?

Our Oracle 11g database unexpectly rebooted (the cause is still being investigated but was not related to the OS or Oracle).  I just want to make sure that there are no issues with the database itself.  Is there internal checking that Oracle 11g does by itself to make sure the database is okay?  Or is there a command that should be ran to verify this?
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Oracle does this all by itself on startup for the most part.  The alert log will show the crash recovery.

There is a utility called dbv that will perform block checks.

You can also check this with RMAN:
http://sysdba.wordpress.com/2006/04/05/how-to-check-for-and-repair-block-corruption-with-rman-in-oracle-9i-and-oracle-10g/
ASKER CERTIFIED SOLUTION
Avatar of anumoses
anumoses
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of jeffrey_b_lee

ASKER

It should be the database server rebooted unexpectedly.  Treat it as a loss of power.
>>It should be the database server rebooted unexpectedly.  Treat it as a loss of power.

I don't understand what you are saying here?