on 03-23-2015 2:30 PM
Hi Folks,
While restoring the SAP ASE Sybase database (15.7.0.110) to (15.7.0.122) we are facing issue with load DB from latest backup.
Details Outline:
OS Type: Redhat - 6.2
SAP Application - ECC 6.0
Database - Sybase
Production DB Verison- 15.7.0.110
Sandbox DB Verison 15.7.0.122
Error Details:
Backup Server session id is: 5. Use this value when executing the'sp_volchanged' system stored procedure after fulfilling any volume changerequest from the Backup Server.
Backup Server: 4.10.2.1: Label validation error: first label not VOL1.
Backup Server: 6.31.2.4: Volume rejected.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error. This DUMP or LOAD
session must exit.
Backup Server: 6.32.2.3: /bkp/TRP_2015-03-22.dmp: volume not valid or not
requested (server: , session id: 5.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error. This DUMP or LOAD
session must exit.
Msg 8009, Level 16, State 1:
Server 'TRS', Line 1:
Error encountered by Backup Server. Please refer to Backup Server messages for
details.
Regards,
Soumya.
Hi All,
The issue is resolved now.
We have used the database load dump with override option.
> use master
>go
>load database <DB_SID> from "<path>/PRD.dmp" with override
>go
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
What was the dump command used? How many stripes were used?
Please post the dump command and the load command used.
Cory Sane
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
While restoring the SAP ASE Sybase database (15.7.0.110) to (15.7.0.122)
Hi,
I think you will can only restore from same version of DB to same version and then do upgrade or patch from 15.7.0.110 to 15.7.0.122
What error do you see in your backup server/logs ?
Kind Regards,
J
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
"Unrecoverable I/O or volume error" it happens when dump got corrupted, you should verify the dump is valid.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.