Skip to Content
author's profile photo Former Member
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Mar 26, 2015 at 12:39 PM

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

    Please post the dump command and the load command used.

    Cory Sane

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 26, 2015 at 01:35 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 26, 2015 at 08:30 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 26, 2015 at 11:07 AM

    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

    Add comment
    10|10000 characters needed characters exceeded