error while restoring oracle database by using brrestore command

[Former Member]

Dear Experts ,

please check and give me your suggesitions on my issue

now we are trying to restore my oracle database from prd to quality

by using brrestore command

and it is terminated with an error at persent 30 %

error log

BR0278E command output of 'LANG=C dd ibs=64k if=/dev/rmt/ocbn of=/oracle/QAS/sapdata1/sr1_11/sr1.data11';

BR0359E Restore of /oracle/QAS/sapdata1/sr1_11/sr1.data11 from /dev/rmt/ocbn failed due to previous errors

BR0406I End of file restore

BR0404I brrestore terminated with errors

Regards

[Former Member · Accepted solution]

Hi Swathi,

Before performing the restore i would always restore control file from the backup to make sure that restore is working

brrestore -u / -b backupfilename -m 0=/tmp

Above command would restore the control file to tmp directory and if it works then it means that you have a good backup

to restore your database.Can you please check sapbackup directory and see if there are any additional logs present there.

Regards,

Ershad Ahmed.

Edited by: Ershad Ahmed on Oct 11, 2011 5:28 AM

[volker_borowski2 · Accepted solution]

Hi Swathi,
> 
> Before performing the restore i would always restore control file from the backup to make sure that restore is working

Hi,

he already restored 30%, so I think we can safely assume at least some stuff did work.

Allthough I agree that since the controlfile is saved last, this is a good test.

Seems to be either a dirty tape (clean drive, repeat) or a faulty backup ( ugh ).

When you retry after cleaning, you can use -f (fillup) to save the restore from retrieving the files it allready got.

Check the initSID.sap for the backup & restore commands and esp. the bs= / ibs= / obs= options.

Volker

[Former Member]

Hi,

Please make sure your PRD server backup is copied to target properly or not.

Please check the size of your copied backup size and source backup size.If some times files not copied properly means you cannot restore.

I hope it will help you.

Regards,

Kiran .V

[former_member213250]

Hi

Jus to give you bit more help, you must provide the logs and make sure you have recent BRTOOLs versions

Regards

Venkat

[Former Member]

Hi

Please share the complete error log .there must be something missing before BR0278E

Nirav Kundalia

[nirmal_konchada]

Hi,

Make sure that the initSID.sap parameters are exactly same in both the systems.

Your problem seems to be a change in ids values.

Regards,

Nirmal.K

[Former Member]

> BR0278E command output of 'LANG=C dd ibs=64k if=/dev/rmt/ocbn of=/oracle/QAS/sapdata1/sr1_11/sr1.data11';
> BR0359E Restore of /oracle/QAS/sapdata1/sr1_11/sr1.data11 from /dev/rmt/ocbn failed due to previous errors

Hello,

Could you check the logs in detail - seems something else has happened before 'BR0359E Restore of /oracle/QAS/sapdata1/sr1_11/sr1.data11 from /dev/rmt/ocbn failed due to previous errors'

Thanks