cancel
Showing results for 
Search instead for 
Did you mean: 

DB13 - AllOff+Log backup is shown in red

Former Member
0 Kudos

Dear Experts,

In DB13 ALLOff+Log is displayed in red .When I doble clicked on same and checkd the detail log the return code is shown

as 0000 Success in green color.All the files are backup successfully.

I check the detailed log in which nothng is shown as warning or error.

I would like to know why in DB13 is backup is shown in red .

DB: ORACLE

SAP : r3 enterprise

OS : HP_UX

Thanks,

Rushikesh

Edited by: RUSHI123 on Jun 15, 2011 9:24 AM

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hai....

I think you are checking from Jobs -> Central Calender , it is not a issue

KHS

Former Member
0 Kudos

Thanks for your help.

Yes I am checking form DB13 Central calender .

As pointed by Gerd Kirchner ,

Only redo log files are getting copied. But for the same AllFile+Log job on other day all the datafiles , redo log files, control file are getting copied . And job is completed successfully.

I would like to know why on one occasion same job is copying only redolog files and showing no error , And on other day same job is copying all the files .

Thanks,

Rushikesh

Edited by: RUSHI123 on Jun 15, 2011 11:54 AM

Edited by: RUSHI123 on Jun 15, 2011 11:55 AM

Former Member
0 Kudos

Dear Rushi,

All the files are backup successfully.

In your log there are only redo log files, but no control files, no data files?!

Kind regards,

Gerd

former_member182034
Active Contributor
0 Kudos

hi Rushi,

send the Log/return code of DB13.

some time if you don't use proper Function according to backup_dev_type then you can get red error.

Regards,

Former Member
0 Kudos

Hi,

Thanks for your prompt reply.

log is -


edo log backup log from 14.06.2011 00:37:34 aegchcdz.cds

eturn code: 0000 Success Database host: kbxkbp

Deatil Log :-

BR0002I BRARCHIVE 6.40 (11)

BR0006I Start of offline redo log processing: aegchcdz.cds 2011-06-14 00.37.34

BR0477I Oracle pfile /oracle/KBP/920_64/dbs/initKBP.ora created from spfile /oracle/KBP/920_64/dbs/spfileKBP.ora

BR0101I Parameters

Name Value

oracle_sid KBP

oracle_home /oracle/KBP/920_64

oracle_profile /oracle/KBP/920_64/dbs/initKBP.ora

sapdata_home /oracle/KBP

sap_profile /oracle/KBP/920_64/dbs/initKBP.sap

backup_dev_type tape

compress no

tape_copy_cmd dd

cpio_flags -ovB

cpio_in_flags -iuvB

dd_flags obs=64k bs=64k

dd_in_flags ibs=64k bs=64k

rewind mt -f $ rew

rewind_offline mt -f $ offl

tape_size 29863.301 MB

tape_address /dev/rmt/0mn

tape_address_rew /dev/rmt/0m

volume_archive KBPB23

expir_period 30

tape_use_count 100

system_info kbpadm/orakbp kbxkbp HP-UX B.11.23 U ia64

oracle_info KBP 9.2.0.6.0 8192 16211 4450362316

sap_info 620 SAPKBP KBP O1773126109 R3_ORA 0020479201

make_info hpia64 OCI_920 Jul 5 2004

command_line /usr/sap/KBP/SYS/exe/run/brarchive +begchcdz.aft,125972459520,KBPB23,33 -d tape -c force -p initKBP.sap -

BR0280I BRARCHIVE time stamp: 2011-06-14 00.37.36

BR0008I Offline redo log processing for database instance: KBP

BR0009I BRARCHIVE action ID: aegchcdz

BR0010I BRARCHIVE function ID: cds

BR0048I Archive function: copy_delete_save

BR0011I 24 offline redo log files found for processing, total size 1199.951 MB

BR0112I Files will not be compressed

BR0130I Backup device type: tape

BR0102I Following backup device will be used: /dev/rmt/0mn

