Hello guys,
can somebody help me with following problem?
I need to backup Oracle database (many of them) using b/a TSM client by
putting Oracle into backup mode and backup all Oracle data files.
Because of activity on Oracle database, before putting Oracle database
into backup mode, I need to be sure that I have available tape drive for
backup
(backup will be done LAN-free using TSM STA).
My idea is to use script, which will select empty (or available, ie.
loaded but not used - idle) drives from drives table using select command
and then put one of them to offline until I have Oracle in backup mode,
and then put this drive back to online just before backup starts.
My problem is that from drives table it is not possible to get enough
information about state and activity of the drive. There is only
information whether drive is loaded or not.
Using "q mount" command I can get also information whether drive is "in
use" or "idle".
Is it possible to get this information also using some select command? Or
any other ideas?

Many thanks

Ing. Jozef Zatko
Login a.s.
Dlha 2, Stupava
tel.: (421) (2) 60252618