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