Log for an RMAN Preparation Run (SAP Library - Database Administration (Oracle) with SAPDBA)

Log for an RMAN Preparation Run

The following is the log of an RMAN preparation run in unattended mode.

Call: brbackup -d rman_prep -c

BR051I BRBACKUP 4.5B

BR055I Start of database backup: bcypksix.rmp 1998-11-02 18.22.55

BR101I Parameters

oracle_sid GC1

oracle_home /oracle/GC1

oracle_profile /oracle/GC1/dbs/initGC1.ora

sapdata_home /oracle/GC1

sap_profile /oracle/GC1/dbs/initGC1.sap

backup_mode ALL

backup_type online

backup_dev_type rman_prep

exec_parallel 0

BR116I ARCHIVE LOG LIST before backup for database instance GC1

Database log mode Archive Mode

Automatic archival Enabled

Archive destination /oracle/GC1/saparch/GC1arch

Oldest online log sequence 122

Next log sequence to archive 124

Current log sequence 124 SCN: 83681

Database block size 2048 Thread: 1

BR118I Tablespaces and data files

PSAPPROTD ONLINE* ONLINE /oracle/GC1/sapdata5/protd_1/protd.data1 8390656 8 35389455 NOLINK FILE

PSAPPROTI ONLINE ONLINE /oracle/GC1/sapdata6/proti_1/proti.data1 4196352 9 35389455 NOLINK FILE

PSAPSTABD ONLINE* ONLINE /oracle/GC1/sapdata2/stabd_1/stabd.data1 16779264 6 35389455 NOLINK FILE

PSAPSTABI ONLINE ONLINE /oracle/GC1/sapdata3/stabi_1/stabi.data1 8390656 7 35389455 NOLINK FILE

PSAPTESTD ONLINE ONLINE /oracle/GC1/sapdata3/testd_1/testd.data1 4196352 10 35389455 NOLINK FILE

PSAPTESTI ONLINE ONLINE /oracle/GC1/sapdata2/testi_1/testi.data1 2099200 11 35389455 NOLINK FILE

PSAPTTTTD ONLINE ONLINE /oracle/GC1/sapdata6/ttttd_1/ttttd.data1 4196352 12 35389455 NOLINK FILE

RBS ONLINE* ONLINE /oracle/GC1/sapdata1/roll_1/roll.data1 15730688 2 35389455 NOLINK FILE

SYSTEM ONLINE* SYSTEM /oracle/GC1/sapdata1/system_1/system.data1 83888128 1 35389455 NOLINK FILE

TEMP ONLINE ONLINE /oracle/GC1/sapdata1/temp_1/temp.data1 1050624 3 35389455 NOLINK FILE

TOOLS ONLINE* ONLINE /oracle/GC1/sapdata4/tools_1/tools.data1 26216448 4 35389455 NOLINK FILE

USERS ONLINE ONLINE /oracle/GC1/sapdata4/users_1/users.data1 1050624 5 35389455 NOLINK FILE

BR119I Redo log files

/oracle/GC1/origlog/redoGC101.log 512512 1 35389455 INUSE NOLINK FILE

/oracle/GC1/mirrlog/redoGC201.log 512512 1 35389455 INUSE NOLINK FILE

/oracle/GC1/origlog/redoGC102.log 512512 2 35389455 INUSE NOLINK FILE

/oracle/GC1/mirrlog/redoGC202.log 512512 2 35389455 INUSE NOLINK FILE

/oracle/GC1/origlog/redoGC103.log 512512 3 35389455 INUSE NOLINK FILE

/oracle/GC1/mirrlog/redoGC203.log 512512 3 35389455 INUSE NOLINK FILE

BR120I Control files

/oracle/GC1/sapdata1/cntrl/cntrl.ctl 1693696 0 35389455 NOLINK FILE

/oracle/GC1/sapdata2/cntrl/cntrl.ctl 1693696 0 35389455 NOLINK FILE

/oracle/GC1/sapdata3/cntrl/cntrl.ctl 1693696 0 35389455 NOLINK FILE

/oracle/GC1/sapdata4/cntrl/cntrl.ctl 1693696 0 35389455 NOLINK FILE

BR280I Time stamp 1998-11-02 18.22.57

BR057I Backup of database: GC1

BR058I BRBACKUP action ID: bcypksix

BR059I BRBACKUP function ID: rmp

BR110I Backup mode: ALL

