BR0292I Execution of BRBACKUP finished with return code 1

[Former Member]

i am taking a offline backup, after finished the backup, error comes ,

*BR0202I Saving E:\oracle\HOD\origlogA\cntrl\cntrlHOD.dbf

BR0203I to G:\backupoff\beccpxlq\cntrlHOD.dbf ...

#FILE..... E:\oracle\HOD\origlogA\cntrl\cntrlHOD.dbf

#SAVED.... G:\backupoff\beccpxlq\cntrlHOD.dbf #1/38 1.0000:1 6938624

BR0280I BRBACKUP time stamp: 2009-12-12 18.35.01

BR0063I 38 of 38 files processed - 95592.877 MB of 95592.877 MB done

BR0204I Percentage done: 100.00%, estimated end time: 18:35

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

BR0280I BRBACKUP time stamp: 2009-12-12 18.35.05

BR0304I Starting and opening database instance HOD ...

BR0280I BRBACKUP time stamp: 2009-12-12 18.35.20

BR0305I Start and open of database instance HOD successful

BR0202I Saving space_log

BR0203I to G:\backupoff\HOD ...

BR0202I Saving E:\oracle\HOD\sapbackup\beccpxlq.afd

BR0203I to G:\backupoff\HOD ...

BR0202I Saving E:\oracle\HOD\sapbackup\backHOD.log

BR0203I to G:\backupoff\HOD ...

BR0056I End of database backup: beccpxlq.afd 2009-12-12 18.35.22

BR0280I BRBACKUP time stamp: 2009-12-12 18.35.23

BR0053I BRBACKUP completed successfully with warnings

###############################################################################

BR0292I Execution of BRBACKUP finished with return code 1

BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action

BR0280I BRTOOLS time stamp: 2009-12-12 18.35.23

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:*

[Former Member]

Hi Techie,

i Run COMPRESS DB from DB13 and now i took offline back again. 

Br02921 execusion of brbook with finished with return code 0

when i check the log file there is not giving any error

I thought that it means your problem has resolved and now you are able to take backup without any error.

And i suggested you to close this message because: your issue got resoved, and the root cause also clearly mentioned that Compression rates are out of date.......

Above has my suggetion not an orderor request.

when will i resolve my issue i will close this

Yes deffenately you have that freedom

Regards

Nick Loy

[Former Member]

how can i closed

[Former Member]

Please close this thread, if you are satisfied/issues resolved

[Former Member]

Mr. Nicy

for your kind information this side for resolve problem.if i am getting some porblem then i send querry.

if you are not enable to solve pls. don;'t commets on any porblme.

as per my early msg. there i am asking for my error, when will i resolve my issue i will close this

pls. help out the problem

[Former Member]

Hi,

Run COMPRESS DB from DB13 or from BRTOOLS.

Regards

Nick Loy

[Former Member]

hi

i Run COMPRESS DB from DB13 and now i took offline back again.

Br02921 execusion of brbook with finished with return code 0

when i check the log file there is not giving any error

[Former Member]

Hi,

There are no warnings as such can be seen from the logs you have posted.

Check if there are ay warnings shown before the start of the backup.

Please post the same if there are any.

Cheers....,

Raghu

[Former Member]

dear raghu

after finishing brbook , the i got a msg as i have posted early mail

which log i wil have to check

[Former Member]

Hi,

Check the file beccpxlq.afd which is located in the backup location.

Please check if this file contains any warnings.

Please post them.

Cheers.....,

Raghu

[Former Member]

BR0051I BRBACKUP 6.40 (34)

BR0055I Start of database backup: beccpxlq.afd 2009-12-12 17.31.38

BR0477I Oracle pfile D:\ORACLE\HOD\920\database\initHOD.ora created from spfile D:\ORACLE\HOD\920\database\spfileHOD.ora

BR0083W Compression rates out of date - run BRBACKUP with option '-k only'

BR0101I Parameters

Name Value

oracle_sid HOD

oracle_home D:\ORACLE\HOD\920

oracle_profile D:\ORACLE\HOD\920\database\initHOD.ora

sapdata_home E:\oracle\HOD

sap_profile D:\ORACLE\HOD\920\database\initHOD.sap

backup_mode ALL

backup_type offline

backup_dev_type disk

backup_root_dir G:\backupoff

compress hardware

disk_copy_cmd copy

cpio_disk_flags -pdcu

exec_parallel 0

system_info HODADM HOLDEV Windows 5.2 Build 3790 Service Pack 1 Intel

