Skip to Content
0
Former Member
Jul 19, 2007 at 01:17 PM

BR restore ERROR

36 Views

Dear Experts,

While restorring Database, i'm getting the error:-

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

************************************************

i request you to give your inputs to sort out this CPIO errors

thanking you by

raghav