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

SYBASE Backup Error on database/archive while working on strip, i/o read call failed

Dear Gurus,

I am new to SAP SYBASE ASE.

I have SAP system installed with SYBASE 15.7 on SLES 11 Sp3.

After installation i have taken 4 to 5 successful backups in two months with below method

login with devadm

isql -Usapsa -SDEV -Ptest123

1>dump database DEV to "/backup/DEV/backups/filename.dmp"

2>go

its created 4 times successful backup with 73 GB.

Now i am getting below errors in backup

All spaces in backup directory and sybase directory are free.

Please help me and suggest the correct solution.

Best Regards,

QJ

Backup Error.jpg (373.3 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Posted on Jun 19, 2016 at 07:41 PM

    Hi Qazi,

    What did you see you in BS SID log for the backup database? Any errors matching time of failure in dmesg on O/S level?

    i/o would usually indicate disk or resource issue at time of failure. Please upload the BS SID log file.

    Kind Regards,

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 21, 2016 at 10:48 AM

    HI,

    try without the .dat

    johan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 23, 2016 at 08:30 AM

    Hi Qazi,

    1. To truncate the log check point,

    use master

    go

    sp_dboption <SID>, 'trunc', false

    go

    2. To add space,

    use master

    go

    disk resize
    name ='saptools_data_001',
    size='500M'

    go

    alter database <database name> on saptools_data_001='500M'

    go

    Please verify your database name with sp_helpdb command, refer the below link

    Sybase: Extending the transaction log

    Thanks and Regards,

    Mathan

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 27, 2016 at 08:43 AM

    Qazi,

    For your original issue of Backup failure, Please check the following :

    1) Check with taking the dump to a different directory (for example : /Sybase/DEV) as below :

    isql -Usapsa -SDEV

    1>dump database DEV to "/Sybase/DEV/filename.dmp"

    2>go

    2) If the above fails due to the same IO error , Please run the below consistency checks for the db :

    1> dbcc checkdb(DEV)

    2> go

    1> dbcc checkalloc (DEV)

    2> go

    ~Gaurav

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.