Solved: DB13 - Full offline backup - runs perfectly but st...

We've had a minor annoyance ever since our SAP systems where installed, and DB13 configured. We run full offline+logs (brbackup -u / -jid ALGOF20071212200000 -c force -t offline_force -m all -p initSQP.sap -a -c force -cds -p initSQP.sap) every night and the logs alwasy show it ran perfectly, yet in the DB13 overview the backups alwasy show up red.

I've gone through the detailed log over and over and the only problem in there is the final line:

BR0292I Execution of BRARCHIVE finished with return code 3

But everything else (to me) seems to go perfeclty.

Any suggestions where to look for a clue?

SAP Managed Tags:
SAP NetWeaver

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (1)

Well - we can´t help you here without you posting the log - we can just guess what happens.

Markus

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Woops. I had saved it localy just forgot to include it.

Here it is:

Detail log: bdxdszbw.afd

BR0051I BRBACKUP 6.40 (46)

BR0055I Start of database backup: bdxdszbw.afd 2008-01-30 20.00.20

BR0484I BRBACKUP log file: /oracle/SQP/sapbackup/bdxdszbw.afd

BR0477I Oracle pfile /oracle/SQP/920_64/dbs/initSQP.ora created from spfile /oracle/SQP/920_64/dbs/spfileSQP.ora

BR0101I Parameters

Name Value

oracle_sid SQP

oracle_home /oracle/SQP/920_64

oracle_profile /oracle/SQP/920_64/dbs/initSQP.ora

sapdata_home /oracle/SQP

sap_profile /oracle/SQP/920_64/dbs/initSQP.sap

backup_mode ALL

backup_type offline_force

backup_dev_type disk

backup_root_dir /oracle/BACKUP/SQP

compress yes

compress_cmd compress -c $ > $

exec_parallel 0

system_info sqpadm/orasqp jairzinho AIX 2 5 00393D1A4C00

oracle_info SQP 9.2.0.6.0 8192 6276 114392332

sap_info 640 SAPSQP SQP W0659765089 R3_ORA 0020235892

make_info rs6000_64 OCI_920 Nov 13 2007

command_line brbackup -u / -jid ALGOF20071212200000 -c force -t offline_force -m all -p initSQP.sap -a -c force -cds -p initSQP.sap

BR0116I ARCHIVE LOG LIST before backup for database instance SQP

Parameter Value

Database log mode Archive Mode

Automatic archival Enabled

Archive destination /oracle/SQP/oraarch/SQParch

Archive format %t_%s.dbf

Oldest online log sequence 6273

Next log sequence to archive 6276

Current log sequence 6276 SCN: 114392332

Database block size 8192 Thread: 1

BR0118I Tablespaces and data files

Tablespace TS-Status F-Status File Size Id. Device Link Type MaxSize IncrSize

PSAPSQP ONLINE* ONLINE+ /oracle/SQP/sapdata2/sqp_11/sqp.data11 3187679232 27 2621441 NOLINK FILE 10485760000 20971520

PSAPSQP ONLINE* ONLINE+ /oracle/SQP/sapdata2/sqp_12/sqp.data12 3187679232 28 2621441 NOLINK FILE 10485760000 20971520

PSAPSQP ONLINE* ONLINE+ /oracle/SQP/sapdata3/sqp_1/sqp.data1 3439337472 3 2686977 NOLINK FILE 10485760000 20971520

PSAPSQP ONLINE* ONLINE+ /oracle/SQP/sapdata3/sqp_2/sqp.data2 3418365952 4 2686977 NOLINK FILE 10485760000 20971520

PSAPSQP ONLINE* ONLINE+ /oracle/SQP/sapdata3/sqp_3/sqp.data3 3355451392 5 2686977 NOLINK FILE 10485760000 20971520

PSAPSQP ONLINE* ONLINE+ /oracle/SQP/sapdata3/sqp_4/sqp.data4 3586138112 6 2686977 NOLINK FILE 10485760000 20971520

PSAPSQP ONLINE* ONLINE+ /oracle/SQP/sapdata3/sqp_5/sqp.data5 3544195072 7 2686977 NOLINK FILE 10485760000 20971520

PSAPSQP ONLINE* ONLINE+ /oracle/SQP/sapdata4/sqp_10/sqp.data10 3187679232 12 2752513 NOLINK FILE 10485760000 20971520

PSAPSQP ONLINE* ONLINE+ /oracle/SQP/sapdata4/sqp_6/sqp.data6 3607109632 8 2752513 NOLINK FILE 10485760000 20971520

PSAPSQP ONLINE* ONLINE+ /oracle/SQP/sapdata4/sqp_7/sqp.data7 3376422912 9 2752513 NOLINK FILE 10485760000 20971520

PSAPSQP ONLINE* ONLINE+ /oracle/SQP/sapdata4/sqp_8/sqp.data8 3292536832 10 2752513 NOLINK FILE 10485760000 20971520

