NT-RE: Database Down-Dump and Mail Event Logs

From: Scott Crabtree <scott_at_psscorp.com>
Date: Wed, 23 May 2001 15:16:30 -0700
Message-ID: <F001.0030C956.20010523144533@fatcity.com>

Here some help from Paul Drake on NT diagnostics tools you can put in place to send yourself event logs.
Sample code to email event logs
C:\>blat -install mail.mydomain.com
oracle_at_mydomain.com
Failed to open registry key for Blat profile , using default.
SMTP server set to mail.mydomain.com on port 25 with user oracle_at_mydomain.com, retry
1 time(s)
C:\>dumpel -F my_app_log.txt -L Application -c Dump successfully completed.
C:\>blat C:\my_app_log.txt -to
log_files_at_mydomain.com
Sending C:\my_app_log.txt to log_files_at_mydomain.com Login name is oracle_at_mydomain.com
<received email in the recipient email account>
dumpel.exe - NT command to dump the event logs to file - NT Resource Kit.
The book Windows Admin Scripting describes this on pg 279. ISBN 1-57610-881-3
D:\>dumpel /?
DumpEl usage:
-e nn Filters for event id nn (up to 10 may be
specified)
-f <filename> Output filename (default stdout)
-l <name> Dumps the specified log (system, application,
security)
-b Dumps a backup file (use -l to specify file name)
-m <name> Filters for events logged by name
-r Filters out events logged by name (must use -m
too)
-s <servername> Remote to servername
-t Use tab to separate strings (default is space)
-c Use comma to separate fields
-ns Do not output strings
-format <fmt> Specify output format. Default format
is
dtTCISucs
where

t - time
d - date
T - event type
C - event category
I - event ID
S - event source
u - user
c - computer
s - strings

blat.exe - NT freeware utility for sending mail with attachments
The book Windows Admin Scripting includes a routine to generate a spreadsheet of Backup Exec jobs using the Windows Scripting Host shell - but I haven't used WSH yet.
hth,
Paul

-----Original Message-----From: Burton, Laura L. [mailto:BurtonL_at_prismplus.com]Sent: Wednesday, May 23, 2001 5:36 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Database Down
 Amen
 Sister!! I am afraid you all will have to be my virtual party people, since I am the only one around here that got excited when the recovery was done...so have a great time!!
 
 Laura :)

-----Original Message-----From: Jacques Kilchoer [mailto:Jacques.Kilchoer_at_quest.com]Sent: Wednesday, May 23, 2001 3:12 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Database Down
 >-----Original Message----- >From: Burton, Laura L. [<A
 href="mailto:BurtonL_at_prismplus.com">mailto:BurtonL_at_prismplus.com] > >My database is up and with
 no data loss!!!
 Congratulations! I've done the exercises in Rama Velpuri's book, but when it comes to a live situation, it's a little more scary.
 So where's the party? Received on Wed May 23 2001 - 17:16:30 CDT