Veritas NetBackup - Oracle Server Problem - Veritas Net Backup

This is a discussion on Veritas NetBackup - Oracle Server Problem - Veritas Net Backup ; Hi all, I am using Veritas NetBack 3.4 Business Server Backup schedules with the Oracle Backup option. Lately the following error occurred while I was trying to run the hot_database_backup script: .. .. -----------------Start of error Capture ------------------------ .. RMAN-08008: ...

+ Reply to Thread
Results 1 to 3 of 3

Thread: Veritas NetBackup - Oracle Server Problem

  1. Veritas NetBackup - Oracle Server Problem

    Hi all,

    I am using Veritas NetBack 3.4 Business Server Backup schedules with the
    Oracle Backup option.

    Lately the following error occurred while I was trying to run the
    hot_database_backup script:

    ..
    .. -----------------Start of error Capture ------------------------
    ..
    RMAN-08008: channel t2: starting incremental level 0 datafile backupset
    RMAN-08502: set_count=20 set_stamp=456345127 creation_time=12-MAR-02
    RMAN-08010: channel t2: specifying datafile(s) in backupset
    RMAN-08522: input datafile fno=00008
    name=/mydata02/oradata/mydb02/MY_DEV.dbf
    RMAN-08522: input datafile fno=00006 name=/mydata02/oradata/mydb02/i
    ndx01.dbf
    RMAN-08522: input datafile fno=00007 name=/mydata02/oradata/mydb02/
    drsys01.dbf
    RMAN-08522: input datafile fno=00002 name=/mydata02/oradata/mydb02/t
    ools01.dbf

    RMAN-08522: input datafile fno=00002 name=/mydata02/oradata/mydb02/t
    ools01.dbf
    RMAN-00571: ================================================== =========
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ================================================== =========
    RMAN-03007: retryable error occurred during execution of command: backup
    RMAN-07004: unhandled exception during command execution on channel t1
    RMAN-10035: exception raised in RPC: ORA-19502: write error on file
    "bk_19_1_456
    345126", blockno 129 (blocksize=512)
    ORA-27030: skgfwrt: sbtwrite2 returned error
    ORA-19511: sbtwrite2: sbtwrite2() failed.
    RMAN-10031: ORA-19624 occurred during call to
    DBMS_BACKUP_RESTORE.BACKUPPIECECRE
    ATE
    Recovery Manager complete.
    ..
    .. -----------------End of error Capture------------------------
    ..

    Does anyone know why it failed?

    My Environment Config:

    Veritas NetBackup 3.4 Business Server
    Solaris 8
    Oracle 8.1.7

    I am backing the data across several tapes

    Thanks in Advance !

    --



  2. Re: Veritas NetBackup - Oracle Server Problem

    Hi Kas,

    From the log you have attached I can see that the problem is on channel t1.
    Has the channel allocated successfully ?
    It could be a media problem, did you try to use new media for the backup ?
    Try to allocate the channels to disk instead of tape and see if the problem
    presist.

    Mickey

    "Kas Abrinski" wrote in message
    news:3c8ddcae@hronntp01....
    > Hi all,
    >
    > I am using Veritas NetBack 3.4 Business Server Backup schedules with the
    > Oracle Backup option.
    >
    > Lately the following error occurred while I was trying to run the
    > hot_database_backup script:
    >
    > .
    > . -----------------Start of error Capture ------------------------
    > .
    > RMAN-08008: channel t2: starting incremental level 0 datafile backupset
    > RMAN-08502: set_count=20 set_stamp=456345127 creation_time=12-MAR-02
    > RMAN-08010: channel t2: specifying datafile(s) in backupset
    > RMAN-08522: input datafile fno=00008
    > name=/mydata02/oradata/mydb02/MY_DEV.dbf
    > RMAN-08522: input datafile fno=00006 name=/mydata02/oradata/mydb02/i
    > ndx01.dbf
    > RMAN-08522: input datafile fno=00007 name=/mydata02/oradata/mydb02/
    > drsys01.dbf
    > RMAN-08522: input datafile fno=00002 name=/mydata02/oradata/mydb02/t
    > ools01.dbf
    >
    > RMAN-08522: input datafile fno=00002 name=/mydata02/oradata/mydb02/t
    > ools01.dbf
    > RMAN-00571: ================================================== =========
    > RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    > RMAN-00571: ================================================== =========
    > RMAN-03007: retryable error occurred during execution of command: backup
    > RMAN-07004: unhandled exception during command execution on channel t1
    > RMAN-10035: exception raised in RPC: ORA-19502: write error on file
    > "bk_19_1_456
    > 345126", blockno 129 (blocksize=512)
    > ORA-27030: skgfwrt: sbtwrite2 returned error
    > ORA-19511: sbtwrite2: sbtwrite2() failed.
    > RMAN-10031: ORA-19624 occurred during call to
    > DBMS_BACKUP_RESTORE.BACKUPPIECECRE
    > ATE
    > Recovery Manager complete.
    > .
    > . -----------------End of error Capture------------------------
    > .
    >
    > Does anyone know why it failed?
    >
    > My Environment Config:
    >
    > Veritas NetBackup 3.4 Business Server
    > Solaris 8
    > Oracle 8.1.7
    >
    > I am backing the data across several tapes
    >
    > Thanks in Advance !
    >
    > --
    >
    >




  3. Re: Veritas NetBackup - Oracle Server Problem


    Hi,

    I am having the same problem on a sporadic basis with multiple databases.
    Any solution yet ? Wondering why the inconsistency, sometimes works sometimes
    does not.

    Thanks !!!

+ Reply to Thread