Skip to Content
0
Former Member
Feb 15, 2009 at 07:43 AM

Restoration error

88 Views

Dear Team,

I am restoring data from tape drive of SAP data,but during restoration this problem is comming.

quality:oraqas 19> brrestore -c force -b bdzvcstv.aft -m /oracle/PRD/sapdata3/undo_1/undo.data1

BR0401I BRRESTORE 7.00 (18)

BR0405I Start of file restore: rdzxwdaq.rsb 2009-02-15 12.24.52

BR0454W Values of oracle_sid are different: current 'QAS', backup bdzvcstv.aft 'PRD'

BR0455W Value 'QAS' of oracle_sid will be used for restore

BR0454W Values of oracle_home are different: current '/oracle/QAS/102_64', backup bdzvcstv.aft '/oracle/PRD/102_64'

BR0455W Value '/oracle/QAS/102_64' of oracle_home will be used for restore

BR0454W Values of sapdata_home are different: current '/oracle/QAS', backup bdzvcstv.aft '/oracle/PRD'

BR0455W Value '/oracle/QAS' of sapdata_home will be used for restore

BR0454W Values of compress/-k are different: current 'hardware', backup bdzvcstv.aft 'yes'

BR0455W Value 'yes' of compress will be used for restore

BR0427I Files from the old sapdata_home /oracle/PRD will be restored into the new sapdata_home /oracle/QAS

BR0457I Probably the database must be recovered due to partial restore

BR0280I BRRESTORE time stamp: 2009-02-15 12.24.53

BR0407I Restore of database: QAS

BR0408I BRRESTORE action ID: rdzxwdaq

BR0409I BRRESTORE function ID: rsb

BR0449I Restore mode: partial

BR0411I Database file for restore: /oracle/QAS/sapdata3/undo_1/undo.data1

BR0419I Files will be restored from backup: bdzvcstv.aft 2009-01-31 23.50.59

BR0416I 1 file found to restore, size 8940.008 MB

BR0423I Files will be decompressed

BR0421I Restore device type: tape

BR0102I Following backup device will be used: /dev/rmt/0mn

BR0103I Following backup volume will be used: PRD_OFF_3 (2009-01-31 23.50.59)

BR0134I Unattended mode with 'force' active - no operator confirmation allowed

BR0208I Volume with name PRD_OFF_3 (2009-01-31 23.50.59) required in device /dev/rmt/0mn

BR0280I BRRESTORE time stamp: 2009-02-15 12.24.53

BR0226I Rewinding tape volume in device /dev/rmt/0m ...

BR0351I Restoring /oracle/QAS/sapbackup/.tape.hdr0

BR0355I from /dev/rmt/0mn ...

BR0241I Checking label on volume in device /dev/rmt/0mn

BR0209I Volume in device /dev/rmt/0mn has name PRD_OFF_3 (2009-01-31 23.50.59)

BR0280I BRRESTORE time stamp: 2009-02-15 12.25.20

BR0199I Volume label checked successfully

BR0428W File /oracle/QAS/sapreorg/undo.data1.Z will be overwritten

BR0351I Restoring /oracle/QAS/sapreorg/undo.data1.Z

BR0355I from /dev/rmt/0mn ...

BR0278E Command output of 'LANG=C dd ibs=128k bs=128k if=/dev/rmt/0mn of=/oracle/QAS/sapreorg/undo.data1.Z':

16384+0 records in

16383+1 records out

I/O error

BR0280I BRRESTORE time stamp: 2009-02-15 12.29.41

BR0279E Return code from 'LANG=C dd ibs=128k bs=128k if=/dev/rmt/0mn of=/oracle/QAS/sapreorg/undo.data1.Z': 2

BR0359E Restore of /oracle/QAS/sapreorg/undo.data1.Z from /dev/rmt/0mn failed due to previous errors

BR0406I End of file restore: rdzxwdaq.rsb 2009-02-15 12.29.41

BR0280I BRRESTORE time stamp: 2009-02-15 12.29.41

BR0404I BRRESTORE terminated with errors

quality:oraqas 20> brrestore -c force -b bdzvcstv.aft -m /oracle/QAS/sapdata1/system_2/system.data2

BR0401I BRRESTORE 7.00 (18)

BR0405I Start of file restore: rdzxweke.rsb 2009-02-15 12.40.16

BR0454W Values of oracle_sid are different: current 'QAS', backup bdzvcstv.aft 'PRD'

BR0455W Value 'QAS' of oracle_sid will be used for restore

BR0454W Values of oracle_home are different: current '/oracle/QAS/102_64', backup bdzvcstv.aft '/oracle/PRD/102_64'

BR0455W Value '/oracle/QAS/102_64' of oracle_home will be used for restore

BR0454W Values of sapdata_home are different: current '/oracle/QAS', backup bdzvcstv.aft '/oracle/PRD'

BR0455W Value '/oracle/QAS' of sapdata_home will be used for restore

BR0454W Values of compress/-k are different: current 'hardware', backup bdzvcstv.aft 'yes'

BR0455W Value 'yes' of compress will be used for restore

BR0437E File /oracle/QAS/sapdata1/system_2/system.data2 to be restored was not saved

BR0406I End of file restore: rdzxweke.rsb 2009-02-15 12.40.16

BR0280I BRRESTORE time stamp: 2009-02-15 12.40.16

BR0404I BRRESTORE terminated with errors

Thanks

manu