PSAPSQP ONLINE* ONLINE+ /oracle/SQP/sapdata4/sqp_9/sqp.data9 3166707712 11 2752513 NOLINK FILE 10485760000 20971520

PSAPSQP640 ONLINE* ONLINE+ /oracle/SQP/sapdata1/sqp640_1/sqp640.data1 3292536832 13 2555905 NOLINK FILE 10485760000 20971520

PSAPSQP640 ONLINE* ONLINE+ /oracle/SQP/sapdata1/sqp640_2/sqp640.data2 3124764672 14 2555905 NOLINK FILE 10485760000 20971520

PSAPSQP640 ONLINE* ONLINE+ /oracle/SQP/sapdata1/sqp640_3/sqp640.data3 3187679232 15 2555905 NOLINK FILE 10485760000 20971520

PSAPSQP640 ONLINE* ONLINE+ /oracle/SQP/sapdata1/sqp640_4/sqp640.data4 3145736192 16 2555905 NOLINK FILE 10485760000 20971520

PSAPSQP640 ONLINE* ONLINE+ /oracle/SQP/sapdata1/sqp640_5/sqp640.data5 3103793152 17 2555905 NOLINK FILE 10485760000 20971520

PSAPSQP640 ONLINE* ONLINE+ /oracle/SQP/sapdata2/sqp640_10/sqp640.data10 3187679232 22 2621441 NOLINK FILE 10485760000 20971520

PSAPSQP640 ONLINE* ONLINE+ /oracle/SQP/sapdata2/sqp640_6/sqp640.data6 3124764672 18 2621441 NOLINK FILE 10485760000 20971520

PSAPSQP640 ONLINE* ONLINE+ /oracle/SQP/sapdata2/sqp640_7/sqp640.data7 3187679232 19 2621441 NOLINK FILE 10485760000 20971520

PSAPSQP640 ONLINE* ONLINE+ /oracle/SQP/sapdata2/sqp640_8/sqp640.data8 3082821632 20 2621441 NOLINK FILE 10485760000 20971520

PSAPSQP640 ONLINE* ONLINE+ /oracle/SQP/sapdata2/sqp640_9/sqp640.data9 3082821632 21 2621441 NOLINK FILE 10485760000 20971520

PSAPSQP640 ONLINE* ONLINE+ /oracle/SQP/sapdata3/sqp640_11/sqp640.data11 3271565312 23 2686977 NOLINK FILE 10485760000 20971520

PSAPSQP640 ONLINE* ONLINE+ /oracle/SQP/sapdata3/sqp640_14/sqp640.data14 3208650752 29 2686977 NOLINK FILE 10485760000 20971520

PSAPSQP640 ONLINE* ONLINE+ /oracle/SQP/sapdata4/sqp640_12/sqp640.data12 3292536832 24 2752513 NOLINK FILE 10485760000 20971520

PSAPSQP640 ONLINE* ONLINE+ /oracle/SQP/sapdata4/sqp640_13/sqp640.data13 3208650752 25 2752513 NOLINK FILE 10485760000 20971520

PSAPSQPUSR ONLINE* ONLINE+ /oracle/SQP/sapdata4/sqpusr_1/sqpusr.data1 20979712 26 2752513 NOLINK FILE 10485760000 20971520

PSAPTEMP ONLINE# ONLINE+ /oracle/SQP/sapdata1/temp_1/temp.data1 702554112 -1 2555905 NOLINK FILE 10485760000 20971520

PSAPUNDO ONLINE- ONLINE+ /oracle/SQP/sapdata1/undo_1/undo.data1 5389688832 2 2555905 NOLINK FILE 10485760000 20971520

SYSTEM ONLINE* SYSTEM+ /oracle/SQP/sapdata1/system_1/system.data1 639639552 1 2555905 NOLINK FILE 10485760000 20971520

BR0119I Redo log files

File Size Group Device Status Link Type

/oracle/SQP/origlogA/log_g11m1.dbf 52429312 1 2818049 INUSE NOLINK FILE

/oracle/SQP/mirrlogA/log_g11m2.dbf 52429312 1 2949121 INUSE NOLINK FILE

/oracle/SQP/origlogB/log_g12m1.dbf 52429312 2 2883585 INUSE NOLINK FILE

/oracle/SQP/mirrlogB/log_g12m2.dbf 52429312 2 3014657 INUSE NOLINK FILE

/oracle/SQP/origlogA/log_g13m1.dbf 52429312 3 2818049 INUSE NOLINK FILE

/oracle/SQP/mirrlogA/log_g13m2.dbf 52429312 3 2949121 INUSE NOLINK FILE

/oracle/SQP/origlogB/log_g14m1.dbf 52429312 4 2883585 INUSE NOLINK FILE