oracle_info HOD 9.2.0.6.0 8192 9964 117031233

sap_info 640 SAPHOD HOD L1140159252 R3_ORA 0020197850

make_info NTintel OCI_920_SHARE Sep 6 2005

command_line E:\usr\sap\HOD\SYS\exe\run\brbackup.exe -p initHOD.sap -d disk -t offline -m all -k hardware -e 0 -l E -U

BR0116I ARCHIVE LOG LIST before backup for database instance HOD

Parameter Value

Database log mode Archive Mode

Automatic archival Enabled

Archive destination D:\oracle\HOD\oraarch\HODarch

Archive format ARC%S.%T

Oldest online log sequence 9961

Next log sequence to archive 9964

Current log sequence 9964 SCN: 117031233

Database block size 8192 Thread: 1

BR0118I Tablespaces and data files

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

PSAPHOD ONLINE* ONLINE+ E:\ORACLE\HOD\SAPDATA3\HOD_1\HOD.DATA1 2600476672 3 4 NOLINK FILE 10485760000 20971520

PSAPHOD ONLINE* ONLINE+ E:\ORACLE\HOD\SAPDATA3\HOD_2\HOD.DATA2 2684362752 4 4 NOLINK FILE 10485760000 20971520

PSAPHOD ONLINE* ONLINE+ E:\ORACLE\HOD\SAPDATA3\HOD_3\HOD.DATA3 2579505152 5 4 NOLINK FILE 10485760000 20971520

PSAPHOD ONLINE* ONLINE+ E:\ORACLE\HOD\SAPDATA3\HOD_4\HOD.DATA4 2537562112 6 4 NOLINK FILE 10485760000 20971520

PSAPHOD ONLINE* ONLINE+ E:\ORACLE\HOD\SAPDATA4\HOD_6\HOD.DATA6 2495619072 8 4 NOLINK FILE 10485760000 20971520

PSAPHOD ONLINE* ONLINE+ E:\ORACLE\HOD\SAPDATA4\HOD_8\HOD.DATA8 2411732992 10 4 NOLINK FILE 10485760000 20971520

PSAPHOD ONLINE* ONLINE+ E:\ORACLE\HOD\SAPDATA4\HOD_10\HOD.DATA10 2453676032 12 4 NOLINK FILE 10485760000 20971520

PSAPHOD ONLINE* ONLINE+ E:\ORACLE\HOD\SAPDATA4\HOD_9\HOD.DATA9 3514834944 11 4 NOLINK FILE 10485760000 20971520

PSAPHOD ONLINE* ONLINE+ E:\ORACLE\HOD\SAPDATA4\HOD_7\HOD.DATA7 2474647552 9 4 NOLINK FILE 10485760000 20971520

PSAPHOD ONLINE* ONLINE+ E:\ORACLE\HOD\SAPDATA4\HOD_12\HOD.DATA12 2453676032 32 4 NOLINK FILE 10485760000 20971520

PSAPHOD ONLINE* ONLINE+ E:\ORACLE\HOD\SAPDATA4\HOD_11\HOD.DATA11 2369789952 31 4 NOLINK FILE 10485760000 20971520

PSAPHOD ONLINE* ONLINE+ E:\ORACLE\HOD\SAPDATA3\HOD_5\HOD.DATA5 2537562112 7 4 NOLINK FILE 10485760000 20971520

PSAPHOD640 ONLINE* ONLINE+ E:\ORACLE\HOD\SAPDATA1\HOD640_1\HOD640.DATA1 2097160192 13 4 NOLINK FILE 10485760000 20971520

PSAPHOD640 ONLINE* ONLINE+ E:\ORACLE\HOD\SAPDATA1\HOD640_2\HOD640.DATA2 2097160192 14 4 NOLINK FILE 10485760000 20971520

PSAPHOD640 ONLINE* ONLINE+ E:\ORACLE\HOD\SAPDATA1\HOD640_4\HOD640.DATA4 2097160192 16 4 NOLINK FILE 10485760000 20971520

PSAPHOD640 ONLINE* ONLINE+ E:\ORACLE\HOD\SAPDATA2\HOD640_6\HOD640.DATA6 2097160192 18 4 NOLINK FILE 10485760000 20971520

PSAPHOD640 ONLINE* ONLINE+ E:\ORACLE\HOD\SAPDATA2\HOD640_8\HOD640.DATA8 2097160192 20 4 NOLINK FILE 10485760000 20971520

