Unsolved
This post is more than 5 years old
31 Posts
0
2237
December 3rd, 2013 06:00
Sybase restore failed
I have the following bunch of error messages when invoking Sybase restore command. I looks as follows.
bash-3.2$ /usr/sbin/nsrsybrc32 -vvvv -U sa -P master12 -s RSBT-ISDNETWRKR -c rsb-dbtkondor1.rosbank.s.socgen SYBASE:/KONDORTEST
Recovering database "model" to "model".
24146:nsrsybrc32: Error from server KONDORTEST_back: Msg 412402, Level 2, State 1
Backup Server: 4.124.2.1: Archive API error for device='nsrsyb::'rsb-dbtkondor1.rosbank.rus.socgen'.KONDORTEST.model.20131203140831000.3./nsr/apps/tmp/sybtmp_21311.txt::00': Vendor application name=EMC, Library version=200, API routine=syb_read(), Message=XBSA-1.0.1 LNMs_2012.Build.352 21312 Tue Dec 3 14:48:56 2013 _nwbsa_open_restore_session: System detected error due to: Failed to establish restore session. Exiting. Operation aborted
24146:nsrsybrc32: Error from server KONDORTEST_back: Msg 603102, Level 2, State 4
Backup Server: 6.31.2.4: Volume rejected.
24146:nsrsybrc32: Error from server KONDORTEST_back: Msg 101402, Level 2, State 2
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error. This DUMP or LOAD session must exit.
24146:nsrsybrc32: Error from server KONDORTEST_back: Msg 603202, Level 2, State 3
Backup Server: 6.32.2.3: nsrsyb::'rsb-dbtkondor1.rosbank.rus.socgen'.KONDORTEST.model.20131203140831000.3./nsr/apps/tmp/sybtmp_21311.txt::00: volume not valid or not requested (server: , session id: 29.)
24146:nsrsybrc32: Error from server KONDORTEST_back: Msg 101402, Level 2, State 4
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error. This DUMP or LOAD session must exit.
24146:nsrsybrc32: Error from server KONDORTEST: Msg 8009, Level 16, State 1
Error encountered by Backup Server. Please refer to Backup Server messages for details.
Recovering database "sybsystemprocs" to "sybsystemprocs".
It sees the databases of the instance but fails to recover whem. I see that browsing session appears in Networker server monitoring, but nothing else happens.
I'm not a Sybase expert. Local Sybase admin is puzzled as well. Should I resort to tech support or the issue is quite simple and I just too dumb to resolve it?
0 events found
ble1
6 Operator
•
14.4K Posts
•
56.2K Points
0
December 3rd, 2013 10:00
To me above looks like as directed recovery - did you set the permissions that KONDORTEST_back can access data of rsb-dbtkondor1.rosbank.s.socgen?
Bancal
31 Posts
0
December 5th, 2013 19:00
In the source client features, I pointed out that user *@* has restore permissions. In the database administrators group I added sybase@* user. Otherwise, NMDA agrued about permissions.
Once I invoke restore command I see browsing session on theNetworker server side, then messages shown above appear.
yangjin
18 Posts
0
December 29th, 2014 22:00
HI Bancal,
have you solved the problem? I encounered the same question as you and I dont have much experience about sybase.
could you give some helps,thanks very much!