/oracle/SQP/mirrlogB/log_g14m2.dbf 52429312 4 3014657 INUSE NOLINK FILE

BR0120I Control files

File Size Id. Device Link Type

/oracle/SQP/origlogA/cntrl/cntrlSQP.dbf 4972544 0 2818049 NOLINK FILE

/oracle/SQP/sapdata1/system_1/cntrl/cntrlSQP.dbf 4972544 0 2555905 NOLINK FILE

/oracle/SQP/saparch/cntrl/cntrlSQP.dbf 4972544 0 2490372 NOLINK FILE

BR0280I BRBACKUP time stamp: 2008-01-30 20.00.24

BR0057I Backup of database: SQP

BR0058I BRBACKUP action ID: bdxdszbw

BR0059I BRBACKUP function ID: afd

BR0110I Backup mode: ALL

BR0077I Database files for backup:

/oracle/SQP/origlogA/log_g11m1.dbf

/oracle/SQP/origlogB/log_g12m1.dbf

/oracle/SQP/origlogA/log_g13m1.dbf

/oracle/SQP/origlogB/log_g14m1.dbf

/oracle/SQP/origlogA/cntrl/cntrlSQP.dbf

BR0061I 35 files found for backup, total size 87564.979 MB

BR0143I Backup type: offline_force

BR0111I Files will be compressed

BR0130I Backup device type: disk

BR0106I Files will be saved on disk in directory: /oracle/BACKUP/SQP/bdxdszbw

BR0289I BRARCHIVE will be started at the end of processing

BR0134I Unattended mode with 'force' active - no operator confirmation allowed

BR0370I Directory /oracle/BACKUP/SQP/bdxdszbw created

BR0202I Saving init_ora

BR0203I to /oracle/BACKUP/SQP/SQP ...

BR0202I Saving /oracle/SQP/920_64/dbs/initSQP.sap

BR0203I to /oracle/BACKUP/SQP/SQP ...

BR0280I BRBACKUP time stamp: 2008-01-30 20.00.24

BR0198I Profiles saved successfully

BR0280I BRBACKUP time stamp: 2008-01-30 20.00.24

BR0307I Shutting down database instance SQP ...

BR0280I BRBACKUP time stamp: 2008-01-30 20.00.55

BR0308I Shutdown of database instance SQP successful

BR0201I Compressing /oracle/SQP/sapdata2/sqp_11/sqp.data11

BR0203I to /oracle/BACKUP/SQP/bdxdszbw/sqp.data11.Z ...

#FILE..... /oracle/SQP/sapdata2/sqp_11/sqp.data11

#SAVED.... /oracle/BACKUP/SQP/bdxdszbw/sqp.data11.Z #1/1 2.5669:1 1241818710

BR0280I BRBACKUP time stamp: 2008-01-30 20.06.31

BR0063I 1 of 35 files processed - 3040.008 MB of 87564.979 MB done

BR0204I Percentage done: 3.47%, estimated end time: 22:56

BR0001I **________________________________________________

BR0201I Compressing /oracle/SQP/sapdata2/sqp_12/sqp.data12

BR0203I to /oracle/BACKUP/SQP/bdxdszbw/sqp.data12.Z ...

#FILE..... /oracle/SQP/sapdata2/sqp_12/sqp.data12

#SAVED.... /oracle/BACKUP/SQP/bdxdszbw/sqp.data12.Z #1/2 2.9100:1 1095403923

BR0280I BRBACKUP time stamp: 2008-01-30 20.11.44

BR0063I 2 of 35 files processed - 6080.016 MB of 87564.979 MB done

BR0204I Percentage done: 6.94%, estimated end time: 22:43

BR0001I ***_______________________________________________

BR0201I Compressing /oracle/SQP/sapdata3/sqp_1/sqp.data1

BR0203I to /oracle/BACKUP/SQP/bdxdszbw/sqp.data1.Z ...

#FILE..... /oracle/SQP/sapdata3/sqp_1/sqp.data1

#SAVED.... /oracle/BACKUP/SQP/bdxdszbw/sqp.data1.Z #1/3 3.9609:1 868323655

BR0280I BRBACKUP time stamp: 2008-01-30 20.17.10

BR0063I 3 of 35 files processed - 9360.023 MB of 87564.979 MB done

BR0204I Percentage done: 10.69%, estimated end time: 22:37

BR0001I *****_____________________________________________

BR0201I Compressing /oracle/SQP/sapdata3/sqp_2/sqp.data2

BR0203I to /oracle/BACKUP/SQP/bdxdszbw/sqp.data2.Z ...

#FILE..... /oracle/SQP/sapdata3/sqp_2/sqp.data2

#SAVED.... /oracle/BACKUP/SQP/bdxdszbw/sqp.data2.Z #1/4 4.0535:1 843320099

