BR-RESTORE problem

[Former Member]

Dear expert,

we are facing a systax error problem in Prdouction server.

after enquiry we concluded tht BRRESTORE is adviced to restore.

the default unattended option is not preffered for PRD restoration:-

BRRESTORE can run unattended when option -c force is set.

How exactly that can be used, example of syntax ?

can you suggest any other best options for BRrestore ?

Will SAP start if i try to start sap after BR-restore ?

what is the importance of BR-recovery, is that mandatory to do ?

i request you to give your input.

badly waiting for your inputs.

thanking you in advance.

By

Raghavendra

1. Points assured. ####

[former_member204746]

brrecover is a menu-driven program to help you restore your system.

so, if you do not feel comfortable, use it, if you know Oracle, use brrestore and do recovery steps manually afterwards... if this is needed.

[Former Member]

CDPRD:oraprd 60> brrestore -m full -b bdvslmwp.aft -c

BR0401I BRRESTORE 6.40 (22)

BR0405I Start of file restore: rdvsuwwe.rsb 2007-07-19 18.09.20

BR0428W File /oracle/PRD/data/sapdata3/prd_1/prd.data1 will be overwritten

BR0428W File /oracle/PRD/data/sapdata3/prd_2/prd.data2 will be overwritten

BR0428W File /oracle/PRD/data/sapdata3/prd_3/prd.data3 will be overwritten

BR0428W File /oracle/PRD/data/sapdata3/prd_4/prd.data4 will be overwritten

BR0428W File /oracle/PRD/data/sapdata4/prd_6/prd.data6 will be overwritten

BR0428W File /oracle/PRD/data/sapdata4/prd_8/prd.data8 will be overwritten

BR0428W File /oracle/PRD/data/sapdata4/prd_10/prd.data10 will be overwritten

BR0428W File /oracle/PRD/data/sapdata4/prd_9/prd.data9 will be overwritten

BR0428W File /oracle/PRD/data/sapdata4/prd_7/prd.data7 will be overwritten

BR0428W File /oracle/PRD/data/sapdata4/prd_10/prd.data13 will be overwritten

BR0428W File /oracle/PRD/data/sapdata4/prd_10/prd.data12 will be overwritten

BR0428W File /oracle/PRD/data/sapdata4/prd_10/prd.data11 will be overwritten

BR0428W File /oracle/PRD/data/sapdata3/prd_5/prd.data5 will be overwritten

BR0428W File /oracle/PRD/data/sapdata1/prd640_1/prd640.data1 will be overwritten

BR0428W File /oracle/PRD/data/sapdata1/prd640_2/prd640.data2 will be overwritten

BR0428W File /oracle/PRD/data/sapdata1/prd640_4/prd640.data4 will be overwritten

BR0428W File /oracle/PRD/data/sapdata2/prd640_6/prd640.data6 will be overwritten

BR0428W File /oracle/PRD/data/sapdata2/prd640_8/prd640.data8 will be overwritten

BR0428W File /oracle/PRD/data/sapdata2/prd640_10/prd640.data10 will be overwritten

BR0428W File /oracle/PRD/data/sapdata4/prd640_12/prd640.data12 will be overwritten

BR0428W File /oracle/PRD/data/sapdata4/prd640_13/prd640.data13 will be overwritten

BR0428W File /oracle/PRD/data/sapdata3/prd640_11/prd640.data11 will be overwritten

BR0428W File /oracle/PRD/data/sapdata2/prd640_9/prd640.data9 will be overwritten

BR0428W File /oracle/PRD/data/sapdata2/prd640_7/prd640.data7 will be overwritten

BR0428W File /oracle/PRD/data/sapdata1/prd640_5/prd640.data5 will be overwritten

BR0428W File /oracle/PRD/data/sapdata1/prd640_3/prd640.data3 will be overwritten

BR0428W File /oracle/PRD/data/sapdata4/prdusr_1/prdusr.data1 will be overwritten

BR0428W File /oracle/PRD/data/sapdata1/temp_1/temp.data1 will be overwritten

BR0428W File /oracle/PRD/data/sapdata1/undo_1/undo.data1 will be overwritten

BR0428W File /oracle/PRD/data/sapdata1/system_1/system.data1 will be overwritten

BR0428W File /oracle/PRD/origlogA/log_g11m1.dbf will be overwritten

BR0428W File /oracle/PRD/mirrlogA/log_g11m2.dbf will be overwritten

BR0428W File /oracle/PRD/origlogB/log_g12m1.dbf will be overwritten

BR0428W File /oracle/PRD/mirrlogB/log_g12m2.dbf will be overwritten

BR0428W File /oracle/PRD/origlogA/log_g13m1.dbf will be overwritten

BR0428W File /oracle/PRD/mirrlogA/log_g13m2.dbf will be overwritten

BR0428W File /oracle/PRD/origlogB/log_g14m1.dbf will be overwritten

BR0428W File /oracle/PRD/mirrlogB/log_g14m2.dbf will be overwritten

BR0428W File /oracle/PRD/origlogA/cntrl/cntrlPRD.dbf will be overwritten

BR0428W File /oracle/PRD/data/sapdata1/system_1/cntrl/cntrlPRD.dbf will be overwritten

