Skip to Content
avatar image
Former Member

PSAPUNDO tablespace interfereing with SAP database backup

My UNDO tablespace has grown (currently 9GB) and as a result I'm getting an error when attempting backup. Resulting error is shown below

BR0204I Percentage done: 94.11%, estimated end time: 4:20

BR0001I ***********************************************___

BR0202I Saving /oracle/DEV/sapdata3/undo_1/undo.data1

BR0203I to /dev/rmt/0mn ...

BR0278E Command output of 'LANG=C cd /oracle/DEV/sapdata3/undo_1 && echo undo.data1 /usr/sap/DEV/SYS/exe/run/brtools -f detach LANG=C cpio -ovB -Hodc > /dev/rmt/0mn':

cpio: cpio: undo.data1: too large to archive in current mode

BR0240E Size 5120 of saved/restored data is different from the size 9227476992 of file/save set /oracle/DEV/sapdata3/undo_1/undo.data1

10 blocks

1 error(s)

BR0280I BRBACKUP time stamp: 2009-11-17 03.54.28

BR0279E Return code from 'LANG=C cd /oracle/DEV/sapdata3/undo_1 && echo undo.data1 /usr/sap/DEV/SYS/exe/run/brtools -f detach LANG=C cpio -ovB -Hodc > /dev/rmt/0mn': 1

BR0222E Copying /oracle/DEV/sapdata3/undo_1/undo.data1 to/from /dev/rmt/0mn failed due to previous errors

BR0280I BRBACKUP time stamp: 2009-11-17 03.54.31

BR0304I Starting and opening database instance DEV ...

BR0280I BRBACKUP time stamp: 2009-11-17 03.54.50

BR0305I Start and open of database instance DEV successful

BR0056I End of database backup: bebxtins.aft 2009-11-17 03.54.28

BR0280I BRBACKUP time stamp: 2009-11-17 03.54.52

BR0054I BRBACKUP terminated with errors

I've tried resizing the datafile in order to reduce the size but Oracle error 03297

03297, 00000, "file contains used data beyond requested RESIZE value"

*Cause: Some portion of the file in the region to be trimmed is

currently in use by a database object

*Action: Drop or move segments containing extents in this region prior to

resizing the file, or choose a resize value such that only free

space is in the trimmed.

kindly advice on the way forward

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Nov 17, 2009 at 08:59 AM

    Hello,

    The likely cause is that cpio cannot handle output files greater than 2 Gigabytes. To get round this you have to use dd instead of cpio. In the initDEV.sap profile, set following parameter:

    tape_copy_cmd = dd

    This will address the backup issue but of course it isn't going to make your PSAPUNDO smaller. If you want to reduce the PSAPUNDO, then let us know and I'll provide you with the procedure.

    Regards,

    Mark

    Add comment
    10|10000 characters needed characters exceeded