BR0280I BRBACKUP time stamp: 2008-01-30 20.22.14

BR0063I 4 of 35 files processed - 12620.031 MB of 87564.979 MB done

BR0204I Percentage done: 14.41%, estimated end time: 22:31

BR0001I *******___________________________________________

BR0201I Compressing /oracle/SQP/sapdata3/sqp_3/sqp.data3

BR0203I to /oracle/BACKUP/SQP/bdxdszbw/sqp.data3.Z ...

#FILE..... /oracle/SQP/sapdata3/sqp_3/sqp.data3

#SAVED.... /oracle/BACKUP/SQP/bdxdszbw/sqp.data3.Z #1/5 3.7127:1 903784151

BR0280I BRBACKUP time stamp: 2008-01-30 20.27.41

BR0063I 5 of 35 files processed - 15820.039 MB of 87564.979 MB done

BR0204I Percentage done: 18.07%, estimated end time: 22:31

BR0001I *********_________________________________________

BR0201I Compressing /oracle/SQP/sapdata3/sqp_4/sqp.data4

BR0203I to /oracle/BACKUP/SQP/bdxdszbw/sqp.data4.Z ...

#FILE..... /oracle/SQP/sapdata3/sqp_4/sqp.data4

#SAVED.... /oracle/BACKUP/SQP/bdxdszbw/sqp.data4.Z #1/6 3.6232:1 989775169

BR0280I BRBACKUP time stamp: 2008-01-30 20.33.42

BR0063I 6 of 35 files processed - 19240.047 MB of 87564.979 MB done

BR0204I Percentage done: 21.97%, estimated end time: 22:31

BR0001I ***********_______________________________________

BR0201I Compressing /oracle/SQP/sapdata3/sqp_5/sqp.data5

BR0203I to /oracle/BACKUP/SQP/bdxdszbw/sqp.data5.Z ...

#FILE..... /oracle/SQP/sapdata3/sqp_5/sqp.data5

#SAVED.... /oracle/BACKUP/SQP/bdxdszbw/sqp.data5.Z #1/7 3.7452:1 946325385

BR0280I BRBACKUP time stamp: 2008-01-30 20.39.22

BR0063I 7 of 35 files processed - 22620.055 MB of 87564.979 MB done

BR0204I Percentage done: 25.83%, estimated end time: 22:31

BR0001I *************_____________________________________

BR0201I Compressing /oracle/SQP/sapdata4/sqp_10/sqp.data10

BR0203I to /oracle/BACKUP/SQP/bdxdszbw/sqp.data10.Z ...

#FILE..... /oracle/SQP/sapdata4/sqp_10/sqp.data10

#SAVED.... /oracle/BACKUP/SQP/bdxdszbw/sqp.data10.Z #1/8 3.3792:1 943321275

BR0280I BRBACKUP time stamp: 2008-01-30 20.45.01

BR0063I 8 of 35 files processed - 25660.062 MB of 87564.979 MB done

BR0204I Percentage done: 29.30%, estimated end time: 22:32

BR0001I ***************___________________________________

BR0201I Compressing /oracle/SQP/sapdata4/sqp_6/sqp.data6

BR0203I to /oracle/BACKUP/SQP/bdxdszbw/sqp.data6.Z ...

#FILE..... /oracle/SQP/sapdata4/sqp_6/sqp.data6

#SAVED.... /oracle/BACKUP/SQP/bdxdszbw/sqp.data6.Z #1/9 3.5724:1 1009720129

BR0280I BRBACKUP time stamp: 2008-01-30 20.50.57

BR0063I 9 of 35 files processed - 29100.070 MB of 87564.979 MB done

BR0204I Percentage done: 33.23%, estimated end time: 22:32

BR0001I *****************_________________________________

BR0201I Compressing /oracle/SQP/sapdata4/sqp_7/sqp.data7

BR0203I to /oracle/BACKUP/SQP/bdxdszbw/sqp.data7.Z ...

#FILE..... /oracle/SQP/sapdata4/sqp_7/sqp.data7

#SAVED.... /oracle/BACKUP/SQP/bdxdszbw/sqp.data7.Z #1/10 3.4445:1 980243350

BR0280I BRBACKUP time stamp: 2008-01-30 20.56.36

BR0063I 10 of 35 files processed - 32320.078 MB of 87564.979 MB done

BR0204I Percentage done: 36.91%, estimated end time: 22:32

BR0001I ******************________________________________

BR0201I Compressing /oracle/SQP/sapdata4/sqp_8/sqp.data8

BR0203I to /oracle/BACKUP/SQP/bdxdszbw/sqp.data8.Z ...

#FILE..... /oracle/SQP/sapdata4/sqp_8/sqp.data8

#SAVED.... /oracle/BACKUP/SQP/bdxdszbw/sqp.data8.Z #1/11 3.4801:1 946115364

