healthcheck

[Roshan]

Hello Erman,

I have a checklist for daily healthcheck.

What do I need to check for

1. the Dataguard?(protection mode, the protection level, the role of the database, and switchover status)
the cluster

2. the cluster status

How do I check if dump is being done or not and how do I implement it?

Can you please see if I need to build up for more details?

Thanks,
Roshan

[Roshan]

Database_Healthcheck_checklist.docx

[ErmanArslansOracleBlog]

Hi Roshan,

1)For dataguard concept, read this: http://ermanarslan.blogspot.com.tr/2016/03/rdbms-high-level-overview-of-dataguard.html

So, what you need to check is, to see if there is a archive lag or gap between primary and standby.
Also check whether there are any errors reported in the primary and standby site (alert log check)
Check disk spaces and ensure that there is nothing which may prevent the log shipping and apply.
These kinds of things...

2)
According to the document you sent, it seems they want you to check cluster services and purge the log files.

For cluster check, you can use crsctl. Check this: https://docs.oracle.com/cd/E18283_01/rac.112/e16794/crsref.htm#CHECBCEB

Also, for purging the logs, check this: https://docs.oracle.com/cd/E14791_01/doc/rac.112/e10717/troubleshoot.htm#CHDFJIEG

and then check your filesystem and find if there are directories in which there are plenty of log files and consider purging afterwards.

[ErmanArslansOracleBlog]

Also read this for a comprehensive health check report:

http://ermanarslan.blogspot.com.tr/2015/03/ebs-health-check-preparing.html

[Roshan]

Thank you for your prompt response to my questions. I am reviewing the blogs on Dataguard and healthcheck. The articles are wonderful. The concept on Dataguard is simple and clear, especially the Standby Problem Analysis.

[ErmanArslansOracleBlog]

thanks for the feedback