Re: healthcheck

Posted by ErmanArslansOracleBlog on Oct 03, 2016; 2:15pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/healthcheck-tp1355p1357.html

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.