automate Oracle database backup on Windows 2000 server

10 pts.
Tags:
Backup
Database Backup
Oracle 8i
Oracle backup
Oracle database backup and recovery
Windows 2000 Server
Hello, I have to make a cold backup of our test database. The database is oracle 8.1.7 on a Windows 2000 server. I have made bat files to do this and have scheduled them in the Windows scheduled tasks application. This works fine. I check to see if my jobs have run successfully by looking the the scheduler log file. My question is Can I automate this to for example sending me an email with the results of the backup? I'm new to this part of Oracle so any help would be much appreciated. Thanks in advance. Mariane

Answer Wiki

Thanks. We'll let you know when a new response is added.

What you could do is have the results of the copy be sent to a log file in a particular location so that you could have a shortcut on your desktop to that location and look at the logs.

To do that, your .bat files would direct the output of the command like this: copy *.* > c:\results.log

In the log, you will see the files that got copied and at the end it will say x number of files copied. If it says that, it worked. Also, you might be able to find a program from the web that allows you to send email from DOS and attached the log file.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following