Detail Log of an Offline Backup (SAP Library - Database Administration (Oracle) with SAPDBA)

Detail Log of an Offline Backup

The following excerpts come from the log of an offline backup performed in parallel on two tape devices in unattended mode.

Call: brbackup -t offline -c

BR051I BRBACKUP 4.0A

BR055I Start of database backup: bcvojtgt aft 1997-09-10 18.35.15

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 ALL

backup_type offline

backup_dev_type tape

compress no

tape_copy_cmd cpio

cpio_flags -ovB

cpio_in_flags -iuvB

cpio_disk_flags -pdcu

dd_flags obs=16k bs=16k

dd_in_flags ibs=16k bs=16k

rewind mt -t $ rew

rewind_offline mt -t $ offl

tape_size 1200.000 MB

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

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

volume_backup C11B01,C11B02,C11B03,C11B04,C11B05,C11B06,C11B07,C11B08,C11B09,C11B10,

C11B11,C11B12,C11B13,C11B14,C11B15,C11B16,C11B17,C11B18,C11B19,C11B20,

C11B21,C11B22,C11B23,C11B24,C11B25,C11B26,C11B27,C11B28,C11B29,C11B30

expir_period 30

tape_use_count 100

exec_parallel 0

BR116I ARCHIVE LOG LIST before backup for database instance C11

Database log mode Archive Mode

Automatic archival Enabled

Archive destination /oracle/C11/saparch/C11arch

Oldest online log sequence 232

Next log sequence to archive 235

Current log sequence 235 SCN: 9364

Database block size 8192

BR118I Tablespaces and data files

PSAPRAWD ONLINE ONLINE /oracle/C11/sapraw/rawd_1 10493952 8 1073741829 /dev/vg00/rlvol5 RAW

PSAPROLL ONLINE* ONLINE /oracle/C11/sapdata2/roll_1/roll.data1 20979712 2 1073807361 NOLINK FILE

PSAPSTABD ONLINE* ONLINE /oracle/C11/sapdata3/stabd_1/stabd.data1 10493952 4 1073807361 NOLINK FILE

PSAPSTABI ONLINE ONLINE /oracle/C11/sapdata4/stabi_1/stabi.data1 5251072 5 1073807361 NOLINK FILE

PSAPTEMP ONLINE ONLINE /oracle/C11/sapdata2/temp_1/temp.data1 5251072 3 1073807361 NOLINK FILE

PSAPTESTD ONLINE* ONLINE /oracle/C11/sapdata3/testd_1/testd.data1 4202496 6 1073807361 NOLINK FILE

PSAPTESTI ONLINE ONLINE /oracle/C11/sapdata4/testi_1/testi.data1 2105344 7 1073807361 NOLINK FILE

SYSTEM ONLINE* SYSTEM /oracle/C11/sapdata1/system_1/system.data1 52436992 1 1073807361 NOLINK FILE

BR119I Redo log files

/oracle/C11/origlogA/log_g11m1.dbf 205824 1 1073807361 INUSE NOLINK FILE

/oracle/C11/mirrlogA/log_g11m2.dbf 205824 1 1073807361 INUSE NOLINK FILE

/oracle/C11/origlogB/log_g12m1.dbf 205824 2 1073807361 INUSE NOLINK FILE

/oracle/C11/mirrlogB/log_g12m2.dbf 205824 2 1073807361 INUSE NOLINK FILE

/oracle/C11/origlogA/log_g13m1.dbf 205824 3 1073807361 INUSE NOLINK FILE

/oracle/C11/mirrlogA/log_g13m2.dbf 205824 3 1073807361 INUSE NOLINK FILE

/oracle/C11/origlogB/log_g14m1.dbf 205824 4 1073807361 INUSE NOLINK FILE

/oracle/C11/mirrlogB/log_g14m2.dbf 205824 4 1073807361 INUSE NOLINK FILE

BR120I Control files

/oracle/C11/sapdata1/cntrl/cntrlC11.dbf 336896 0 1073807361 NOLINK FILE

/oracle/C11/sapdata2/cntrl/cntrlC11.dbf 336896 0 1073807361 NOLINK FILE

/oracle/C11/sapdata3/cntrl/cntrlC11.dbf 336896 0 1073807361 NOLINK FILE

/oracle/C11/sapdata4/cntrl/cntrlC11.dbf 336896 0 1073807361 NOLINK FILE

BR280I Time stamp 1997-09-10 18.35.19

