Restoring the SAP ASE Sybase database (15.7.0.110) to (15.7.0.122)

[Former Member]

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.

[Former Member]

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

[Former Member]

What was the dump command used? How many stripes were used?

Please post the dump command and the load command used.

Cory Sane

[Johan_sapbasis]

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

[Former Member]

The ASE engine allows for a dump/load method of upgrading.

[vishy]

"Unrecoverable I/O or volume error" it happens when dump got corrupted, you should verify the dump is valid.