PSAPHOD640 ONLINE* ONLINE+ E:\ORACLE\HOD\SAPDATA2\HOD640_10\HOD640.DATA10 2097160192 22 4 NOLINK FILE 10485760000 20971520

PSAPHOD640 ONLINE* ONLINE+ E:\ORACLE\HOD\SAPDATA4\HOD640_12\HOD640.DATA12 2097160192 24 4 NOLINK FILE 10485760000 20971520

PSAPHOD640 ONLINE* ONLINE+ E:\ORACLE\HOD\SAPDATA4\HOD640_15\HOD640.DATA15 4194312192 30 4 NOLINK FILE 10485760000 20971520

PSAPHOD640 ONLINE* ONLINE+ E:\ORACLE\HOD\SAPDATA4\HOD640_14\HOD640.DATA14 4194312192 29 4 NOLINK FILE 10485760000 20971520

PSAPHOD640 ONLINE* ONLINE+ E:\ORACLE\HOD\SAPDATA4\HOD640_13\HOD640.DATA13 2097160192 25 4 NOLINK FILE 10485760000 20971520

PSAPHOD640 ONLINE* ONLINE+ E:\ORACLE\HOD\SAPDATA3\HOD640_11\HOD640.DATA11 2097160192 23 4 NOLINK FILE 10485760000 20971520

PSAPHOD640 ONLINE* ONLINE+ E:\ORACLE\HOD\SAPDATA2\HOD640_9\HOD640.DATA9 2097160192 21 4 NOLINK FILE 10485760000 20971520

PSAPHOD640 ONLINE* ONLINE+ E:\ORACLE\HOD\SAPDATA2\HOD640_7\HOD640.DATA7 2097160192 19 4 NOLINK FILE 10485760000 20971520

PSAPHOD640 ONLINE* ONLINE+ E:\ORACLE\HOD\SAPDATA1\HOD640_5\HOD640.DATA5 2097160192 17 4 NOLINK FILE 10485760000 20971520

PSAPHOD640 ONLINE* ONLINE+ E:\ORACLE\HOD\SAPDATA1\HOD640_3\HOD640.DATA3 2097160192 15 4 NOLINK FILE 10485760000 20971520

PSAPHODUSR ONLINE* ONLINE+ E:\ORACLE\HOD\SAPDATA4\HODUSR_1\HODUSR.DATA1 20979712 26 4 NOLINK FILE 10485760000 20971520

PSAPTEMP ONLINE# ONLINE+ E:\ORACLE\HOD\SAPDATA1\TEMP_1\TEMP.DATA1 702554112 -1 4 NOLINK FILE 10485760000 20971520

PSAPUNDO ONLINE- ONLINE+ E:\ORACLE\HOD\SAPDATA1\UNDO_1\UNDO.DATA1 10485768192 2 4 NOLINK FILE 10485760000 20971520

PSAPUNDO ONLINE- ONLINE E:\ORACLE\HOD\SAPDATA1\UNDO_3\UNDO.DATA3 10485768192 28 4 NOLINK FILE 0 0

PSAPUNDO ONLINE- ONLINE E:\ORACLE\HOD\SAPDATA1\UNDO_2\UNDO.DATA2 10485768192 27 4 NOLINK FILE 0 0

SYSTEM ONLINE* SYSTEM+ E:\ORACLE\HOD\SAPDATA1\SYSTEM_1\SYSTEM.DATA1 1073750016 1 4 NOLINK FILE 10485760000 20971520

BR0119I Redo log files

File Size Group Device Status Link Type

E:\ORACLE\HOD\ORIGLOGA\LOG_G11M1.DBF 52429312 1 4 INUSE NOLINK FILE

E:\ORACLE\HOD\MIRRLOGA\LOG_G11M2.DBF 52429312 1 4 INUSE NOLINK FILE

E:\ORACLE\HOD\ORIGLOGB\LOG_G12M1.DBF 52429312 2 4 INUSE NOLINK FILE

E:\ORACLE\HOD\MIRRLOGB\LOG_G12M2.DBF 52429312 2 4 INUSE NOLINK FILE

E:\ORACLE\HOD\ORIGLOGA\LOG_G13M1.DBF 52429312 3 4 STALE NOLINK FILE

E:\ORACLE\HOD\MIRRLOGA\LOG_G13M2.DBF 52429312 3 4 STALE NOLINK FILE

E:\ORACLE\HOD\ORIGLOGB\LOG_G14M1.DBF 52429312 4 4 INUSE NOLINK FILE

