|
Today's Oracle DBA typically uses RMAN for backup and recovery. But cold backups from your own scripts are still perfectly acceptable. What I typically do in your scenario is to create a wrapper script for my cold backup script. All the wrapper script does is to call the cold backup script and dump its output to a text file. The last thing the wrapper script does is email the text file's contents to me. So assume the cold backup script is called "cold_backup.bat". The wrapper script can look like the following:
C:script_dircold_backup.bat > C:script_dircold_backup.txt
Mail_routine C:script_dircold_backup.txt oracle_dba@acme.com
The wrapper script is pretty simple. The only thing that is that you need a mail routine to forward the file to you. On Unix/Linux, you could use mailx or something like that. For Windows, I use a utility called Blat for mailing these types of text files to my email account.
Once you have the wrapper script set up, schedule the wrapper script for execution, not the cold backup script.
|
