Restoration error

[Former Member]

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

[former_member220071 · Accepted solution]

Hi ,

In almost all cases, this error is caused by hardware or operating

system problems. Check the system, together with your hardware partner

and operating system partner, to correct the cause of the problem.

Then carry out a consistency check on the entire database, as

described in Note 23345, remove any inconsistencies using Note 365481

and restore the affected files from a backup.

Abhijeet

[Former Member]

hi,

It seems that you have problem with your tape or the drive.

ardhian

http://ardhian.kioslinux.com

http://sapbasis.wordpress.com

[Former Member]

are u trying to restore PRD backup into QAS?

well the error you specified relates to I/O error,I guess there are some issues with the tape drive that you are using

Rohit