E:\ORACLE\HOD\MIRRLOGB\LOG_G14M2.DBF 52429312 4 4 INUSE NOLINK FILE

BR0120I Control files

File Size Id. Device Link Type

E:\oracle\HOD\origlogA\cntrl\cntrlHOD.dbf 6938624 0 4 NOLINK FILE

E:\oracle\HOD\sapdata1\system_1\cntrl\cntrlHOD.dbf 6938624 0 4 NOLINK FILE

E:\oracle\HOD\saparch\cntrl\cntrlHOD.dbf 6938624 0 4 NOLINK FILE

BR0280I BRBACKUP time stamp: 2009-12-12 17.31.40

BR0057I Backup of database: HOD

BR0058I BRBACKUP action ID: beccpxlq

BR0059I BRBACKUP function ID: afd

BR0110I Backup mode: ALL

BR0077I Database files for backup:

E:\ORACLE\HOD\ORIGLOGA\LOG_G11M1.DBF

E:\ORACLE\HOD\ORIGLOGB\LOG_G12M1.DBF

E:\ORACLE\HOD\ORIGLOGA\LOG_G13M1.DBF

E:\ORACLE\HOD\ORIGLOGB\LOG_G14M1.DBF

E:\oracle\HOD\origlogA\cntrl\cntrlHOD.dbf

BR0061I 38 files found for backup, total size 95592.877 MB

BR0143I Backup type: offline

BR0113I Files will be compressed by hardware

BR0130I Backup device type: disk

BR0106I Files will be saved on disk in directory: G:\backupoff\beccpxlq

BR0064I Database instance HOD will be shut down now

BR0280I BRBACKUP time stamp: 2009-12-12 17.31.40

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRBACKUP:

BR0280I BRBACKUP time stamp: 2009-12-12 17.32.18

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0370I Directory G:\backupoff\beccpxlq created

BR0370I Directory G:\backupoff\HOD created

BR0202I Saving init_ora

BR0203I to G:\backupoff\HOD ...

BR0202I Saving D:\ORACLE\HOD\920\database\initHOD.sap

BR0203I to G:\backupoff\HOD ...

BR0280I BRBACKUP time stamp: 2009-12-12 17.32.19

BR0198I Profiles saved successfully

BR0280I BRBACKUP time stamp: 2009-12-12 17.32.19

BR0307I Shutting down database instance HOD ...

BR0280I BRBACKUP time stamp: 2009-12-12 17.32.25

BR0308I Shutdown of database instance HOD successful

BR0202I Saving E:\ORACLE\HOD\SAPDATA3\HOD_1\HOD.DATA1

BR0203I to G:\backupoff\beccpxlq\HOD.DATA1 ...

#FILE..... E:\ORACLE\HOD\SAPDATA3\HOD_1\HOD.DATA1

#SAVED.... G:\backupoff\beccpxlq\HOD.DATA1 #1/1 1.0000:1 2600476672

BR0280I BRBACKUP time stamp: 2009-12-12 17.34.01

BR0063I 1 of 38 files processed - 2480.008 MB of 95592.877 MB done

BR0204I Percentage done: 2.59%, estimated end time: 18:38

BR0001I *_________________________________________________

BR0202I Saving E:\ORACLE\HOD\SAPDATA1\SYSTEM_1\SYSTEM.DATA1

BR0203I to G:\backupoff\beccpxlq\SYSTEM.DATA1 ...

#FILE..... E:\ORACLE\HOD\SAPDATA1\SYSTEM_1\SYSTEM.DATA1

#SAVED.... G:\backupoff\beccpxlq\SYSTEM.DATA1 #1/33 1.0000:1 1073750016

BR0280I BRBACKUP time stamp: 2009-12-12 18.34.34

BR0063I 33 of 38 files processed - 95386.258 MB of 95592.877 MB done

BR0204I Percentage done: 99.78%, estimated end time: 18:34

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

BR0202I Saving E:\ORACLE\HOD\ORIGLOGA\LOG_G11M1.DBF

BR0203I to G:\backupoff\beccpxlq\LOG_G11M1.DBF ...

#FILE..... E:\ORACLE\HOD\ORIGLOGA\LOG_G11M1.DBF

#SAVED.... G:\backupoff\beccpxlq\LOG_G11M1.DBF #1/34 1.0000:1 52429312

BR0280I BRBACKUP time stamp: 2009-12-12 18.34.54