BR0103I Following backup volume will be used: KBPB23

BR0290I This run was started by BRBACKUP

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

BR0202I Saving /oracle/KBP/oraarch/KBParch1_16150.dbf

BR0203I to /dev/rmt/0mn ...

#ARCHIVE.. /oracle/KBP/oraarch/KBParch1_16150.dbf

#SAVED.... KBParch1_16150.dbf KBPB23/37

BR0280I BRARCHIVE time stamp: 2011-06-14 00.37.46

BR0015I Offline redo log file /oracle/KBP/oraarch/KBParch1_16150.dbf deleted

BR0280I BRARCHIVE time stamp: 2011-06-14 00.37.46

BR0014I 1 of 24 offline redo log files processed - 49.999 MB of 1199.951 MB done

BR0204I Percentage done: 4.17%, estimated end time: 0:41

BR0001I **________________________________________________

Former Member
0 Kudos

log contineus -


BR0202I Saving /oracle/KBP/oraarch/KBParch1_16199.dbf

BR0203I to /dev/rmt/0mn ...

#ARCHIVE.. /oracle/KBP/oraarch/KBParch1_16199.dbf

#SAVED.... KBParch1_16199.dbf KBPB23/86

BR0280I BRARCHIVE time stamp: 2011-06-14 00.46.52

BR0014I 26 of 37 offline redo log files processed - 1299.950 MB of 1849.937 MB done

BR0204I Percentage done: 70.27%, estimated end time: 0:48

BR0001I ***********************************_______________

BR0202I Saving /oracle/KBP/oraarch/KBParch1_16200.dbf

BR0203I to /dev/rmt/0mn ...

#ARCHIVE.. /oracle/KBP/oraarch/KBParch1_16200.dbf

#SAVED.... KBParch1_16200.dbf KBPB23/87

BR0280I BRARCHIVE time stamp: 2011-06-14 00.47.02

BR0014I 27 of 37 offline redo log files processed - 1349.947 MB of 1849.937 MB done

BR0204I Percentage done: 72.97%, estimated end time: 0:48

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

BR0202I Saving /oracle/KBP/oraarch/KBParch1_16201.dbf

BR0203I to /dev/rmt/0mn ...

#ARCHIVE.. /oracle/KBP/oraarch/KBParch1_16201.dbf

#SAVED.... KBParch1_16201.dbf KBPB23/88

BR0280I BRARCHIVE time stamp: 2011-06-14 00.47.12

BR0014I 28 of 37 offline redo log files processed - 1399.946 MB of 1849.937 MB done

BR0204I Percentage done: 75.68%, estimated end time: 0:48

BR0001I **************************************____________

BR0202I Saving /oracle/KBP/oraarch/KBParch1_16202.dbf

BR0203I to /dev/rmt/0mn ...

#ARCHIVE.. /oracle/KBP/oraarch/KBParch1_16202.dbf

#SAVED.... KBParch1_16202.dbf KBPB23/89

BR0280I BRARCHIVE time stamp: 2011-06-14 00.47.23

BR0014I 29 of 37 offline redo log files processed - 1449.944 MB of 1849.937 MB done

BR0204I Percentage done: 78.38%, estimated end time: 0:48

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

BR0202I Saving /oracle/KBP/oraarch/KBParch1_16203.dbf

BR0203I to /dev/rmt/0mn ...

#ARCHIVE.. /oracle/KBP/oraarch/KBParch1_16203.dbf

#SAVED.... KBParch1_16203.dbf KBPB23/90

BR0280I BRARCHIVE time stamp: 2011-06-14 00.47.34

BR0014I 30 of 37 offline redo log files processed - 1499.943 MB of 1849.937 MB done

BR0204I Percentage done: 81.08%, estimated end time: 0:48

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

BR0202I Saving /oracle/KBP/oraarch/KBParch1_16204.dbf

BR0203I to /dev/rmt/0mn ...

#ARCHIVE.. /oracle/KBP/oraarch/KBParch1_16204.dbf

