BRRESTORE Logs: Restoring a Complete Backup (SAP Library - Database Administration (Oracle) with SAPDBA)

BRRESTORE Logs: Restoring a Complete Backup

This example shows the detail log of a BRRESTORE run, in which a complete backup was restored. This was done on two tape devices in parallel.

Call: brrestore -m full

BR401I BRRESTORE 4.0A

BR405I Start of database restore: rcvojvfh rsb 1997-09-10 18.57.09

BR101I Parameters

oracle_sid C11

oracle_home /oracle/C11

oracle_profile /oracle/C11/dbs/initC11.ora

sap_profile /oracle/C11/dbs/initC11.sap

backup_mode FULL

backup_dev_type tape

compress no

tape_copy_cmd cpio

cpio_in_flags -iuvB

cpio_disk_flags -pdcu

dd_in_flags ibs=16k bs=16k

rewind mt -t $ rew

rewind_offline mt -t $ offl

tape_pos_cmd mt -t $ fsf $

tape_address /dev/rmt/0mn,/dev/rmt/1mn

tape_address_rew /dev/rmt/0m,/dev/rmt/1m

exec_parallel 0

BR428W File /oracle/C11/sapraw/rawd_1 will be overwritten.

BR428W File /oracle/C11/sapdata2/roll_1/roll.data1 will be overwritten.

BR428W File /oracle/C11/sapdata3/stabd_1/stabd.data1 will be overwritten.

BR428W File /oracle/C11/sapdata4/stabi_1/stabi.data1 will be overwritten.

BR428W File /oracle/C11/sapdata2/temp_1/temp.data1 will be overwritten.

BR428W File /oracle/C11/sapdata3/testd_1/testd.data1 will be overwritten.

BR428W File /oracle/C11/sapdata4/testi_1/testi.data1 will be overwritten.

BR428W File /oracle/C11/sapdata1/system_1/system.data1 will be overwritten.

BR428W File /oracle/C11/origlogA/log_g11m1.dbf will be overwritten.

BR428W File /oracle/C11/mirrlogA/log_g11m2.dbf will be overwritten.

BR428W File /oracle/C11/origlogB/log_g12m1.dbf will be overwritten.

BR428W File /oracle/C11/mirrlogB/log_g12m2.dbf will be overwritten.

BR428W File /oracle/C11/origlogA/log_g13m1.dbf will be overwritten.

BR428W File /oracle/C11/mirrlogA/log_g13m2.dbf will be overwritten.

BR428W File /oracle/C11/origlogB/log_g14m1.dbf will be overwritten.

BR428W File /oracle/C11/mirrlogB/log_g14m2.dbf will be overwritten.

BR428W File /oracle/C11/sapdata1/cntrl/cntrlC11.dbf will be overwritten.

BR428W File /oracle/C11/sapdata2/cntrl/cntrlC11.dbf will be overwritten.

BR428W File /oracle/C11/sapdata3/cntrl/cntrlC11.dbf will be overwritten.

BR428W File /oracle/C11/sapdata4/cntrl/cntrlC11.dbf will be overwritten.

BR280I Time stamp 1997-09-10 18.57.10

BR256I Please enter 'cont' to continue, 'stop' to cancel the program:

BR257I Your reply: 'cont'

BR259I Program execution will be continued...

BR280I Time stamp 1997-09-10 18.57.13

BR407I Restore of database: C11

BR408I BRRESTORE action ID: rcvojvfh

BR409I BRRESTORE function ID: rsb

BR410I Tablespaces for restore: FULL

BR411I Database files for restore:

/oracle/C11/origlogA/log_g11m1.dbf

/oracle/C11/mirrlogA/log_g11m2.dbf

/oracle/C11/origlogB/log_g12m1.dbf

/oracle/C11/mirrlogB/log_g12m2.dbf

/oracle/C11/origlogA/log_g13m1.dbf

/oracle/C11/mirrlogA/log_g13m2.dbf

/oracle/C11/origlogB/log_g14m1.dbf

/oracle/C11/mirrlogB/log_g14m2.dbf

/oracle/C11/sapdata1/cntrl/cntrlC11.dbf

/oracle/C11/sapdata2/cntrl/cntrlC11.dbf

/oracle/C11/sapdata3/cntrl/cntrlC11.dbf

/oracle/C11/sapdata4/cntrl/cntrlC11.dbf

BR419I Files will be restored from backup: bcvojtgt.aft 1997-09-10 18.35.15

BR416I 13 files found to restore, total size 107.169 MB.

BR424I Files will not be decompressed.

BR421I Backup device type for restore: tape

BR102I Following backup devices will be used:

/dev/rmt/0mn,/dev/rmt/1mn

BR103I Following backup volumes will be used:

C11B06 1997-09-10 18.35.15, C11B05 1997-09-10 18.35.15

BR140I Number of parallel copy processes: 2.

BR280I Time stamp 1997-09-10 18.57.13

