cancel
Showing results for 
Search instead for 
Did you mean: 

Brrestore in linux

Former Member
0 Kudos

Dear expert,

we are facing a systax error problem in Prdouction server on linux.

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.

Points assured.

by

raghav

Accepted Solutions (0)

Answers (2)

Answers (2)

andreas_herzog
Active Contributor
0 Kudos

have a deep look into <b>sapnotes 4161, 4164, 23.470 and 43.490</b>

GreetZ, AH

Former Member
0 Kudos

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 AH,

I'm getting this CPIO warning messages and the tape is geeting ejected out

i request you to hel p me out in this problem .

how to avoid this problem.

thanking you

by

raghav

former_member204746
Active Contributor
0 Kudos

stop duplicating your posts all over the place!

please stop!

0 Kudos

Use BRTOOLS.

It is an interface ( text based ) where you indicate the type of restore/recovery you want to perform and it will call BRRESTORE/BRRECOVER with the correct options.

<i>what is the importance of BR-recovery, is that mandatory to do ?</i>

I strongly rcommend you to read the tools guide. It looks like you do not know the difference between "RESTORE" ( copy files from tape to disk ) and "RECOVER" ( apply redologs when needed )

Also read the Oracle concept and Backup guide.

I do not understand how someone can "try" to "restore" a database without knowing the difference between "restore" and "recover" (just guessing, and the different recover methods)

<i>

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

<b>If</b> you do a correct restore ( and recovery if needed ) then SAP will start

I do not dare to give you any recommended parameters as those depend strongly on

- Type of backup that you have

- If the database is on archive log mode

- what kind of recovery you want to perform