Online backup via BRTOOLS

[Former Member]

Hi there!

I am planning to implement an online backup using brtools. When I did the testing, I noticed an error that prevents me from completing the backup. Hope anybody can help me. It seems that there is an error with the compress command but I cant seem to understand why. Below is the entire log of my backup. Btw, Im using ECC6 and Oracle Database 10g.

Thanks in advance.

>>> TNVT - to host 172.16.0.5

su - e6padm

AMC-E6P-DB:e6padm 1> brtools

BR0651I BRTOOLS 7.00 (18)

BR0280I BRTOOLS time stamp: 2008-10-26 00.32.45

BR0656I Choice menu 1 - please make a selection

-

---

BR*Tools main menu

1 = Instance management

2 - Space management

3 - Segment management

4 - Backup and database copy

5 - Restore and recovery

6 - Check and verification

7 - Database statistics

8 - Additional functions

9 - Exit program

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

---

BR0662I Enter your choice:

4

BR0280I BRTOOLS time stamp: 2008-10-26 00.32.50

BR0663I Your choice: '4'

BR0280I BRTOOLS time stamp: 2008-10-26 00.32.50

BR0656I Choice menu 9 - please make a selection

-

---

Backup and database copy

1 = Database backup

2 - Archivelog backup

3 - Database copy

4 - Non-database backup

5 - Backup of database disk backup

6 - Verification of database backup

7 - Verification of archivelog backup

8 - Additional functions

9 - Reset program status

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

---

BR0662I Enter your choice:

1

BR0280I BRTOOLS time stamp: 2008-10-26 00.32.51

BR0663I Your choice: '1'

BR0280I BRTOOLS time stamp: 2008-10-26 00.32.51

BR0657I Input menu 15 - please check/enter input values

-

---

BRBACKUP main options for backup and database copy

1 - BRBACKUP profile (profile) ....... [initE6P.sap]

2 - Backup device type (device) ...... [disk]

3 # Tape volumes for backup (volume) . []

4 # BACKINT/Mount profile (parfile) .. []

5 - Database user/password (user) .... [/]

6 - Backup type (type) ............... [online]

7 # Disk backup for backup (backup) .. [no]

8 # Delete disk backup (delete) ...... [no]

9 ~ Files for backup (mode) .......... [all]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

---

BR0662I Enter your choice:

c

BR0280I BRTOOLS time stamp: 2008-10-26 00.32.55

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0280I BRTOOLS time stamp: 2008-10-26 00.32.55

BR0657I Input menu 16 - please check/enter input values

-

---

Additional BRBACKUP options for backup and database copy

1 - Confirmation mode (confirm) ....... [yes]

2 - Query mode (query) ................ [no]

3 - Compression mode (compress) ....... [yes]

4 - Verification mode (verify) ........ [no]

5 - Fill-up previous backups (fillup) . [no]

6 - Parallel execution (execute) ...... [0]

7 - Additional output (output) ........ [no]

8 - Message language (language) ....... [E]

9 - BRBACKUP command line (command) ... [-p initE6P.sap -d disk -t online -m all -k yes -e 0 -l E]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

---

BR0662I Enter your choice:

c

BR0280I BRTOOLS time stamp: 2008-10-26 00.32.59

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0291I BRBACKUP will be started with options '-p initE6P.sap -d disk -t online -m all -k yes -e 0 -l E'

BR0280I BRTOOLS time stamp: 2008-10-26 00.32.59

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

c

BR0280I BRTOOLS time stamp: 2008-10-26 00.33.00

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

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

BR0051I BRBACKUP 7.00 (18)

BR0055I Start of database backup: bdzcoptc.and 2008-10-26 00.33.00

BR0477I Oracle pfile /oracle/E6P/102_64/dbs/initE6P.ora created from spfile /oracle/E6P/102_64/dbs/spfileE6P.ora

BR0280I BRBACKUP time stamp: 2008-10-26 00.33.01

BR0319I Control file copy created: /oracle/E6P/sapbackup/cntrlE6P.dbf 18268160

BR0280I BRBACKUP time stamp: 2008-10-26 00.33.02

BR0057I Backup of database: E6P

BR0058I BRBACKUP action ID: bdzcoptc

BR0059I BRBACKUP function ID: and

BR0110I Backup mode: ALL

BR0077I Database file for backup: /oracle/E6P/sapbackup/cntrlE6P.dbf

BR0061I 44 files found for backup, total size 178457.758 MB

BR0143I Backup type: online

BR0111I Files will be compressed

BR0130I Backup device type: disk

BR0106I Files will be saved on disk in directory: /installer/backup/E6P/bdzcoptc

BR0280I BRBACKUP time stamp: 2008-10-26 00.33.02

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

c

BR0280I BRBACKUP time stamp: 2008-10-26 00.33.03

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0370I Directory /installer/backup/E6P/bdzcoptc created

BR0370I Directory /installer/backup/E6P/E6P created

BR0202I Saving init_ora

BR0203I to /installer/backup/E6P/E6P ...

BR0202I Saving /oracle/E6P/102_64/dbs/initE6P.sap

BR0203I to /installer/backup/E6P/E6P ...

