on 06-15-2011 8:05 AM
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
Hai....
I think you are checking from Jobs -> Central Calender , it is not a issue
KHS
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 **________________________________________________
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
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
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)
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.