<div>
Hi &nbsp;sridharv9 ,<br />
Excellent. And it worked. <br />
Thanks a lot sridharv9 <br />
<br />
Sincerely,<br />
<br />
Kamal Agnihotri
</div>


Hi  sridharv9 ,
Excellent. And it worked.
Thanks a lot sridharv9

Sincerely,

Kamal Agnihotri

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I would like a Unix shell script that would run the SQL below to run via a cron job every hour. &nbsp;<br />
<br />
SELECT TYPE, STATUS, HIGH_SCN &nbsp; &nbsp;FROM V$LOGSTDBY;<br />
<br />
no rows selected<br />
<br />
If the query returns, &quot;no rows selected&quot; then I know for sure that Data Gurad has stopped. If the query returns, &quot;no rows selected&quot; , then I would like an e-mail trigerred to inform the DBAs that Data Guard has stopped. <br />
<br />
<br />

</div>
</div>


Hi Experts,

I would like a Unix shell script that would run the SQL below to run via a cron job every hour.  

SELECT TYPE, STATUS, HIGH_SCN    FROM V$LOGSTDBY;

no rows selected

If the query returns, "no rows selected" then I know for sure that Data Gurad has stopped. If the query returns, "no rows selected" , then I would like an e-mail trigerred to inform the DBAs that Data Guard has stopped. 




Script for Monitoring Data Guard

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.