BR057I Backup of database: C11

BR058I BRBACKUP action ID: bcvojtgt

BR059I BRBACKUP function ID: aft

BR060I Tablespaces for backup: ALL

BR077I Database files for backup:

/oracle/C11/origlogA/log_g11m1.dbf

/oracle/C11/origlogB/log_g12m1.dbf

/oracle/C11/origlogA/log_g13m1.dbf

/oracle/C11/origlogB/log_g14m1.dbf

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

BR061I 13 files found for backup, total size 107.169 MB.

BR143I Backup type: offline

BR112I Files will not be compressed.

BR130I Backup device type: tape

BR102I Following backup devices will be used:

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

BR103I Following backup volumes will be used:

C11B05,C11B06

BR140I Number of parallel copy processes: 2.

BR126I Unattended mode active - no confirmation required.

BR307I Shutting down the database instance C11...

BR308I Shutdown of database instance C11 successful.

BR280I Time stamp 1997-09-10 18.35.29

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

BR280I Time stamp 1997-09-10 18.35.29

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

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

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

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

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

BR280I Time stamp 1997-09-10 18.35.32

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

BR280I Time stamp 1997-09-10 18.35.32

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

BR208I Volume with name:

C11B05|C11B06 required in device /dev/rmt/0mn

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

BR208I Volume with name C11B06 required in device /dev/rmt/1mn

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

BR202I Saving /oracle/C11/sapbackup/brlab0/.tape.hdr0

BR203I to /dev/rmt/0mn...

BR202I Saving /oracle/C11/sapbackup/brlab1/.tape.hdr0

BR203I to /dev/rmt/1mn...

BR209I Volume in device /dev/rmt/0mn has name C11B05

BR209I Volume in device /dev/rmt/1mn has name C11B06

BR202I Saving init_ora

BR203I to /dev/rmt/0mn...

BR202I Saving init_ora

BR203I to /dev/rmt/1mn...

BR202I Saving /oracle/C11/dbs/initC11.sap

BR203I to /dev/rmt/0mn...

BR202I Saving /oracle/C11/dbs/initC11.sap

BR203I to /dev/rmt/1mn...

BR280I Time stamp 1997-09-10 18.36.20

BR202I Saving /oracle/C11/sapdata1/system_1/system.data1

BR203I to /dev/rmt/0mn...

BR202I Saving /oracle/C11/sapraw/rawd_1

BR203I to /dev/rmt/1mn...

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

#SAVED.... rawd_1 C11B06/4

BR280I Time stamp 1997-09-10 18.37.25

BR063I 1 of 13 files processed - 10.008 MB of 107.169 MB done.

BR204I Percentage done: 9.34%, estimated end time: 18:47

BR001I *****_____________________________________________

BR202I Saving /oracle/C11/sapdata3/stabd_1/stabd.data1

BR203I to /dev/rmt/1mn...

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

#SAVED.... stabd.data1 C11B06/5

BR280I Time stamp 1997-09-10 18.38.50

BR063I 2 of 13 files processed - 20.016 MB of 107.169 MB done.

BR204I Percentage done: 18.68%, estimated end time: 18:49

BR001I *********_________________________________________

BR202I Saving /oracle/C11/sapdata4/stabi_1/stabi.data1

BR203I to /dev/rmt/1mn...

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

#SAVED.... stabi.data1 C11B06/6

BR280I Time stamp 1997-09-10 18.39.46

BR063I 3 of 13 files processed - 25.023 MB of 107.169 MB done.

BR204I Percentage done: 23.35%, estimated end time: 18:51

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

BR202I Saving /oracle/C11/sapdata2/temp_1/temp.data1

BR203I to /dev/rmt/1mn...

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

#SAVED.... system.data1 C11B05/4

BR280I Time stamp 1997-09-10 18.39.52

BR063I 4 of 13 files processed - 75.031 MB of 107.169 MB done.

BR204I Percentage done: 70.01%, estimated end time: 18:41

BR001I ***********************************_______________

BR202I Saving /oracle/C11/sapdata2/roll_1/roll.data1

BR203I to /dev/rmt/0mn...

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

#SAVED.... temp.data1 C11B06/7

BR280I Time stamp 1997-09-10 18.40.09

BR063I 5 of 13 files processed - 80.039 MB of 107.169 MB done.

BR204I Percentage done: 74.68%, estimated end time: 18:41

BR001I *************************************_____________

BR202I Saving /oracle/C11/sapdata3/testd_1/testd.data1