BR0428W File /oracle/PRD/saparch/cntrl/cntrlPRD.dbf will be overwritten

BR0280I BRRESTORE time stamp: 2007-07-19 18.09.20

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE:

c

BR0280I BRRESTORE time stamp: 2007-07-19 18.09.27

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0280I BRRESTORE time stamp: 2007-07-19 18.09.27

BR0407I Restore of database: PRD

BR0408I BRRESTORE action ID: rdvsuwwe

BR0409I BRRESTORE function ID: rsb

BR0449I Restore mode: FULL

BR0411I Database files for restore:

/oracle/PRD/origlogA/log_g11m1.dbf

/oracle/PRD/mirrlogA/log_g11m2.dbf

/oracle/PRD/origlogB/log_g12m1.dbf

/oracle/PRD/mirrlogB/log_g12m2.dbf

/oracle/PRD/origlogA/log_g13m1.dbf

/oracle/PRD/mirrlogA/log_g13m2.dbf

/oracle/PRD/origlogB/log_g14m1.dbf

/oracle/PRD/mirrlogB/log_g14m2.dbf

/oracle/PRD/origlogA/cntrl/cntrlPRD.dbf

/oracle/PRD/data/sapdata1/system_1/cntrl/cntrlPRD.dbf

/oracle/PRD/saparch/cntrl/cntrlPRD.dbf

BR0419I Files will be restored from backup: bdvslmwp.aft 2007-07-17 20.20.27

BR0416I 35 files found to restore, total size 264320.932 MB

BR0424I Files will not be decompressed

BR0421I Restore device type: tape

BR0102I Following backup device will be used: /dev/nst0

BR0103I Following backup volume will be used: PRD2170707 (2007-07-17 20.20.27)

BR0280I BRRESTORE time stamp: 2007-07-19 18.09.27

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE:

c

BR0280I BRRESTORE time stamp: 2007-07-19 18.09.40

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0126I Unattended mode active - no operator confirmation required

BR0208I Volume with name PRD2170707 (2007-07-17 20.20.27) required in device /dev/nst0

BR0280I BRRESTORE time stamp: 2007-07-19 18.09.40

BR0226I Rewinding tape volume in device /dev/st0 ...

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

BR0355I from /dev/nst0 ...

BR0241I Checking label on volume in device /dev/nst0

BR0209I Volume in device /dev/nst0 has name PRD2170707 (2007-07-17 20.20.27)

BR0280I BRRESTORE time stamp: 2007-07-19 18.10.05

BR0199I Volume label checked successfully

BR0351I Restoring /oracle/PRD/data/sapdata3/prd_1/prd.data1

BR0355I from /dev/nst0 ...

BR0278E Command output of 'LANG=C cd /oracle/PRD/data/sapdata3/prd_1 && LANG=C cpio -iuvcB prd.data1 < /dev/nst0 && LANG=C mt -f /dev/nst0 fsf 1':

cpio: warning: skipped 79322336 bytes of junk

cpio: warning: skipped 542681129 bytes of junk

cpio: warning: skipped 169089187 bytes of junk

cpio: warning: skipped 4490772 bytes of junk

cpio: warning: skipped 7297164 bytes of junk

cpio: warning: skipped 3571036 bytes of junk

cpio: warning: skipped 32560979 bytes of junk

cpio: warning: skipped 2376064 bytes of junk

cpio: warning: skipped 1269138 bytes of junk

cpio: warning: skipped 613734 bytes of junk

cpio: warning: skipped 13541613 bytes of junk

cpio: warning: skipped 10854153 bytes of junk

cpio: warning: skipped 80328255 bytes of junk

cpio: warning: skipped 3251134 bytes of junk

Found end of tape. To continue, type device/file name when ready.

BR0280I BRRESTORE time stamp: 2007-07-19 18.23.46

BR0279E Return code from 'LANG=C cd /oracle/PRD/data/sapdata3/prd_1 && LANG=C cpio -iuvcB prd.data1 < /dev/nst0 && LANG=C mt -f /dev/nst0 fsf 1': 1

BR0359E Restore of /oracle/PRD/data/sapdata3/prd_1/prd.data1 from /dev/nst0 failed due to previous errors

BR0397E Verification of backup of /dev/nst0 using DBVERIFY failed due to previous errors

BR0406I End of file restore: rdvsuwwe.rsb 2007-07-19 18.23.46

BR0280I BRRESTORE time stamp: 2007-07-19 18.23.46

BR0404I BRRESTORE terminated with errors

##################################################

Hi Eric,

my Brrestore is getting terminated as follows.

What is actually CPIO error.

how to avoid these kind of error.

plz reply to this

thanking you in anticipation.

by

raghav

[former_member204746]

This does not look god at all. your tape looks defective.

try cleaning your tape drive and try operation again. if this still fail, try restoring from a previous backup, if this still fails.. well..errr... call your tape drive manufacturer for help.

[andreas_herzog]

sample could be:

brrestore -p init<SID>.sap -b xxxxx.aff -m full -c

plz have a thorough look at

sapnotes n°. 4157, 4161 and 4164

GreetZ, AH