Sybase Restore Issue

[muhammadbilalattique_sidd]

Dear All

I am facing a problem while restoring Sybase ASE 15.7 from TSM. This is the output of DumpHist file

Sep  6 2014  3:27:17:390AM|syb_tsm::-SQR1 -DQR1::bck_qr1db_201409060300|11468799|*|0|101|1

and this is the out put of sp_querysmobj "syb_tsm", "/backuptemp/QR1/1.out", "QR1" file

Object Name (filespace)   : /QR1

Object Name (high level)  : /QR1.DB

Object Name (low level)   : /bck_qr1db_201409060300.0

Object Owner              : sybqr1

object Id (hi, lo)        : 0, 19532621

object Size Estimates     : 44, 4294967295

Object State              : ACTIVE

Backup Creation Date      : 9/6/2014 2:59:34

Backup Expiration Date    : 0/0/0 0:0:0

Copy Group                : 1

Object Machine Name       : DEFAULT

Object Compression Type   : NO TSM Compression

Object Encryption Type    : NO TSM Encryption

while i give this command on sybase

load database QR1 from "syb_tsm::/bck_qr1db_201409060300"

2> go

This give me the following error

Sep 14 14:47:50 2014: Backup Server: 4.141.2.24: [109] The 'api_read' call failed for database/archive device while working on stripe device 'syb_tsm::bck_qr1db_201409060300::000' with error number 0 (Error 0). Refer to your operating system documentation for further details.

Sep 14 14:47:50 2014: Backup Server: 6.31.2.4: Volume rejected.

Sep 14 14:47:50 2014: Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.  This DUMP or LOAD session must exit.

Sep 14 14:47:50 2014: Backup Server: 6.32.2.3: syb_tsm::bck_qr1db_201409060300::000: volume not valid or not requested (server: , session id: 30.)

Sep 14 14:47:50 2014: Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.  This DUMP or LOAD session must exit.

[former_member188883 · Accepted solution]

Hi ,

Please check in TSM whether you have backup available with credentials

bck_qr1db_201409060300

Regards,

Deepak Kori

[muhammadbilalattique_sidd · Accepted solution]

Dear All

It is fixed.

Below is the right answer

load database QR1 from "syb_tsm::-M::bck_qr1db_201409060300"

This command also mount the object in TSM

Regards

[Former Member]

Hi Muhammad ,

Do you know if it is possible to preconfigure the mountwait parameter [-M] above into the recovery commands used by sybrestore?

Regards

Craig