BR203I to /dev/rmt/1mn...

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

#SAVED.... testd.data1 C11B06/8

BR280I Time stamp 1997-09-10 18.40.44

BR063I 6 of 13 files processed - 84.047 MB of 107.169 MB done.

BR204I Percentage done: 78.42%, estimated end time: 18:41

BR001I ***************************************___________

BR202I Saving /oracle/C11/sapdata4/testi_1/testi.data1

BR203I to /dev/rmt/1mn...

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

#SAVED.... testi.data1 C11B06/9

BR280I Time stamp 1997-09-10 18.41.14

BR063I 7 of 13 files processed - 86.055 MB of 107.169 MB done.

BR204I Percentage done: 80.30%, estimated end time: 18:42

BR001I ****************************************__________

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

BR203I to /dev/rmt/1mn...

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

#SAVED.... roll.data1 C11B05/5

BR280I Time stamp 1997-09-10 18.41.22

BR063I 8 of 13 files processed - 106.062 MB of 107.169 MB done.

BR204I Percentage done: 98.97%, estimated end time: 18:41

BR001I *************************************************_

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

#SAVED.... cntrlC11.dbf C11B06/10

BR280I Time stamp 1997-09-10 18.41.31

BR063I 9 of 13 files processed - 106.384 MB of 107.169 MB done.

BR204I Percentage done: 99.27%, estimated end time: 18:41

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

BR202I Saving /oracle/C11/origlogA/log_g11m1.dbf

BR203I to /dev/rmt/1mn...

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

#SAVED.... log_g11m1.dbf C11B06/11

BR280I Time stamp 1997-09-10 18.41.47

BR063I 10 of 13 files processed - 106.580 MB of 107.169 MB done.

BR204I Percentage done: 99.45%, estimated end time: 18:41

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

BR202I Saving /oracle/C11/origlogB/log_g12m1.dbf

BR203I to /dev/rmt/1mn...

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

#SAVED.... log_g12m1.dbf C11B06/12

BR280I Time stamp 1997-09-10 18.42.03

BR063I 11 of 13 files processed - 106.776 MB of 107.169 MB done.

BR204I Percentage done: 99.63%, estimated end time: 18:42

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

BR202I Saving /oracle/C11/origlogA/log_g13m1.dbf

BR203I to /dev/rmt/1mn...

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

#SAVED.... log_g13m1.dbf C11B06/13

BR280I Time stamp 1997-09-10 18.42.19

BR063I 12 of 13 files processed - 106.973 MB of 107.169 MB done.

BR204I Percentage done: 99.82%, estimated end time: 18:42

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

BR202I Saving /oracle/C11/origlogB/log_g14m1.dbf

BR203I to /dev/rmt/1mn...

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

#SAVED.... log_g14m1.dbf C11B06/14

BR280I Time stamp 1997-09-10 18.42.35

BR063I 13 of 13 files processed - 107.169 MB of 107.169 MB done.

BR204I Percentage done: 100.00%, estimated end time: 18:42

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

BR304I Starting the database instance C11...

BR305I Startup of database instance C11 successful.

BR117I ARCHIVE LOG LIST after backup for database instance C11

Database log mode Archive Mode

Automatic archival Enabled

Archive destination /oracle/C11/saparch/C11arch

Oldest online log sequence 232

Next log sequence to archive 235

Current log sequence 235 SCN: 9364

Database block size 8192

BR202I Saving reorg_log

BR203I to /dev/rmt/0mn...

BR202I Saving reorg_log

BR203I to /dev/rmt/1mn...

BR202I Saving /oracle/C11/sapbackup/bcvojtgt.aft

BR203I to /dev/rmt/0mn...

BR202I Saving /oracle/C11/sapbackup/bcvojtgt.aft

BR203I to /dev/rmt/1mn...

BR202I Saving /oracle/C11/sapbackup/backC11.log

BR203I to /dev/rmt/0mn...

BR202I Saving /oracle/C11/sapbackup/backC11.log

BR203I to /dev/rmt/1mn...

BR280I Time stamp 1997-09-10 18.44.02

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

BR280I Time stamp 1997-09-10 18.44.02

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

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

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

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

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

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

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

BR280I Time stamp 1997-09-10 18.44.20

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

BR280I Time stamp 1997-09-10 18.44.20

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

BR056I End of database backup: bcvojtgt aft 1997-09-10 18.45.14

BR052I BRBACKUP terminated successfully.