BR077I Database file for backup: /oracle/GC1/sapdata1/cntrl/cntrl.ctl

BR061I 13 files found for backup, total size 44.990 MB

BR143I Backup type: online

BR130I Backup device type: rman_prep

BR523I Preparation for using RMAN only - no backup

BR126I Unattended mode active - no operator confirmation required

BR525I Preparing backup of /oracle/GC1/sapdata5/protd_1/protd.data1 using RMAN...

#FILE..... /oracle/GC1/sapdata5/protd_1/protd.data1 65536 18.1089:1 3619

BR280I Time stamp 1998-11-02 18.23.09

BR063I 1 of 13 files processed - 0.062 MB of 44.990 MB done

BR204I Percentage done: 0.14%, estimated end time: 20:46

BR001I __________________________________________________

BR525I Preparing backup of /oracle/GC1/sapdata6/proti_1/proti.data1 using RMAN...

#FILE..... /oracle/GC1/sapdata6/proti_1/proti.data1 65536 30.3970:1 2156

BR280I Time stamp 1998-11-02 18.23.22

BR063I 2 of 13 files processed - 0.125 MB of 44.990 MB done

BR204I Percentage done: 0.28%, estimated end time: 20:52

BR001I __________________________________________________

BR525I Preparing backup of /oracle/GC1/sapdata2/stabd_1/stabd.data1 using RMAN...

#FILE..... /oracle/GC1/sapdata2/stabd_1/stabd.data1 851968 4.4895:1 189769

BR280I Time stamp 1998-11-02 18.23.32

BR063I 3 of 13 files processed - 0.938 MB of 44.990 MB done

BR204I Percentage done: 2.08%, estimated end time: 18:50

BR001I *_________________________________________________

BR525I Preparing backup of /oracle/GC1/sapdata3/stabi_1/stabi.data1 using RMAN...

#FILE..... /oracle/GC1/sapdata3/stabi_1/stabi.data1 327680 4.6661:1 70226

BR280I Time stamp 1998-11-02 18.23.44

BR063I 4 of 13 files processed - 1.250 MB of 44.990 MB done

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

BR001I *_________________________________________________

BR525I Preparing backup of /oracle/GC1/sapdata3/testd_1/testd.data1 using RMAN...

#FILE..... /oracle/GC1/sapdata3/testd_1/testd.data1 65536 84.4536:1 776

BR280I Time stamp 1998-11-02 18.23.58

BR063I 5 of 13 files processed - 1.312 MB of 44.990 MB done

BR204I Percentage done: 2.92%, estimated end time: 18:57

BR001I *_________________________________________________

BR525I Preparing backup of /oracle/GC1/sapdata2/testi_1/testi.data1 using RMAN...

#FILE..... /oracle/GC1/sapdata2/testi_1/testi.data1 65536 88.6820:1 739

BR280I Time stamp 1998-11-02 18.24.14

BR063I 6 of 13 files processed - 1.375 MB of 44.990 MB done

BR204I Percentage done: 3.06%, estimated end time: 19:04

BR001I **________________________________________________

BR525I Preparing backup of /oracle/GC1/sapdata6/ttttd_1/ttttd.data1 using RMAN...

#FILE..... /oracle/GC1/sapdata6/ttttd_1/ttttd.data1 65536 85.5561:1 766

BR280I Time stamp 1998-11-02 18.24.28

BR063I 7 of 13 files processed - 1.438 MB of 44.990 MB done

BR204I Percentage done: 3.20%, estimated end time: 19:10

BR001I **________________________________________________

BR525I Preparing backup of /oracle/GC1/sapdata1/roll_1/roll.data1 using RMAN...

#FILE..... /oracle/GC1/sapdata1/roll_1/roll.data1 3014656 3.5263:1 854908

BR280I Time stamp 1998-11-02 18.24.41

BR063I 8 of 13 files processed - 4.312 MB of 44.990 MB done

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

BR001I *****_____________________________________________

BR525I Preparing backup of /oracle/GC1/sapdata1/system_1/system.data1 using RMAN...

#FILE..... /oracle/GC1/sapdata1/system_1/system.data1 39059456 2.6312:1 14844999

BR280I Time stamp 1998-11-02 18.25.38

BR063I 9 of 13 files processed - 41.562 MB of 44.990 MB done

BR204I Percentage done: 92.38%, estimated end time: 18:25

