#!/bin/bash mask=`date '+%a %b %d %H'` sed -n "/$mask/,\$p" /u/app/oracle/alert_base.log | egrep 'ORA\-|TNS\-' >>файл отправки.txt
select t.message_text from v$diag_alert_ext t where t.originating_timestamp > sysdate - 1 and regexp_like(t.message_text,'(ORA-|TNS-)') and not regexp_like(t.message_text,'Patch Description')