BR0280I BRBACKUP time stamp: 2008-10-26 00.33.03

BR0198I Profiles saved successfully

BR0280I BRBACKUP time stamp: 2008-10-26 00.33.04

BR0315I 'Alter tablespace PSAPSR3 begin backup' successful

BR0201I Compressing /oracle/E6P/sapdata1/sr3_1/sr3.data1

BR0203I to /installer/backup/E6P/bdzcoptc/sr3.data1.Z ...

BR0278E Command output of 'LANG=C compress -c /oracle/E6P/sapdata1/sr3_1/sr3.data1 > /installer/backup/E6P/bdzcoptc/sr3.data1.Z':

/oracle/E6P/sapdata1/sr3_1/sr3.data1: Invalid argument

BR0280I BRBACKUP time stamp: 2008-10-26 00.33.04

BR0279E Return code from 'LANG=C compress -c /oracle/E6P/sapdata1/sr3_1/sr3.data1 > /installer/backup/E6P/bdzcoptc/sr3.data1.Z': 1

BR0224E Compressing /oracle/E6P/sapdata1/sr3_1/sr3.data1 to /installer/backup/E6P/bdzcoptc/sr3.data1.Z failed due to previous errors

BR0280I BRBACKUP time stamp: 2008-10-26 00.33.07

BR0317I 'Alter tablespace PSAPSR3 end backup' successful

BR0056I End of database backup: bdzcoptc.and 2008-10-26 00.33.04

BR0280I BRBACKUP time stamp: 2008-10-26 00.33.08

BR0054I BRBACKUP terminated with errors

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

BR0292I Execution of BRBACKUP finished with return code 5

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

BR0280I BRTOOLS time stamp: 2008-10-26 00.33.08

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

s

BR0280I BRTOOLS time stamp: 2008-10-26 00.33.12

BR0257I Your reply: 's'

BR0679I Do you really want to cancel BRTOOLS? Enter y[es]/n[o]:

y

BR0280I BRTOOLS time stamp: 2008-10-26 00.33.13

BR0257I Your reply: 'y'

BR0260E BRTOOLS cancelled by user

BR0280I BRTOOLS time stamp: 2008-10-26 00.33.13

BR0654I BRTOOLS terminated with errors

AMC-E6P-DB:e6padm 2> exit

AMC-E6P-DB:e6padm 3> logout

>>>Closing capture file.

[Former Member · Accepted solution]

Hi Eric,

Before I go with the brarchive upgrade, the note says that the problem happens in Windows systems that uses a language other than English. In my case, I am using IBM AIX 5.3.0.0 and using English language. Should I still proceed with the upgrade or would you recommend another approach. Im willing to do the upgrade but I also think I need to furnish this thread with my real setup/config.

Thanks in advance

[former_member204746 · Accepted solution]

a BRTOOLS upgrade is simple to make and risks are minimal. if this does not work, you can easily go back to previous version (as long as you copied the files before overwriting them).

It might not resolve your problem, but you won<t know until you actually do the change.

good luck.

[Former Member · Accepted solution]

Hi there,

I have already upgraded our brtools (from BRTOOLS 7.0 (18) to BRTOOLS 7.0 (40) ) but I still encounter the same problem.

Anymore advices/recommendations?

Thanks

[Former Member · Accepted solution]

File size limitations perhaps?

What is the size of /oracle/E6P/sapdata1/sr3_1/sr3.data1 ?

Two things that have to be checked:

1) Your version of compress command may not work with large files.

2) Not sure about AIX, but some flavours of Unix require special file system options if large files will be used.

For a check, you could try this:

Copy /oracle/E6P/sapdata1/sr3_1/sr3.data1 to directory /installer/backup/E6P/bdzcoptc.

Then compress it there.

Does this work?

Any error messages?

hope this helps

[Former Member · Accepted solution]

Hi Joe,

Thanks for the insights. The size of the file is 5557460992bytes (approx 5.6GB). Im currently working on the mount options for the JS2 filesystems in UNIX. If it still doesnt work, I'll also try your suggestion. Will give feedback as soon as possible.

Thanks for the quick response.

[Former Member]

Ok. In that case, I may no longer need to upload the log of the successful backup. Will try to update brtools and see what happens.

Thanks

[Former Member]

Hi Scott,

Thank you for the quick reply. However, I have another thing to bring up. I created an exact replica of this instance to a separate server for my online backup testing. I used mksysb for my rootvg and created a backup of my datavg and restored it to the new server. To my surprise, my online backup worked. Im currently running it so that I can upload the log in this thread. I checked on the version of the brtools and they are both of the same level. Also, I forgot to mention that I've been using offline backup via brtools since last year. It was only now that Im trying to implement an online backup. Would this problem still be caused by brarchive patch 18?

Thanks in advance!

[former_member204746]

brtools 15 to 18 have problems with this. it may not occur under all circumstances.

so, do what the note tells you to do and update brtools now.

[Former Member]

Have a look at note 994136 - Backup to hard disk fails with error BR0278E

"Reason and Prerequisites

This error is due to a program error in BR*Tools 7.00 patches 15 - 18.

Solution

The error is corrected in BRARCHIVE 7.00 Patch 19."