BR001I **********************************************____

BR525I Preparing backup of /oracle/GC1/sapdata1/temp_1/temp.data1 using RMAN...

#FILE..... /oracle/GC1/sapdata1/temp_1/temp.data1 851968 4.4948:1 189546

BR280I Time stamp 1998-11-02 18.25.47

BR063I 10 of 13 files processed - 42.375 MB of 44.990 MB done

BR204I Percentage done: 94.19%, estimated end time: 18:25

BR001I ***********************************************___

BR525I Preparing backup of /oracle/GC1/sapdata4/tools_1/tools.data1 using RMAN...

#FILE..... /oracle/GC1/sapdata4/tools_1/tools.data1 983040 4.6577:1 211055

BR280I Time stamp 1998-11-02 18.25.57

BR063I 11 of 13 files processed - 43.312 MB of 44.990 MB done

BR204I Percentage done: 96.27%, estimated end time: 18:26

BR001I ************************************************__

BR525I Preparing backup of /oracle/GC1/sapdata4/users_1/users.data1 using RMAN...

#FILE..... /oracle/GC1/sapdata4/users_1/users.data1 65536 92.5650:1 708

BR280I Time stamp 1998-11-02 18.26.07

BR063I 12 of 13 files processed - 43.375 MB of 44.990 MB done

BR204I Percentage done: 96.41%, estimated end time: 18:26

BR001I ************************************************__

BR201I Compressing /oracle/GC1/sapdata1/cntrl/cntrl.ctl

#FILE..... /oracle/GC1/sapdata1/cntrl/cntrl.ctl 12.6978:1 133385

BR280I Time stamp 1998-11-02 18.26.09

BR063I 13 of 13 files processed - 44.990 MB of 44.990 MB done

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

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

BR280I Time stamp 1998-11-02 18.26.11

BR533I Uncataloging backups of database files...

BR522I 12 files/savesets processed by RMAN

BR280I Time stamp 1998-11-02 18.26.33

BR534I Backups of database files uncataloged successfully

BR527I Savesets with 1 file:

saveset size rate compressed name

1 39059456 2.6312:1 14844999 /oracle/GC1/sapdata1/system_1/system.data1

2 3014656 3.5263:1 854908 /oracle/GC1/sapdata1/roll_1/roll.data1

3 851968 4.4948:1 189546 /oracle/GC1/sapdata1/temp_1/temp.data1

4 983040 4.6577:1 211055 /oracle/GC1/sapdata4/tools_1/tools.data1

5 65536 92.5650:1 708 /oracle/GC1/sapdata4/users_1/users.data1

6 851968 4.4895:1 189769 /oracle/GC1/sapdata2/stabd_1/stabd.data1

7 327680 4.6661:1 70226 /oracle/GC1/sapdata3/stabi_1/stabi.data1

8 65536 18.1089:1 3619 /oracle/GC1/sapdata5/protd_1/protd.data1

9 65536 30.3970:1 2156 /oracle/GC1/sapdata6/proti_1/proti.data1

10 65536 84.4536:1 776 /oracle/GC1/sapdata3/testd_1/testd.data1

11 65536 88.6820:1 739 /oracle/GC1/sapdata2/testi_1/testi.data1

12 65536 85.5561:1 766 /oracle/GC1/sapdata6/ttttd_1/ttttd.data1

BR527I Savesets with 2 files:

saveset size rate compressed name

1 40042496 2.6596:1 15056054 /oracle/GC1/sapdata1/system_1/system.data1

/oracle/GC1/sapdata4/tools_1/tools.data1

2 3866624 3.7013:1 1044677 /oracle/GC1/sapdata2/stabd_1/stabd.data1

/oracle/GC1/sapdata1/roll_1/roll.data1

3 393216 5.3249:1 73845 /oracle/GC1/sapdata5/protd_1/protd.data1

/oracle/GC1/sapdata3/stabi_1/stabi.data1

4 131072 44.7040:1 2932 /oracle/GC1/sapdata6/proti_1/proti.data1

/oracle/GC1/sapdata3/testd_1/testd.data1

5 131072 87.0910:1 1505 /oracle/GC1/sapdata2/testi_1/testi.data1

/oracle/GC1/sapdata6/ttttd_1/ttttd.data1

6 917504 4.8225:1 190254 /oracle/GC1/sapdata1/temp_1/temp.data1

/oracle/GC1/sapdata4/users_1/users.data1

