ADSM V3,1,0.6
AIX 4.3.2.0

STK-9710 with DLT7000 drives

Problem:

Trying to restore an oracle db backup that was backed up via SQL-BACTRACK.

Some of the files restore quickly.  Others mount a tape and seem to hang at
about 61.1k

Sess State changes from Run to IdleW.  When in Stat of Run the Wait Time
remains at 0 S, of course, yet nothing gets restored, and the session stays
in this state for hours.  If State is IdleW it can wait for hours.  The
session has the tape that it is requesting, but nothing happens.  Cancel of
the session seems to take forever.

The restores that seem to hang are usually trying to restore from two
specific tapes.  However there are only four tapes involved with this
restore.  Some files have been, quickly and successfully restored from the
suspect tapes as well.

EXAMPLE SESSION:
  Sess Comm.  Sess     Wait   Bytes   Bytes Sess  Platform Client Name
Number Method State    Time    Sent   Recvd Type
------ ------ ------ ------ ------- ------- ----- --------
--------------------
--------------------
 1,965 ShMem  Run      0 S   61.1 K     833 Node  SQL-BACKTRACK    WEICISP4
 1,965 ShMem  Run      0 S   61.1 K     833 Node  SQL-BACKTRACK    WEICISP4


Any ideas as to why this restore is taking so long would be greatly
appreciated.

If you require more information for proper analysis please ask.

ThanX

> Jim Taylor
> Senior Associate, Technical Services
> Enlogix
> *  E-mail: jtaylor AT enlogix DOT com
> *  Office: (416) 496-5264 ext. 286
> * Cell:  (416)458-6802
> *   Fax: (416) 496-5245
>
>