BR0280I BRBACKUP time stamp: 2008-01-30 21.02.03

BR0063I 11 of 35 files processed - 35460.086 MB of 87564.979 MB done

BR0204I Percentage done: 40.50%, estimated end time: 22:32

BR0001I ********************______________________________

BR0201I Compressing /oracle/SQP/sapdata4/sqp_9/sqp.data9

BR0203I to /oracle/BACKUP/SQP/bdxdszbw/sqp.data9.Z ...

#FILE..... /oracle/SQP/sapdata4/sqp_9/sqp.data9

#SAVED.... /oracle/BACKUP/SQP/bdxdszbw/sqp.data9.Z #1/12 3.4385:1 920954425

BR0280I BRBACKUP time stamp: 2008-01-30 21.07.58

BR0063I 12 of 35 files processed - 38480.094 MB of 87564.979 MB done

BR0204I Percentage done: 43.94%, estimated end time: 22:34

BR0001I **********************____________________________

BR0201I Compressing /oracle/SQP/sapdata1/sqp640_1/sqp640.data1

BR0203I to /oracle/BACKUP/SQP/bdxdszbw/sqp640.data1.Z ...

#FILE..... /oracle/SQP/sapdata1/sqp640_1/sqp640.data1

#SAVED.... /oracle/BACKUP/SQP/bdxdszbw/sqp640.data1.Z #1/13 2.7781:1 1185168651

BR0280I BRBACKUP time stamp: 2008-01-30 21.14.44

BR0063I 13 of 35 files processed - 41620.102 MB of 87564.979 MB done

BR0204I Percentage done: 47.53%, estimated end time: 22:36

BR0001I ************************__________________________

BR0201I Compressing /oracle/SQP/sapdata1/sqp640_2/sqp640.data2

BR0203I to /oracle/BACKUP/SQP/bdxdszbw/sqp640.data2.Z ...

#FILE..... /oracle/SQP/sapdata1/sqp640_2/sqp640.data2

#SAVED.... /oracle/BACKUP/SQP/bdxdszbw/sqp640.data2.Z #1/14 2.7446:1 1138503043

BR0280I BRBACKUP time stamp: 2008-01-30 21.21.09

BR0063I 14 of 35 files processed - 44600.109 MB of 87564.979 MB done

BR0204I Percentage done: 50.93%, estimated end time: 22:38

BR0001I *************************_________________________

BR0201I Compressing /oracle/SQP/sapdata1/sqp640_3/sqp640.data3

BR0203I to /oracle/BACKUP/SQP/bdxdszbw/sqp640.data3.Z ...

#FILE..... /oracle/SQP/sapdata1/sqp640_3/sqp640.data3

#SAVED.... /oracle/BACKUP/SQP/bdxdszbw/sqp640.data3.Z #1/15 2.6890:1 1185454045

BR0280I BRBACKUP time stamp: 2008-01-30 21.27.56

BR0063I 15 of 35 files processed - 47640.117 MB of 87564.979 MB done

BR0204I Percentage done: 54.41%, estimated end time: 22:41

BR0001I ***************************_______________________

BR0201I Compressing /oracle/SQP/sapdata1/sqp640_4/sqp640.data4

BR0203I to /oracle/BACKUP/SQP/bdxdszbw/sqp640.data4.Z ...

#FILE..... /oracle/SQP/sapdata1/sqp640_4/sqp640.data4

#SAVED.... /oracle/BACKUP/SQP/bdxdszbw/sqp640.data4.Z #1/16 2.5652:1 1226304570

BR0280I BRBACKUP time stamp: 2008-01-30 21.34.59

BR0063I 16 of 35 files processed - 50640.125 MB of 87564.979 MB done

BR0204I Percentage done: 57.83%, estimated end time: 22:43

BR0001I *****************************_____________________

BR0201I Compressing /oracle/SQP/sapdata1/sqp640_5/sqp640.data5

BR0203I to /oracle/BACKUP/SQP/bdxdszbw/sqp640.data5.Z ...

#FILE..... /oracle/SQP/sapdata1/sqp640_5/sqp640.data5

#SAVED.... /oracle/BACKUP/SQP/bdxdszbw/sqp640.data5.Z #1/17 2.5475:1 1218362361

BR0280I BRBACKUP time stamp: 2008-01-30 21.41.34

BR0063I 17 of 35 files processed - 53600.133 MB of 87564.979 MB done

BR0204I Percentage done: 61.21%, estimated end time: 22:45

BR0001I *******************************___________________

BR0201I Compressing /oracle/SQP/sapdata2/sqp640_10/sqp640.data10

BR0203I to /oracle/BACKUP/SQP/bdxdszbw/sqp640.data10.Z ...

#FILE..... /oracle/SQP/sapdata2/sqp640_10/sqp640.data10