#SAVED.... KBParch1_16204.dbf KBPB23/91

BR0280I BRARCHIVE time stamp: 2011-06-14 00.47.46

BR0014I 31 of 37 offline redo log files processed - 1549.942 MB of 1849.937 MB done

BR0204I Percentage done: 83.78%, estimated end time: 0:48

BR0001I ******************************************________

BR0202I Saving /oracle/KBP/oraarch/KBParch1_16205.dbf

BR0203I to /dev/rmt/0mn ...

#ARCHIVE.. /oracle/KBP/oraarch/KBParch1_16205.dbf

#SAVED.... KBParch1_16205.dbf KBPB23/92

BR0280I BRARCHIVE time stamp: 2011-06-14 00.47.57

BR0014I 32 of 37 offline redo log files processed - 1599.941 MB of 1849.937 MB done

BR0204I Percentage done: 86.49%, estimated end time: 0:48

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

BR0202I Saving /oracle/KBP/oraarch/KBParch1_16206.dbf

BR0203I to /dev/rmt/0mn ...

#ARCHIVE.. /oracle/KBP/oraarch/KBParch1_16206.dbf

#SAVED.... KBParch1_16206.dbf KBPB23/93

BR0280I BRARCHIVE time stamp: 2011-06-14 00.48.08

BR0014I 33 of 37 offline redo log files processed - 1649.940 MB of 1849.937 MB done

BR0204I Percentage done: 89.19%, estimated end time: 0:48

BR0001I *********************************************_____

BR0202I Saving /oracle/KBP/oraarch/KBParch1_16207.dbf

BR0203I to /dev/rmt/0mn ...

#ARCHIVE.. /oracle/KBP/oraarch/KBParch1_16207.dbf

#SAVED.... KBParch1_16207.dbf KBPB23/94

BR0280I BRARCHIVE time stamp: 2011-06-14 00.48.19

BR0014I 34 of 37 offline redo log files processed - 1699.939 MB of 1849.937 MB done

BR0204I Percentage done: 91.89%, estimated end time: 0:48

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

BR0202I Saving /oracle/KBP/oraarch/KBParch1_16208.dbf

BR0203I to /dev/rmt/0mn ...

#ARCHIVE.. /oracle/KBP/oraarch/KBParch1_16208.dbf

#SAVED.... KBParch1_16208.dbf KBPB23/95

BR0280I BRARCHIVE time stamp: 2011-06-14 00.48.30

BR0014I 35 of 37 offline redo log files processed - 1749.938 MB of 1849.937 MB done

BR0204I Percentage done: 94.59%, estimated end time: 0:48

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

BR0202I Saving /oracle/KBP/oraarch/KBParch1_16209.dbf

BR0203I to /dev/rmt/0mn ...

#ARCHIVE.. /oracle/KBP/oraarch/KBParch1_16209.dbf

#SAVED.... KBParch1_16209.dbf KBPB23/96

BR0280I BRARCHIVE time stamp: 2011-06-14 00.48.41

BR0014I 36 of 37 offline redo log files processed - 1799.938 MB of 1849.937 MB done

BR0204I Percentage done: 97.30%, estimated end time: 0:48

BR0001I *************************************************_

BR0202I Saving /oracle/KBP/oraarch/KBParch1_16210.dbf

BR0203I to /dev/rmt/0mn ...

#ARCHIVE.. /oracle/KBP/oraarch/KBParch1_16210.dbf

#SAVED.... KBParch1_16210.dbf KBPB23/97

BR0280I BRARCHIVE time stamp: 2011-06-14 00.48.53

BR0014I 37 of 37 offline redo log files processed - 1849.937 MB of 1849.937 MB done

BR0204I Percentage done: 100.00%, estimated end time: 0:48

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

BR0280I BRARCHIVE time stamp: 2011-06-14 00.48.53

BR0012I 3 next offline redo log files found for processing, total size 149.992 MB

BR0202I Saving /oracle/KBP/oraarch/KBParch1_16211.dbf

