Oracle 11g adrci
# adrci.cmd <<<<<
--------------------------------
# ADRCI script to find alert log errors
SPOOL /tmp/alert_log_errors.txt
ECHO "ALERT LOG ERRORS:"; SET HOME diag/rdbms/aptdb/aptdb; SHOW ALERT -TERM -P "MESSAGE_TEXT LIKE '%ORA-%'"
SPOOL OFF
---------------------------------
$adrci -script=adrci.cmd
-bash-3.2$ ls -ltr /tmp/alert_log_errors.txt
-rw-r----- 1 oracle dba 9766 Aug 3 14:50 /tmp/alert_log_errors.txt
No comments:
Post a Comment