Backup Problem

[shantanu125]

Hi All :-D ,

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)"

I have checked export log and everything is fine.

Can anyone help??

Shantanu

 

[PeteH2]

What backup application are you using ?
What time does the backup usually finish ?
What time did this backup finish ?
Why is it running during the day ?
How many tapes does it usually use ?

It sounds as if it hasnt completed and requires another tape. Have a look at the daily log and see what is written there.

HTH

Pete...

 

[shantanu125]

Hi,
thanx for reply Pete...

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

 

[PeteH2]

How new are the tapes ?
How often do you clean the tape heads ?

Pete...

 

[shantanu125]

Tapes are almost 2 years old.
Tape head is cleaned in almost 2 months.

I want to write a script that can log the error if tape ejects and continue with other steps(i.e. starting Oracle) in my backup process.

Any help.


shantanu