Database Administration (MOSC)

MOSC Banner

How setup scheduler to run Heath check for data block automatically ?

edited Sep 18, 2011 3:08PM in Database Administration (MOSC) 5 commentsAnswered
 Hi all,

   I read about " Running Health Checks with Health Monitor " and my goal is : Setup scheduler to check Data Block Integrity Check automatically. This document said that: 
   Health checks can be run in two ways:
Reactive—The fault diagnosability infrastructure can run health checks automatically in response to a critical error.Manual—As a DBA, you can manually run health checks using either the DBMS_HM PL/SQL package or the Enterprise Manager interface. You can run checkers on a regular basis if desired, or Oracle Support may ask you to run a checker while working with you on a service request.  I can run health check for Data Block manual but I must enter datafile number and data block number parameters. Reactive = mean if my database server has error, oracle run this health check automatically ?? So, are there some way I can setup scheduler to run health check for data block on all data file ??  Thanks very much. 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center