Bacup problem on NT 4.0

[shantanu125]

Hi All ,

we are getting some problem while taking backup.

The "Application" error message that keeps coming and repeated all the day
long is:

"NetWorker media: (critical) backup to pool 'Default' waiting for 1 writable
backup tape(s)"

we 've written batch scripts to take backup. The backup is cold backup and we have scheduled it in night.
Our automatic backup has these steps
1. oracle export
2. oracle shutdown
3. copy 1 above and all datafiles to disc
4. copy 1 above and all datafiles to tape
5. restart oracle
6. run analyze script

Sometimes the tape ejects. When it happens
we have to restarts the oracle instance in the morning manually for oracle to startup. Whenever this happens(tape eject) NT event viewer logs "device is not ready".

I did some R&D and found out that this message "NetWorker media: (critical) backup to pool 'Default' waiting for 1 writable backup tape(s)" appears due to Legato storage manager which gets installed along with Oracle by default.

I think uninstalling Legato will remove this message. But what to do with this tape ejection. Is this a hardware problem. I want to write a script which shows such an error in a log and error doesnt stop restarting of the database.

Any advise.

Shantanu

 

[did02]

Hi,

First of all, are your sure your tape is not full ? Make sure you don't back up in APPEND mode. Moreover, if your device allows it, use hardware compression (it save time).

Then, if your media has been used by legato before and you want to re-use it without legato, you have to format your tape.

Hope this help you

Did02