BR256I Please enter 'cont' to continue, 'stop' to cancel the program:

BR257I Your reply: 'cont'

BR259I Program execution will be continued...

BR208I Volume with name:

C11B06 1997-09-10 18.35.15 | C11B05 1997-09-10 18.35.15

required in device /dev/rmt/0mn

BR210I Please mount the volume, if you have not already done so.

BR280I Time stamp 1997-09-10 18.57.16

BR256I Please enter 'cont' to continue, 'stop' to cancel the program:

BR257I Your reply: 'cont'

BR259I Program execution will be continued...

BR280I Time stamp 1997-09-10 18.57.18

BR226I Rewinding tape volume in device /dev/rmt/0m...

BR351I Restoring /oracle/C11/sapbackup/.tape.hdr0

BR355I from /dev/rmt/0mn...

BR241I Checking label on volume in device /dev/rmt/0mn

BR209I Volume in device /dev/rmt/0mn has name C11B05 1997-09-10 18.35.15

BR208I Volume with name C11B06 1997-09-10 18.35.15 required in device /dev/rmt/1mn

BR210I Please mount the volume, if you have not already done so.

BR280I Time stamp 1997-09-10 18.57.19

BR256I Please enter 'cont' to continue, 'stop' to cancel the program:

BR257I Your reply: 'cont'

BR259I Program execution will be continued...

BR280I Time stamp 1997-09-10 18.57.21

BR226I Rewinding tape volume in device /dev/rmt/1m...

BR351I Restoring /oracle/C11/sapbackup/.tape.hdr0

BR355I from /dev/rmt/1mn...

BR241I Checking label on volume in device /dev/rmt/1mn

BR209I Volume in device /dev/rmt/1mn has name C11B06 1997-09-10 18.35.15

BR351I Restoring /oracle/C11/sapraw/rawd_1

BR355I from /dev/rmt/1mn...

BR351I Restoring /oracle/C11/sapdata1/system_1/system.data1

BR355I from /dev/rmt/0mn...

#FILE..... /oracle/C11/sapraw/rawd_1

#RESTORED. rawd_1 C11B06/4

BR280I Time stamp 1997-09-10 18.57.57

BR418I 1 of 13 files restored - 10.008 MB of 107.169 MB done.

BR204I Percentage done: 9.34%, estimated end time: 19:03

BR001I *****_____________________________________________

BR351I Restoring /oracle/C11/sapdata3/stabd_1/stabd.data1

BR355I from /dev/rmt/1mn...

#FILE..... /oracle/C11/sapdata3/stabd_1/stabd.data1

#RESTORED. stabd.data1 C11B06/5

BR280I Time stamp 1997-09-10 18.58.24

BR418I 2 of 13 files restored - 20.016 MB of 107.169 MB done.

BR204I Percentage done: 18.68%, estimated end time: 19:02

BR001I *********_________________________________________

BR351I Restoring /oracle/C11/sapdata4/stabi_1/stabi.data1

BR355I from /dev/rmt/1mn...

#FILE..... /oracle/C11/sapdata4/stabi_1/stabi.data1

#RESTORED. stabi.data1 C11B06/6

BR280I Time stamp 1997-09-10 18.58.37

BR418I 3 of 13 files restored - 25.023 MB of 107.169 MB done.

BR204I Percentage done: 23.35%, estimated end time: 19:02

BR001I ************______________________________________

BR351I Restoring /oracle/C11/sapdata2/temp_1/temp.data1

BR355I from /dev/rmt/1mn...

#FILE..... /oracle/C11/sapdata2/temp_1/temp.data1

#RESTORED. temp.data1 C11B06/7

BR280I Time stamp 1997-09-10 18.58.51

BR418I 4 of 13 files restored - 30.031 MB of 107.169 MB done.

BR204I Percentage done: 28.02%, estimated end time: 19:02

BR001I **************____________________________________

BR351I Restoring /oracle/C11/sapdata3/testd_1/testd.data1

BR355I from /dev/rmt/1mn...

#FILE..... /oracle/C11/sapdata3/testd_1/testd.data1

#RESTORED. testd.data1 C11B06/8

BR280I Time stamp 1997-09-10 18.59.04

BR418I 5 of 13 files restored - 34.039 MB of 107.169 MB done.

BR204I Percentage done: 31.76%, estimated end time: 19:02

BR001I ****************__________________________________

BR351I Restoring /oracle/C11/sapdata4/testi_1/testi.data1

BR355I from /dev/rmt/1mn...

#FILE..... /oracle/C11/sapdata4/testi_1/testi.data1

#RESTORED. testi.data1 C11B06/9

BR280I Time stamp 1997-09-10 18.59.10

BR418I 6 of 13 files restored - 36.047 MB of 107.169 MB done.

BR204I Percentage done: 33.64%, estimated end time: 19:02

BR001I *****************_________________________________

BR351I Restoring /oracle/C11/sapdata1/cntrl/cntrlC11.dbf