#SAVED.... /oracle/BACKUP/SQP/bdxdszbw/sqp640.data10.Z #1/18 2.2600:1 1410472230

BR0280I BRBACKUP time stamp: 2008-01-30 21.49.11

BR0063I 18 of 35 files processed - 56640.141 MB of 87564.979 MB done

BR0204I Percentage done: 64.68%, estimated end time: 22:48

BR0001I ********************************__________________

BR0201I Compressing /oracle/SQP/sapdata2/sqp640_6/sqp640.data6

BR0203I to /oracle/BACKUP/SQP/bdxdszbw/sqp640.data6.Z ...

#FILE..... /oracle/SQP/sapdata2/sqp640_6/sqp640.data6

#SAVED.... /oracle/BACKUP/SQP/bdxdszbw/sqp640.data6.Z #1/19 2.4659:1 1267175273

BR0280I BRBACKUP time stamp: 2008-01-30 21.56.23

BR0063I 19 of 35 files processed - 59620.148 MB of 87564.979 MB done

BR0204I Percentage done: 68.09%, estimated end time: 22:50

BR0001I **********************************________________

BR0201I Compressing /oracle/SQP/sapdata2/sqp640_7/sqp640.data7

BR0203I to /oracle/BACKUP/SQP/bdxdszbw/sqp640.data7.Z ...

#FILE..... /oracle/SQP/sapdata2/sqp640_7/sqp640.data7

#SAVED.... /oracle/BACKUP/SQP/bdxdszbw/sqp640.data7.Z #1/20 2.3518:1 1355394659

BR0280I BRBACKUP time stamp: 2008-01-30 22.03.57

BR0063I 20 of 35 files processed - 62660.156 MB of 87564.979 MB done

BR0204I Percentage done: 71.56%, estimated end time: 22:53

BR0001I ************************************______________

BR0201I Compressing /oracle/SQP/sapdata2/sqp640_8/sqp640.data8

BR0203I to /oracle/BACKUP/SQP/bdxdszbw/sqp640.data8.Z ...

#FILE..... /oracle/SQP/sapdata2/sqp640_8/sqp640.data8

#SAVED.... /oracle/BACKUP/SQP/bdxdszbw/sqp640.data8.Z #1/21 2.3606:1 1305947987

BR0280I BRBACKUP time stamp: 2008-01-30 22.10.22

BR0063I 21 of 35 files processed - 65600.164 MB of 87564.979 MB done

BR0204I Percentage done: 74.92%, estimated end time: 22:53

BR0001I *************************************_____________

BR0201I Compressing /oracle/SQP/sapdata2/sqp640_9/sqp640.data9

BR0203I to /oracle/BACKUP/SQP/bdxdszbw/sqp640.data9.Z ...

#FILE..... /oracle/SQP/sapdata2/sqp640_9/sqp640.data9

#SAVED.... /oracle/BACKUP/SQP/bdxdszbw/sqp640.data9.Z #1/22 2.3722:1 1299544579

BR0280I BRBACKUP time stamp: 2008-01-30 22.16.47

BR0063I 22 of 35 files processed - 68540.172 MB of 87564.979 MB done

BR0204I Percentage done: 78.27%, estimated end time: 22:54

BR0001I ***************************************___________

BR0201I Compressing /oracle/SQP/sapdata3/sqp640_11/sqp640.data11

BR0203I to /oracle/BACKUP/SQP/bdxdszbw/sqp640.data11.Z ...

#FILE..... /oracle/SQP/sapdata3/sqp640_11/sqp640.data11

#SAVED.... /oracle/BACKUP/SQP/bdxdszbw/sqp640.data11.Z #1/23 2.6015:1 1257577302

BR0280I BRBACKUP time stamp: 2008-01-30 22.23.35

BR0063I 23 of 35 files processed - 71660.180 MB of 87564.979 MB done

BR0204I Percentage done: 81.84%, estimated end time: 22:55

BR0001I *****************************************_________

BR0201I Compressing /oracle/SQP/sapdata3/sqp640_14/sqp640.data14

BR0203I to /oracle/BACKUP/SQP/bdxdszbw/sqp640.data14.Z ...

#FILE..... /oracle/SQP/sapdata3/sqp640_14/sqp640.data14

#SAVED.... /oracle/BACKUP/SQP/bdxdszbw/sqp640.data14.Z #1/24 10.4152:1 308075323

BR0280I BRBACKUP time stamp: 2008-01-30 22.26.31

BR0063I 24 of 35 files processed - 74720.188 MB of 87564.979 MB done

BR0204I Percentage done: 85.33%, estimated end time: 22:51

BR0001I *******************************************_______

BR0201I Compressing /oracle/SQP/sapdata4/sqp640_12/sqp640.data12

BR0203I to /oracle/BACKUP/SQP/bdxdszbw/sqp640.data12.Z ...

#FILE..... /oracle/SQP/sapdata4/sqp640_12/sqp640.data12

