Skip to Content
0
Former Member
Dec 04, 2008 at 08:28 AM

Online backup via BRTOOLS

1785 Views

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.