bad block from BRrestore SAP/Oracle (cpio) of > 4G table - Restri ctions ?

From: Mullin, Stephen \(CAP, ITS, US\) <"Mullin,>
Date: Tue, 16 Dec 1997 09:05:20 -0600

Hello folks...


 We've just found that out backup tapes give a error when reading a
block from our
(full) backup tapes. BAD news... details are:

   Backups done via SAP's BRbackup which calls cpio -> NSR to perform a
DB backup
   of tables.

   This table is 4 Gig exactly (SAP uses cpio)

   The same error is seen on all three of out backups, same table, same
point.

        nwrecover: Unable to read checksum from save streamnwrecover:
error recovering
        ./sapdata3/btabd_1/btabd.data1
        Error encountered on the following files by NSR server
`waltp51p.gecits.ge.com': can not read
        record 12500 of file 131 on tz89 tape brbackup.014
                ./sapdata3/btabd_1/btabd.data1 _at_ Wed Dec 10 04:42:41
1997
        nwrecover: Requesting remaining 2 files from NSR server
`waltp51p.gecits.ge.com'
                ./sapdata2/btabi_1/btabi.data1
                ./sapdata2/btabi_1/btabi.data1: file exists, overwriting
        nwrecover: Unable to read checksum from save streamnwrecover:
error recovering
                ./sapdata2/btabi_1/btabi.data1
        Error encountered on the following files by NSR server
`waltp51p.gecits.ge.com': can not read
        record 12500 of file 113 on tz89 tape brbackup.011
                ./sapdata2/btabi_1/btabi.data1 _at_ Wed Dec 10 04:42:38
1997



   No errors were seen in the BRbackup logs, error shows up during
restore.
_______________

  - Could cpio have a problem with > 4gig files
  - If it is data corruption, in the table, how come it wasn't seen
during backup.

NOTE: The database and files were fine before this full restore
attempt.
                (were in stress test, test->restore->test->restore
etc........)

Config:

  DU 4.0b SAP 3.1g Oracle 7.2.3 NSR 4.3
Received on Wed Dec 17 1997 - 00:34:54 NZDT

This archive was generated by hypermail 2.4.0 : Wed Nov 08 2023 - 11:53:37 NZDT