#SAVED.... /oracle/BACKUP/SQP/bdxdszbw/sqp640.data12.Z #1/25 2.6473:1 1243749612

BR0280I BRBACKUP time stamp: 2008-01-30 22.33.20

BR0063I 25 of 35 files processed - 77860.195 MB of 87564.979 MB done

BR0204I Percentage done: 88.92%, estimated end time: 22:52

BR0001I ********************************************______

BR0201I Compressing /oracle/SQP/sapdata4/sqp640_13/sqp640.data13

BR0203I to /oracle/BACKUP/SQP/bdxdszbw/sqp640.data13.Z ...

#FILE..... /oracle/SQP/sapdata4/sqp640_13/sqp640.data13

#SAVED.... /oracle/BACKUP/SQP/bdxdszbw/sqp640.data13.Z #1/26 2.6889:1 1193289831

BR0280I BRBACKUP time stamp: 2008-01-30 22.39.48

BR0063I 26 of 35 files processed - 80920.203 MB of 87564.979 MB done

BR0204I Percentage done: 92.41%, estimated end time: 22:52

BR0001I **********************************************____

BR0201I Compressing /oracle/SQP/sapdata4/sqpusr_1/sqpusr.data1

BR0203I to /oracle/BACKUP/SQP/bdxdszbw/sqpusr.data1.Z ...

#FILE..... /oracle/SQP/sapdata4/sqpusr_1/sqpusr.data1

#SAVED.... /oracle/BACKUP/SQP/bdxdszbw/sqpusr.data1.Z #1/27 122.7839:1 170867

BR0280I BRBACKUP time stamp: 2008-01-30 22.39.49

BR0063I 27 of 35 files processed - 80940.211 MB of 87564.979 MB done

BR0204I Percentage done: 92.43%, estimated end time: 22:52

BR0001I **********************************************____

BR0201I Compressing /oracle/SQP/sapdata1/temp_1/temp.data1

BR0203I to /oracle/BACKUP/SQP/bdxdszbw/temp.data1.Z ...

#FILE..... /oracle/SQP/sapdata1/temp_1/temp.data1

#SAVED.... /oracle/BACKUP/SQP/bdxdszbw/temp.data1.Z #1/28 29.6640:1 23683739

BR0280I BRBACKUP time stamp: 2008-01-30 22.40.35

BR0063I 28 of 35 files processed - 81610.219 MB of 87564.979 MB done

BR0204I Percentage done: 93.20%, estimated end time: 22:52

BR0001I ***********************************************___

BR0201I Compressing /oracle/SQP/sapdata1/undo_1/undo.data1

BR0203I to /oracle/BACKUP/SQP/bdxdszbw/undo.data1.Z ...

#FILE..... /oracle/SQP/sapdata1/undo_1/undo.data1

#SAVED.... /oracle/BACKUP/SQP/bdxdszbw/undo.data1.Z #1/29 2.2940:1 2349472910

BR0280I BRBACKUP time stamp: 2008-01-30 22.53.39

BR0063I 29 of 35 files processed - 86750.227 MB of 87564.979 MB done

BR0204I Percentage done: 99.07%, estimated end time: 22:55

BR0001I **************************************************

BR0201I Compressing /oracle/SQP/sapdata1/system_1/system.data1

BR0203I to /oracle/BACKUP/SQP/bdxdszbw/system.data1.Z ...

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

#SAVED.... /oracle/BACKUP/SQP/bdxdszbw/system.data1.Z #1/30 3.2994:1 193863513

BR0280I BRBACKUP time stamp: 2008-01-30 22.54.56

BR0063I 30 of 35 files processed - 87360.234 MB of 87564.979 MB done

BR0204I Percentage done: 99.77%, estimated end time: 22:55

BR0001I **************************************************

BR0201I Compressing /oracle/SQP/origlogA/log_g11m1.dbf

BR0203I to /oracle/BACKUP/SQP/bdxdszbw/log_g11m1.dbf.Z ...

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

#SAVED.... /oracle/BACKUP/SQP/bdxdszbw/log_g11m1.dbf.Z #1/31 2.6739:1 19607597

BR0280I BRBACKUP time stamp: 2008-01-30 22.55.03

BR0063I 31 of 35 files processed - 87410.235 MB of 87564.979 MB done

BR0204I Percentage done: 99.82%, estimated end time: 22:55

BR0001I **************************************************

BR0201I Compressing /oracle/SQP/origlogB/log_g12m1.dbf

BR0203I to /oracle/BACKUP/SQP/bdxdszbw/log_g12m1.dbf.Z ...

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

#SAVED.... /oracle/BACKUP/SQP/bdxdszbw/log_g12m1.dbf.Z #1/32 3.8724:1 13539297

BR0280I BRBACKUP time stamp: 2008-01-30 22.55.09

