DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: tar backup failed, please help

Hybrid View

  1. #1
    Join Date
    Apr 2002
    Posts
    291

    tar backup failed, please help

    Hi all,
    we are running oracle 9.0.1.4.0 on linux 6.2.(Redhat). We have a tar backup which runs daily on a particular time. today its failed giving "Input/Output error". Here i'm pasting the logfile info, please help in debugging the cause of the error. Is it due to the problem with the tape device? The server is placed in remote place (at JN,US).

    Fri Nov 29 05:00:01 EST 2002

    Tarring up directories on cmsrpts...

    tar: Removing leading `/' from member names
    u09/mytools/
    tar: /dev/nst0: Cannot write: Input/output error
    tar: Error is not recoverable: exiting now
    Possible error in backup, check log file...

    tar: Removing leading `/' from member names
    u09/clients/
    u09/clients/afiedt.buf
    u09/clients/wvh/
    u09/clients/wvh/code/
    u09/clients/wvh/code/controlfiles/
    u09/clients/wvh/code/controlfiles/wvh_fin2.ctl
    u09/clients/wvh/code/controlfiles/wvh_atb.709
    u09/clients/wvh/code/controlfiles/wvh_atb1.bak
    u09/clients/wvh/code/controlfiles/wvh_atb1.ctl
    tar: /dev/nst0: Cannot write: Input/output error
    tar: Error is not recoverable: exiting now
    Possible error in backup, check log file...
    /dev/st0: Input/output error
    Script tar_u09.scr is finished.
    Fri Nov 29 05:00:05 EST 2002


    Thanks in advance for your valueable suggestions...
    PNRDBA

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Have you checked there is sufficent space on the target disk/tape? or that the tape is not corrupt?

    regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    Apr 2002
    Posts
    291
    The machine is in remote place (NJ,USA). i can't check it out physically.

    Thanks
    PNRDBA

  4. #4
    Join Date
    Nov 2002
    Posts
    3

    Thumbs up

    There is are 2 solutions for you

    1) Try checking your tape "logically" if not physically
    I mean write a dynamic PL/SQL code to check it I hope you ....Know

    2)Change the init parameter
    remote_tape_check=true and restart the database.

    Hope this helps...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width