Sybase Recovery shows Error:No Backup found , recovering from DR Site tape.

[Sritharan]

Hi,

This is my scenario

Primary Site

Networker Server - hq008is
Sybase Server - hq001mc


DR Site
Networker Server - dr002ca
Sybase Server - dr001mc



What we need to do is to recover the backup save set from DR Site to the Primary Site.
We already brought the tape in did a scan on the tape and can see the Volumes but the server associated was dr001mc and dr002ca.

So what we did is we deleted hq001mc and created it back with the client id of dr001mc.
Now after scanning the tape again, it shows backup BROWSEABLE and belongs to hq001mc but the index and bootstrap still attached to dr002ca.

Please refer to the attachment on the VOLUMES print screen.

Below are the command and error message that we get :

sybase@hq001mc% /usr/sbin/nsrsybrc -v -s 10.xx.x.x -t "10/01/09 23:59" -Uxxxxxxxx -Pxxxxxxx -dSYBASE:/BMS_SERVER/bms_hist3 SYBASE:/BMS_SERVER/bms_month
Recovering database "bms_month" to "bms_hist3".
24240:nsrsybrc: Error: no backup was found for database "bms_month".
75753:nsrsybrc: The recovery failed.


Thanks In Advance
Sri