BR0063I 32 of 35 files processed - 87460.235 MB of 87564.979 MB done

BR0204I Percentage done: 99.88%, estimated end time: 22:55

BR0001I **************************************************

BR0201I Compressing /oracle/SQP/origlogA/log_g13m1.dbf

BR0203I to /oracle/BACKUP/SQP/bdxdszbw/log_g13m1.dbf.Z ...

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

#SAVED.... /oracle/BACKUP/SQP/bdxdszbw/log_g13m1.dbf.Z #1/33 3.2982:1 15896270

BR0280I BRBACKUP time stamp: 2008-01-30 22.55.16

BR0063I 33 of 35 files processed - 87510.236 MB of 87564.979 MB done

BR0204I Percentage done: 99.94%, estimated end time: 22:55

BR0001I **************************************************

BR0201I Compressing /oracle/SQP/origlogB/log_g14m1.dbf

BR0203I to /oracle/BACKUP/SQP/bdxdszbw/log_g14m1.dbf.Z ...

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

#SAVED.... /oracle/BACKUP/SQP/bdxdszbw/log_g14m1.dbf.Z #1/34 1.9348:1 27098139

BR0280I BRBACKUP time stamp: 2008-01-30 22.55.24

BR0063I 34 of 35 files processed - 87560.236 MB of 87564.979 MB done

BR0204I Percentage done: 99.99%, estimated end time: 22:55

BR0001I **************************************************

BR0201I Compressing /oracle/SQP/origlogA/cntrl/cntrlSQP.dbf

BR0203I to /oracle/BACKUP/SQP/bdxdszbw/cntrlSQP.dbf.Z ...

#FILE..... /oracle/SQP/origlogA/cntrl/cntrlSQP.dbf

#SAVED.... /oracle/BACKUP/SQP/bdxdszbw/cntrlSQP.dbf.Z #1/35 33.1355:1 150067

BR0280I BRBACKUP time stamp: 2008-01-30 22.55.24

BR0063I 35 of 35 files processed - 87564.979 MB of 87564.979 MB done

BR0204I Percentage done: 100.00%, estimated end time: 22:55

BR0001I **************************************************

BR0280I BRBACKUP time stamp: 2008-01-30 22.55.26

BR0304I Starting and opening database instance SQP ...

BR0280I BRBACKUP time stamp: 2008-01-30 22.56.18

BR0305I Start and open of database instance SQP successful

BR0117I ARCHIVE LOG LIST after backup for database instance SQP

Parameter Value

Database log mode Archive Mode

Automatic archival Enabled

Archive destination /oracle/SQP/oraarch/SQParch

Archive format %t_%s.dbf

Oldest online log sequence 6273

Next log sequence to archive 6276

Current log sequence 6276 SCN: 114392332

Database block size 8192 Thread: 1

BR0202I Saving space_log

BR0203I to /oracle/BACKUP/SQP/SQP ...

BR0202I Saving /oracle/SQP/sapbackup/bdxdszbw.afd

BR0203I to /oracle/BACKUP/SQP/SQP ...

BR0202I Saving /oracle/SQP/sapbackup/backSQP.log

BR0203I to /oracle/BACKUP/SQP/SQP ...

BR0115I Compression rate for all files 2.9688:1

BR0056I End of database backup: bdxdszbw.afd 2008-01-30 22.56.28

BR0280I BRBACKUP time stamp: 2008-01-30 22.56.29

BR0052I BRBACKUP completed successfully

BR0280I BRBACKUP time stamp: 2008-01-30 22.56.29

BR0291I BRARCHIVE will be started with options '-U -jid ALGOF20071212200000 -d disk -c force -cds -p initSQP.sap'

BR0280I BRBACKUP time stamp: 2008-01-30 22.56.33

BR0292I Execution of BRARCHIVE finished with return code 3

The reason for that could be, that you are trying to backup archive logs but there are no to backup.

Markus

I've changed tonights to not do any logs, and schedule a seperate archive logs only to run after. Will let you know if that was the issue

please post the brarchive log. it should have a CDS file extension.

Splitting the archive log backup off to it's own run solved the main problem. I now also have a clear error why the archives aren't backing up properly. The flags I set (-cds) aren't valid if you do backups to disk for archive logs.

So I'll tweak the seperate archive log backup and all should be green!

thanx alot for the quick (and effective) help

Good to hear it works!

Markus

Answers (0)

Ask a Question

Top Q&A Solution Author

User

Count

DB13 - Full offline backup - runs perfectly but still shows up red

Accepted Solutions (1)

Accepted Solutions (1)

Answers (0)

Re: How can we use a odata connection of dataspher...

Re: Scheduled Report shows successful status; but ...

Re: Blending Tables (Import Models)

Re: Object store secret mys-object-store-secret no...

Re: CF Deployment Error: Error getting tenant t0