BR0203I to /dev/rmt/0mn ...

#ARCHIVE.. /oracle/KBP/oraarch/KBParch1_16211.dbf

#SAVED.... KBParch1_16211.dbf KBPB23/98

BR0280I BRARCHIVE time stamp: 2011-06-14 00.49.04

BR0014I 1 of 3 offline redo log files processed - 49.999 MB of 149.992 MB done

BR0204I Percentage done: 33.33%, estimated end time: 0:49

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

BR0202I Saving /oracle/KBP/oraarch/KBParch1_16212.dbf

BR0203I to /dev/rmt/0mn ...

#ARCHIVE.. /oracle/KBP/oraarch/KBParch1_16212.dbf

#SAVED.... KBParch1_16212.dbf KBPB23/99

BR0280I BRARCHIVE time stamp: 2011-06-14 00.49.15

BR0014I 2 of 3 offline redo log files processed - 99.998 MB of 149.992 MB done

BR0204I Percentage done: 66.67%, estimated end time: 0:49

BR0001I *********************************_________________

BR0202I Saving /oracle/KBP/oraarch/KBParch1_16213.dbf

BR0203I to /dev/rmt/0mn ...

#ARCHIVE.. /oracle/KBP/oraarch/KBParch1_16213.dbf

#SAVED.... KBParch1_16213.dbf KBPB23/100

BR0280I BRARCHIVE time stamp: 2011-06-14 00.49.26

BR0014I 3 of 3 offline redo log files processed - 149.992 MB of 149.992 MB done

BR0204I Percentage done: 100.00%, estimated end time: 0:49

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

BR0016I 64 offline redo log files processed, total size 3199.880 MB

BR0202I Saving space_log

BR0203I to /dev/rmt/0mn ...

BR0202I Saving det_log

BR0203I to /dev/rmt/0mn ...

BR0202I Saving sum_log

BR0203I to /dev/rmt/0mn ...

BR0280I BRARCHIVE time stamp: 2011-06-14 00.49.52

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

BR0351I Restoring /oracle/KBP/sapreorg/.tape.hdr0

BR0280I BRARCHIVE time stamp: 2011-06-14 00.49.52

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

BR0351I Restoring /oracle/KBP/sapreorg/.tape.hdr0

BR0355I from /dev/rmt/0mn ...

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

BR0280I BRARCHIVE time stamp: 2011-06-14 00.50.46

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

BR0007I End of offline redo log processing: aegchcdz.cds 2011-06-14 00.51.11

BR0280I BRARCHIVE time stamp: 2011-06-14 00.51.11

BR0003I BRARCHIVE completed successfully

former_member182034
Active Contributor
0 Kudos

hi Rushi,

don't worry about this reg sign because your action is successfully completed.

Please check following note

Note 412980 - DB13: Some DBA actions are always displayed in red

134592

Regards,

majamil

Former Member
0 Kudos

Thanks majamil,

I checked mentioed notes. Below jobs are mentioned in this note -

  • Verify database

  • Compress database

  • Prepare for RMAN backup

  • Initialize tape

But the action I am scheduling is All offline backup + log backup.

I observerd the DB13 LOG for las few days and I come to know that

1. For few tmes AllOff+Log is copying only Redolog files ( No data files , no contrrol files ) at that time DB13 STATUS is in red

2. For few days AllOff+Log is copying Redo log , data files and control files as well.At these occasions db13 status is Green .

If someone can guide whether its ok or not then it would be really helpful.

Thanks,

Rushi

Former Member
0 Kudos

Don't rely on the log files you can see in DB13, but log in to your Unix system and check logfiles in sapbackup and saparch directory!

For example you posted a log file edo log backup log from 14.06.2011 00:37:34 aegchcdz.cds.

This is from saparch.

Now go and have a look if there is another log file in sapbackup directory with almost the same time stamp.

If so, it will tell you what was the reason of the failure.

hope this helps

Edited by: Joe Bo on Jun 15, 2011 1:43 PM (typo)