source /home/oracle/.bash_profile

echo "<-----------The lasted archived log :----------->";

sqlplus -S '/as sysdba' <

alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';

select thread#,max(first_time),max(sequence#) from gv\$loghist group by thread#;

exit

!

echo "<-----------Info of rsnyc logs:----------->";

cd /data/run/log

tail -20 copyarch$ORACLE_SID.log

echo "<----------------Rsync Redolog:----------->";

cd /home/oracle/dba/arch$ORACLE_SID

ls -lt|grep -v total|head -4

echo "<-----------crontab status:----------->";

crontab -l

echo "<-----------disk space status:----------->";

df -h

来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/110321/viewspace-706926/ ，如需转载，请注明出处，否则将追究法律责任。

ITPub博客

每天检查DG的简单脚本