BR355I from /dev/rmt/1mn...

#FILE..... /oracle/C11/sapdata1/cntrl/cntrlC11.dbf

#RESTORED. cntrlC11.dbf C11B06/10

BR280I Time stamp 1997-09-10 18.59.11

BR418I 7 of 13 files restored - 36.368 MB of 107.169 MB done.

BR204I Percentage done: 33.94%, estimated end time: 19:02

BR001I *****************_________________________________

BR351I Restoring /oracle/C11/origlogA/log_g11m1.dbf

BR355I from /dev/rmt/1mn...

#FILE..... /oracle/C11/origlogA/log_g11m1.dbf

#RESTORED. log_g11m1.dbf C11B06/11

BR280I Time stamp 1997-09-10 18.59.12

BR418I 8 of 13 files restored - 36.564 MB of 107.169 MB done.

BR204I Percentage done: 34.12%, estimated end time: 19:02

BR001I *****************_________________________________

BR351I Restoring /oracle/C11/origlogB/log_g12m1.dbf

BR355I from /dev/rmt/1mn...

#FILE..... /oracle/C11/origlogB/log_g12m1.dbf

#RESTORED. log_g12m1.dbf C11B06/12

BR280I Time stamp 1997-09-10 18.59.13

BR418I 9 of 13 files restored - 36.761 MB of 107.169 MB done.

BR204I Percentage done: 34.30%, estimated end time: 19:02

BR001I *****************_________________________________

BR351I Restoring /oracle/C11/origlogA/log_g13m1.dbf

BR355I from /dev/rmt/1mn...

#FILE..... /oracle/C11/origlogA/log_g13m1.dbf

#RESTORED. log_g13m1.dbf C11B06/13

BR280I Time stamp 1997-09-10 18.59.14

BR418I 10 of 13 files restored - 36.957 MB of 107.169 MB done.

BR204I Percentage done: 34.48%, estimated end time: 19:02

BR001I *****************_________________________________

BR351I Restoring /oracle/C11/origlogB/log_g14m1.dbf

BR355I from /dev/rmt/1mn...

#FILE..... /oracle/C11/origlogB/log_g14m1.dbf

#RESTORED. log_g14m1.dbf C11B06/14

BR280I Time stamp 1997-09-10 18.59.15

BR418I 11 of 13 files restored - 37.153 MB of 107.169 MB done.

BR204I Percentage done: 34.67%, estimated end time: 19:02

BR001I *****************_________________________________

#FILE..... /oracle/C11/sapdata1/system_1/system.data1

#RESTORED. system.data1 C11B05/4

BR280I Time stamp 1997-09-10 18.59.36

BR418I 12 of 13 files restored - 87.161 MB of 107.169 MB done.

BR204I Percentage done: 81.33%, estimated end time: 19:00

BR001I *****************************************_________

BR351I Restoring /oracle/C11/sapdata2/roll_1/roll.data1

BR355I from /dev/rmt/0mn...

#FILE..... /oracle/C11/sapdata2/roll_1/roll.data1

#RESTORED. roll.data1 C11B05/5

BR280I Time stamp 1997-09-10 19.00.16

BR418I 13 of 13 files restored - 107.169 MB of 107.169 MB done.

BR204I Percentage done: 100.00%, estimated end time: 19:00

BR001I **************************************************

BR351I Restoring /oracle/C11/mirrlogA/log_g11m2.dbf

BR355I from /oracle/C11/origlogA/log_g11m1.dbf...

BR351I Restoring /oracle/C11/mirrlogB/log_g12m2.dbf

BR355I from /oracle/C11/origlogB/log_g12m1.dbf...

BR351I Restoring /oracle/C11/mirrlogA/log_g13m2.dbf

BR355I from /oracle/C11/origlogA/log_g13m1.dbf...

BR351I Restoring /oracle/C11/mirrlogB/log_g14m2.dbf

BR355I from /oracle/C11/origlogB/log_g14m1.dbf...

BR351I Restoring /oracle/C11/sapdata2/cntrl/cntrlC11.dbf

BR355I from /oracle/C11/sapdata1/cntrl/cntrlC11.dbf...

BR351I Restoring /oracle/C11/sapdata3/cntrl/cntrlC11.dbf

BR355I from /oracle/C11/sapdata1/cntrl/cntrlC11.dbf...

BR351I Restoring /oracle/C11/sapdata4/cntrl/cntrlC11.dbf

BR355I from /oracle/C11/sapdata1/cntrl/cntrlC11.dbf...

BR280I Time stamp 1997-09-10 19.00.20

BR226I Rewinding tape volume in device /dev/rmt/0m...

BR280I Time stamp 1997-09-10 19.00.20

BR226I Rewinding tape volume in device /dev/rmt/1m...

BR406I End of database restore: rcvojvfh rsb 1997-09-10 19.00.47

BR403I BRRESTORE terminated successfully with warnings.