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

Thread: Backup Failed

Hybrid View

  1. #1
    Join Date
    Jul 2000
    Posts
    50
    Hi!

    Does anyone know what does it mean by the following code.

    Extract of the log file:

    BR001I *******************_______________________________

    BR317I Alter tablespace PSAPEL30FD end backup successful.

    BR315I Alter tablespace PSAPEL30FI begin backup successful.

    BR202I Saving /oracle/DEV/sapdata2/el30fi_1/el30fi.data1
    BR203I to /dev/rmt/2mn ...

    #FILE..... /oracle/DEV/sapdata2/el30fi_1/el30fi.data1
    #SAVED.... el30fi.data1 DEVB121/22

    #FILE..... /oracle/DEV/sapdata2/el30fi_1/el30fi.data1
    #SAVED.... el30fi.data1 DEVB121/22

    BR280I Time stamp 2000-11-12 23.55.57
    #SAVED.... el30fi.data1 DEVB121/22

    BR280I Time stamp 2000-11-12 23.55.57
    BR063I 19 of 48 files processed - 8764.906 MB of 23272.812 MB done.
    BR204I Percentage done: 37.66%, estimated end time: 03:04
    BR001I *******************_______________________________

    BR317I Alter tablespace PSAPEL30FI end backup successful.

    BR315I Alter tablespace PSAPES30FD begin backup successful.

    ********I WANT TO KNOW THIS PART****************

    BR202I Saving /oracle/DEV/sapdata1/es30fd_1/es30fd.data1
    BR203I to /dev/rmt/2mn ... d.data1 | LANG=C cpio -ovB > /dev/rmt/2mn':/DEV/sapdata1/es30fd_1 && echo es30f
    (Using tape drive with immediate report mode enabled (reel #1).)
    write failed: I/O error
    Can't open /dev/tty.
    .data1 | LANG=C cpio -ovB > /dev/rmt/2mn': 2EV/sapdata1/es30fd_1 && echo es30fd
    ailed due to previous errors.pdata1/es30fd_1/es30fd.data1 to/from /dev/rmt/2mn f

    BR317I Alter tablespace PSAPES30FD end backup successful.

    BR056I End of database backup: bddzphlh ant 2000-11-13 00.13.57
    BR054I BRBACKUP terminated with errors.

    ------------------------------------------------------------------------

    Environment: Oracle 7.3.4; HP-UX 11.00; SAP application. What is /dev/tty directory.

    Appreciate your view in advance.


    Regards,

    abhi


  2. #2
    Join Date
    Aug 2000
    Location
    Belgium
    Posts
    342
    It looks to me like the application is trying to write something directly to a terminal ( /dev/tty ).

    This can happen when you run a program via crontab, and the program wants to write something directly to the terminal.
    Because it's a crontab job, no tty has been assigned to the process. When the application tries to write something to the terminal, it uses a not existing device, or a device you do not have the -w- right for, resulting in an I/O error.

    Hope this helps
    Gert

  3. #3
    Join Date
    Jul 2000
    Posts
    50
    Hi Gert!

    Thanks for your prompt reply.

    Yes it's a crontabs job. Device we use is DLT tape. I am still unable to figure it out why it was unable to write to tape at the middle of backup schedule.

    The case you said -w- right could not be possible error because 37.66% of job was successful. Is there anyway out that I can check that the tape we used is no good anymore.

    I am getting this error quite frequently. We recycle our tapes monthly.

    Hope to hear you/other dba experts again.

    Regards,


    abhi

  4. #4
    Join Date
    Aug 2000
    Location
    Belgium
    Posts
    342
    What I wanna say is that you want to write to device /dev/tty and 1) it does not exist or 2) you have no write permissions to that device.

    In your first post, you say that "(Using tape drive with immediate report mode enabled (reel #1).) "
    --> does this mean that the possible error messages are directly put on the screen.
    --> if so, I think that your problem is here.
    cpio want to print an error message but does not have a tty where he can put it.

    I do not know any 'fast' way to verify a tape.

    Regards
    Gert

  5. #5
    Join Date
    Jul 2000
    Posts
    50
    Thnks a lot Gert!

    Regards,

    abhi

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