BR527I Savesets with 3 files:

saveset size rate compressed name

1 40894464 2.6823:1 15245823 /oracle/GC1/sapdata2/stabd_1/stabd.data1

/oracle/GC1/sapdata1/system_1/system.data1

/oracle/GC1/sapdata4/tools_1/tools.data1

2 3407872 3.6693:1 928753 /oracle/GC1/sapdata5/protd_1/protd.data1

/oracle/GC1/sapdata3/stabi_1/stabi.data1

/oracle/GC1/sapdata1/roll_1/roll.data1

3 196608 53.1660:1 3698 /oracle/GC1/sapdata6/proti_1/proti.data1

/oracle/GC1/sapdata3/testd_1/testd.data1

/oracle/GC1/sapdata6/ttttd_1/ttttd.data1

4 983040 5.1470:1 190993 /oracle/GC1/sapdata2/testi_1/testi.data1

/oracle/GC1/sapdata1/temp_1/temp.data1

/oracle/GC1/sapdata4/users_1/users.data1

BR527I Savesets with 4 files:

saveset size rate compressed name

1 43909120 2.7272:1 16100731 /oracle/GC1/sapdata2/stabd_1/stabd.data1

/oracle/GC1/sapdata1/roll_1/roll.data1

/oracle/GC1/sapdata1/system_1/system.data1

/oracle/GC1/sapdata4/tools_1/tools.data1

2 524288 6.8287:1 76777 /oracle/GC1/sapdata5/protd_1/protd.data1

/oracle/GC1/sapdata6/proti_1/proti.data1

/oracle/GC1/sapdata3/stabi_1/stabi.data1

/oracle/GC1/sapdata3/testd_1/testd.data1

3 1048576 5.4682:1 191759 /oracle/GC1/sapdata2/testi_1/testi.data1

/oracle/GC1/sapdata6/ttttd_1/ttttd.data1

/oracle/GC1/sapdata1/temp_1/temp.data1

/oracle/GC1/sapdata4/users_1/users.data1

BR527I Savesets with 'tsp' files:

saveset size rate compressed name

1 65536 18.1089:1 3619 /oracle/GC1/sapdata5/protd_1/protd.data1

2 65536 30.3970:1 2156 /oracle/GC1/sapdata6/proti_1/proti.data1

3 851968 4.4895:1 189769 /oracle/GC1/sapdata2/stabd_1/stabd.data1

4 327680 4.6661:1 70226 /oracle/GC1/sapdata3/stabi_1/stabi.data1

5 65536 84.4536:1 776 /oracle/GC1/sapdata3/testd_1/testd.data1

6 65536 88.6820:1 739 /oracle/GC1/sapdata2/testi_1/testi.data1

7 65536 85.5561:1 766 /oracle/GC1/sapdata6/ttttd_1/ttttd.data1

8 3014656 3.5263:1 854908 /oracle/GC1/sapdata1/roll_1/roll.data1

9 39059456 2.6312:1 14844999 /oracle/GC1/sapdata1/system_1/system.data1

10 851968 4.4948:1 189546 /oracle/GC1/sapdata1/temp_1/temp.data1

11 983040 4.6577:1 211055 /oracle/GC1/sapdata4/tools_1/tools.data1

12 65536 92.5650:1 708 /oracle/GC1/sapdata4/users_1/users.data1

BR527I Savesets with 'all' files:

saveset size rate compressed name

1 45481984 2.7785:1 16369267 /oracle/GC1/sapdata5/protd_1/protd.data1

/oracle/GC1/sapdata6/proti_1/proti.data1

/oracle/GC1/sapdata2/stabd_1/stabd.data1

/oracle/GC1/sapdata3/stabi_1/stabi.data1

/oracle/GC1/sapdata3/testd_1/testd.data1

/oracle/GC1/sapdata2/testi_1/testi.data1

/oracle/GC1/sapdata6/ttttd_1/ttttd.data1

/oracle/GC1/sapdata1/roll_1/roll.data1

/oracle/GC1/sapdata1/system_1/system.data1

/oracle/GC1/sapdata1/temp_1/temp.data1

/oracle/GC1/sapdata4/tools_1/tools.data1

/oracle/GC1/sapdata4/users_1/users.data1

BR056I End of database backup: bcypksix.rmp 1998-11-02 18.26.33

BR052I BRBACKUP terminated successfully