BR0063I 34 of 38 files processed - 95436.258 MB of 95592.877 MB done

BR0204I Percentage done: 99.84%, estimated end time: 18:35

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

BR0202I Saving E:\ORACLE\HOD\ORIGLOGB\LOG_G12M1.DBF

BR0203I to G:\backupoff\beccpxlq\LOG_G12M1.DBF ...

#FILE..... E:\ORACLE\HOD\ORIGLOGB\LOG_G12M1.DBF

#SAVED.... G:\backupoff\beccpxlq\LOG_G12M1.DBF #1/35 1.0000:1 52429312

BR0280I BRBACKUP time stamp: 2009-12-12 18.34.55

BR0063I 35 of 38 files processed - 95486.259 MB of 95592.877 MB done

BR0204I Percentage done: 99.89%, estimated end time: 18:34

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

BR0202I Saving E:\ORACLE\HOD\ORIGLOGA\LOG_G13M1.DBF

BR0203I to G:\backupoff\beccpxlq\LOG_G13M1.DBF ...

#FILE..... E:\ORACLE\HOD\ORIGLOGA\LOG_G13M1.DBF

#SAVED.... G:\backupoff\beccpxlq\LOG_G13M1.DBF #1/36 1.0000:1 52429312

BR0280I BRBACKUP time stamp: 2009-12-12 18.34.59

BR0063I 36 of 38 files processed - 95536.259 MB of 95592.877 MB done

BR0204I Percentage done: 99.94%, estimated end time: 18:35

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

BR0202I Saving E:\ORACLE\HOD\ORIGLOGB\LOG_G14M1.DBF

BR0203I to G:\backupoff\beccpxlq\LOG_G14M1.DBF ...

#FILE..... E:\ORACLE\HOD\ORIGLOGB\LOG_G14M1.DBF

#SAVED.... G:\backupoff\beccpxlq\LOG_G14M1.DBF #1/37 1.0000:1 52429312

BR0280I BRBACKUP time stamp: 2009-12-12 18.35.01

BR0063I 37 of 38 files processed - 95586.260 MB of 95592.877 MB done

BR0204I Percentage done: 99.99%, estimated end time: 18:35

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

BR0202I Saving E:\oracle\HOD\origlogA\cntrl\cntrlHOD.dbf

BR0203I to G:\backupoff\beccpxlq\cntrlHOD.dbf ...

#FILE..... E:\oracle\HOD\origlogA\cntrl\cntrlHOD.dbf

#SAVED.... G:\backupoff\beccpxlq\cntrlHOD.dbf #1/38 1.0000:1 6938624

BR0280I BRBACKUP time stamp: 2009-12-12 18.35.01

BR0063I 38 of 38 files processed - 95592.877 MB of 95592.877 MB done

BR0204I Percentage done: 100.00%, estimated end time: 18:35

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

BR0280I BRBACKUP time stamp: 2009-12-12 18.35.05

BR0304I Starting and opening database instance HOD ...

BR0280I BRBACKUP time stamp: 2009-12-12 18.35.20

BR0305I Start and open of database instance HOD successful

BR0117I ARCHIVE LOG LIST after backup for database instance HOD

Parameter Value

Database log mode Archive Mode

Automatic archival Enabled

Archive destination D:\oracle\HOD\oraarch\HODarch

Archive format ARC%S.%T

Oldest online log sequence 9961

Next log sequence to archive 9964

Current log sequence 9964 SCN: 117031233

Database block size 8192 Thread: 1

BR0202I Saving space_log

BR0203I to G:\backupoff\HOD ...

BR0202I Saving E:\oracle\HOD\sapbackup\beccpxlq.afd

BR0203I to G:\backupoff\HOD ...

[Former Member]

kumarpramod,

please, ...

Next time please search for the warnings yourself, and do not post the whole log.

My eyes hurt when I try to read such an ill-formatted log.

(Formatting is not your fault by the way; it's the forum software.)

A hint: Warnings in brbackup log files are lines beginning with BR, then 4 digits, then W for Warning.

I did the search for you:

BR0083W Compression rates out of date - run BRBACKUP with option '-k only'

Well, now follow this suggestion!

regards

[Former Member]

Hi,

Please do some research before you post. There is warning BR0083W Compression rates out of date - run BRBACKUP with option '-k only'.

There are lot of links available if you search with the warning string.

Well, the warning itself is self-explanatory. To eliminate the warning, you need to run brbackup with -k option.

Cheeers......,

Raghu