Backup fail...........................

[Former Member]

Hello my backup going to be fail... logs as

*******************************************************************************************

Job started

Step 001 started (program RSDBAJOB, variant &0000000000241, user ID BASIS)

Execute logical command BRBACKUP On host sapodev

Parameters:-u / -jid ALL__20080802111822 -c force -t online -m all -p initSAD.disk.sap -v DISK

BR0051I BRBACKUP 7.00 (11)

BR0055I Start of database backup: bdymphcp.and 2008-08-02 11.18.23

BR0477I Oracle pfile /oracle/SAD/102_64/dbs/initSAD.ora created from spfile /oracle/SAD/102_64/dbs/spfileSAD.ora

BR0280I BRBACKUP time stamp: 2008-08-02 11.18.25

BR0319I Control file copy created: /oracle/SAD/sapbackup/cntrlSAD.dbf 9486336

BR0280I BRBACKUP time stamp: 2008-08-02 11.18.26

BR0057I Backup of database: SAD

BR0058I BRBACKUP action ID: bdymphcp

BR0059I BRBACKUP function ID: and

BR0110I Backup mode: ALL

BR0077I Database file for backup: /oracle/SAD/sapbackup/cntrlSAD.dbf

BR0061I 26 files found for backup, total size 58349.242 MB

BR0143I Backup type: online

BR0111I Files will be compressed

BR0130I Backup device type: disk

BR0106I Files will be saved on disk in directory:/sapbkup/bdymphcp

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

BR0370I Directory /sapbkup/bdymphcp created

BR0202I Saving init_ora

BR0203I to /sapbkup/SAD ...

BR0202I Saving /oracle/SAD/102_64/dbs/initSAD.disk.sap

BR0203I to /sapbkup/SAD ...

BR0280I BRBACKUP time stamp: 2008-08-02 11.18.26

BR0198I Profiles saved successfully

BR0280I BRBACKUP time stamp: 2008-08-02 11.18.40

BR0315I 'Alter tablespace PSAPSR3 begin backup' successful

BR0201I Compressing /oracle/SAD/sapdata2/sr3_5/sr3.data5

BR0203I to /sapbkup/bdymphcp/sr3.data5.Z ...

BR0278E Command output of 'LANG=C compress -c /oracle/SAD/sapdata2/sr3_5/sr3.data5 > /sapbkup/bdymphcp/sr3.data5.Z':

/oracle/SAD/sapdata2/sr3_5/sr3.data5: Invalid argument

BR0280I BRBACKUP time stamp: 2008-08-02 11.18.40

BR0279E Return code from 'LANG=C compress -c /oracle/SAD/sapdata2/sr3_5/sr3.data5 > /sapbkup/bdymphcp/sr3.data5.Z': 1

BR0224E Compressing /oracle/SAD/sapdata2/sr3_5/sr3.data5 to /sapbkup/bdymphcp/sr3.data5.Z failed due to previous errors

BR0056I End of database backup: bdymphcp.and 2008-08-02 11.18.40

BR0280I BRBACKUP time stamp: 2008-08-02 11.18.42

BR0054I BRBACKUP terminated with errors

External program terminated with exit code 5

BRBACKUP returned error status E

Job finished

******************************************************************************

looking for help.

regards

sachin

[Former Member · Accepted solution]

Error Code 3 and 5 occurs because of hardware problem. check the cable or tap derive etc.

Lalit Kumar

[Former Member · Accepted solution]

hi Lalit

im taking backup on disk. my profile is.

******************************************************************************************************************

@(#) $Id: //bas/700_REL/src/ccm/rsbr/initAIX.sap#5 $ SAP

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

1. #

2. SAP backup sample profile. #

3. The parameter syntax is the same as for init.ora parameters. #

4. Enclose parameter values which consist of more than one symbol in #

5. double quotes. #

6. After any symbol, parameter definition can be continued on the next #

7. line. #

8. A parameter value list should be enclosed in parentheses, the list #

9. items should be delimited by commas. #

10. There can be any number of white spaces (blanks, tabs and new lines) #

11. between symbols in parameter definition. #

12. #

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

1. backup mode [all | all_data | full | incr | sap_dir | ora_dir

2. | all_dir | <tablespace_name> | <file_id> | <file_id1>-<file_id2>

3. | <generic_path> | (<object_list>)]

4. default: all

backup_mode = all

1. restore mode [all | all_data | full | incr | incr_only | incr_full

2. | incr_all | <tablespace_name> | <file_id> | <file_id1>-<file_id2>

3. | <generic_path> | (<object_list>) | partial | non_db

4. redirection with '=' is not supported here - use option '-m' instead

5. default: all

restore_mode = all

1. backup type [offline | offline_force | offline_standby | offline_split

2. | offline_mirror | offline_stop | online | online_cons | online_split

3. | online_mirror

4. default: offline

backup_type = offline

1. backup device type

2. [tape | tape_auto | tape_box | pipe | pipe_auto | pipe_box | disk

3. | disk_copy | disk_standby | stage | stage_copy | stage_standby

4. | util_file | util_file_online | rman_util | rman_disk | rman_stage

5. | rman_prep]

6. default: tape

backup_dev_type = disk

1. backup root directory [<path_name> | (<path_name_list>)]

2. default: $SAPDATA_HOME/sapbackup

backup_root_dir = /sapbkup

1. stage root directory [<path_name> | (<path_name_list>)]

2. default: value of the backup_root_dir parameter

stage_root_dir = /oracle/SAD/sapbackup

1. compression flag [no | yes | hardware | only]

2. default: no

compress = yes

1. compress command

2. first $-character is replaced by the source file name

3. second $-character is replaced by the target file name

4. <target_file_name> = <source_file_name>.Z

5. for compress command the -c option must be set

6. recommended setting for brbackup -k only run:

7. "compress -b 12 -c $ > $"

8. no default

compress_cmd = "compress -c $ > $"

1. uncompress command

2. first $-character is replaced by the source file name

3. second $-character is replaced by the target file name

4. <source_file_name> = <target_file_name>.Z

5. for uncompress command the -c option must be set

6. no default

uncompress_cmd = "uncompress -c $ > $"

1. directory for compression [<path_name> | (<path_name_list>)]

2. default: value of the backup_root_dir parameter

compress_dir = /oracle/SAD/sapreorg

1. brarchive function [save | second_copy | double_save | save_delete

2. | second_copy_delete | double_save_delete | copy_save

3. | copy_delete_save | delete_saved | delete_copied]

4. default: save

archive_function = save

1. directory for archive log copies to disk

2. default: first value of the backup_root_dir parameter

**********************************************************************************************************************************

do u have idea abut this?

thanks & regards

[former_member227600 · Accepted solution]

Hi,

Pplease check your /oracle/<SID>/sapbackup

this dir have name sapbkup or sapbackup

backup root directory (<path_name_list>)

default: $SAPDATA_HOME/sapbackup

backup_root_dir = /sapbkup

Change sapbkup to sapbackup in init<sid>.sap & try again to take backup.\

Karan

[Former Member · Accepted solution]

please look at detail logs.

*************************************************************************************************************************************

BR0051I BRBACKUP 7.00 (11)

BR0055I Start of database backup: bdymphcp.and 2008-08-02 11.18.23

BR0477I Oracle pfile /oracle/SAD/102_64/dbs/initSAD.ora created from spfile /oracle/SAD/102_64/dbs/spfileSAD.ora

BR0280I BRBACKUP time stamp: 2008-08-02 11.18.25

BR0319I Control file copy created: /oracle/SAD/sapbackup/cntrlSAD.dbf 9486336

BR0101I Parameters

Name Value

oracle_sid SAD

oracle_home /oracle/SAD/102_64

oracle_profile /oracle/SAD/102_64/dbs/initSAD.ora

sapdata_home /oracle/SAD

sap_profile /oracle/SAD/102_64/dbs/initSAD.disk.sap

backup_mode ALL

backup_type online

backup_dev_type disk

backup_root_dir /sapbkup

compress yes

compress_cmd compress -c $ > $

exec_parallel 0

system_info sadadm/orasad sapodev AIX 3 5 00CF1A4C4C00

oracle_info SAD 10.2.0.2.0 8192 772 61805039

sap_info 700 SAPSR3 SCP TEMPLICENSE R3_ORA INITIAL

make_info rs6000_64 OCI_101 Feb 28 2006

command_line brbackup -u / -jid ALL__20080802111822 -c force -t online -m all -p initSAD.disk.sap -v DISK

BR0116I ARCHIVE LOG LIST before backup for database instance SAD

Parameter Value

Database log mode Archive Mode

Automatic archival Enabled

Archive destination /oracle/SAD/oraarch/SADarch

Archive format %t_%s_%r.dbf

Oldest online log sequence 769

Next log sequence to archive 772

Current log sequence 772 SCN: 61805039

Database block size 8192 Thread: 1

BR0118I Tablespaces and data files

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

PSAPSR3 ONLINE* ONLINE+ /oracle/SAD/sapdata2/sr3_5/sr3.data5 2097160192 8 2555909 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ /oracle/SAD/sapdata2/sr3_6/sr3.data6 2097160192 9 2555909 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ /oracle/SAD/sapdata3/sr3_7/sr3.data7 2097160192 10 2555909 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ /oracle/SAD/sapdata3/sr3_8/sr3.data8 2097160192 11 2555909 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ /oracle/SAD/sapdata3/sr3_9/sr3.data9 1048584192 12 2555909 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ /oracle/SAD/sapdata1/sr3_2/sr3.data2 2097160192 5 2555909 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ /oracle/SAD/sapdata4/sr3_11/sr3.data11 2097160192 14 2555909 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ /oracle/SAD/sapdata1/sr3_3/sr3.data3 2097160192 6 2555909 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ /oracle/SAD/sapdata2/sr3_4/sr3.data4 2097160192 7 2555909 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ /oracle/SAD/sapdata1/sr3_1/sr3.data1 2097160192 4 2555909 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ /oracle/SAD/sapdata4/sr3_10/sr3.data10 2097160192 13 2555909 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ /oracle/SAD/sapdata1/sr3700_1/sr3700.data1 3732938752 15 2555909 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ /oracle/SAD/sapdata1/sr3700_2/sr3700.data2 3858767872 16 2555909 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ /oracle/SAD/sapdata2/sr3700_3/sr3700.data3 3816824832 17 2555909 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ /oracle/SAD/sapdata2/sr3700_4/sr3700.data4 2537562112 18 2555909 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ /oracle/SAD/sapdata3/sr3700_5/sr3700.data5 3649052672 19 2555909 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ /oracle/SAD/sapdata4/sr3700_6/sr3700.data6 3607109632 20 2555909 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ /oracle/SAD/sapdata4/sr3700_8/sr3700.data8 3607109632 25 2555909 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ /oracle/SAD/sapdata4/sr3700_7/sr3700.data7 3607109632 24 2555909 NOLINK FILE 10485760000 20971520 8192

PSAPSR3USR ONLINE* ONLINE+ /oracle/SAD/sapdata1/sr3usr_1/sr3usr.data1 20979712 21 2555909 NOLINK FILE 10485760000 20971520 8192

PSAPTEMP ONLINE# ONLINE+ /oracle/SAD/sapdata1/temp_1/temp.data1 1394614272 -1 2555909 NOLINK FILE 10485760000 20971520 8192

PSAPUNDO ONLINE- ONLINE+ /oracle/SAD/sapdata1/undo_1/undo.data1 9290391552 2 2555909 NOLINK FILE 10485760000 20971520 8192

SYSAUX ONLINE* ONLINE+ /oracle/SAD/sapdata1/sysaux_2/sysaux.data2 209723392 23 2555909 NOLINK FILE 10485760000 20971520 8192

SYSAUX ONLINE* ONLINE+ /oracle/SAD/sapdata1/sysaux_1/sysaux.data1 209723392 3 2555909 NOLINK FILE 10485760000 20971520 8192

SYSTEM ONLINE* SYSTEM+ /oracle/SAD/sapdata1/system_2/system.data2 503324672 22 2555909 NOLINK FILE 10485760000 20971520 8192

SYSTEM ONLINE* SYSTEM+ /oracle/SAD/sapdata1/system_1/system.data1 503324672 1 2555909 NOLINK FILE 10485760000 20971520 8192

BR0119I Redo log files

File Size Group Device Status Link Type

/oracle/SAD/origlogA/log_g11m1.dbf 52429312 1 2555909 INUSE NOLINK FILE

/oracle/SAD/mirrlogA/log_g11m2.dbf 52429312 1 2555909 INUSE NOLINK FILE

/oracle/SAD/origlogB/log_g12m1.dbf 52429312 2 2555909 INUSE NOLINK FILE

/oracle/SAD/mirrlogB/log_g12m2.dbf 52429312 2 2555909 INUSE NOLINK FILE

/oracle/SAD/origlogA/log_g13m1.dbf 52429312 3 2555909 INUSE NOLINK FILE

/oracle/SAD/mirrlogA/log_g13m2.dbf 52429312 3 2555909 INUSE NOLINK FILE

/oracle/SAD/origlogB/log_g14m1.dbf 52429312 4 2555909 INUSE NOLINK FILE

/oracle/SAD/mirrlogB/log_g14m2.dbf 52429312 4 2555909 INUSE NOLINK FILE

BR0120I Control files

File Size Id. Device Link Type

/oracle/SAD/origlogA/cntrl/cntrlSAD.dbf 9486336 0 2555909 NOLINK FILE

/oracle/SAD/origlogB/cntrl/cntrlSAD.dbf 9486336 0 2555909 NOLINK FILE

/oracle/SAD/sapdata1/cntrl/cntrlSAD.dbf 9486336 0 2555909 NOLINK FILE

BR0280I BRBACKUP time stamp: 2008-08-02 11.18.26

BR0057I Backup of database: SAD

BR0058I BRBACKUP action ID: bdymphcp

BR0059I BRBACKUP function ID: and

BR0110I Backup mode: ALL

BR0077I Database file for backup: /oracle/SAD/sapbackup/cntrlSAD.dbf

BR0061I 26 files found for backup, total size 58349.242 MB

BR0143I Backup type: online

BR0111I Files will be compressed

BR0130I Backup device type: disk

BR0106I Files will be saved on disk in directory: /sapbkup/bdymphcp

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

BR0370I Directory /sapbkup/bdymphcp created

BR0202I Saving init_ora

BR0203I to /sapbkup/SAD ...

BR0202I Saving /oracle/SAD/102_64/dbs/initSAD.disk.sap

BR0203I to /sapbkup/SAD ...

BR0280I BRBACKUP time stamp: 2008-08-02 11.18.26

BR0198I Profiles saved successfully

BR0280I BRBACKUP time stamp: 2008-08-02 11.18.40

BR0315I 'Alter tablespace PSAPSR3 begin backup' successful

BR0201I Compressing /oracle/SAD/sapdata2/sr3_5/sr3.data5

BR0203I to /sapbkup/bdymphcp/sr3.data5.Z ...

BR0278E Command output of 'LANG=C compress -c /oracle/SAD/sapdata2/sr3_5/sr3.data5 > /sapbkup/bdymphcp/sr3.data5.Z':

/oracle/SAD/sapdata2/sr3_5/sr3.data5: Invalid argument

BR0280I BRBACKUP time stamp: 2008-08-02 11.18.40

BR0279E Return code from 'LANG=C compress -c /oracle/SAD/sapdata2/sr3_5/sr3.data5 > /sapbkup/bdymphcp/sr3.data5.Z': 1

BR0224E Compressing /oracle/SAD/sapdata2/sr3_5/sr3.data5 to /sapbkup/bdymphcp/sr3.data5.Z failed due to previous errors

BR0056I End of database backup: bdymphcp.and 2008-08-02 11.18.40

BR0280I BRBACKUP time stamp: 2008-08-02 11.18.42

BR0054I BRBACKUP terminated with errors

****************************************************************************************************************************

thanks & regards

sachin

[former_member227600 · Accepted solution]

Hi ,

Go to /oracle/<SID>

And run command ls -ltr

And paste result here

Karan

[Former Member · Accepted solution]

hi Karan

-

---

-rwxr----- 1 orasad dba 254 Sep 02 2006 .profile.1

-rw-r----- 1 orasad dba 7693 Sep 02 2006 .sapenv.sh

-rw-r----- 1 orasad dba 1118 Sep 02 2006 .sapsrc_sapodev.sh

-rw-r----- 1 orasad dba 1322 Sep 02 2006 .sapsrc_sapodev.csh

-rw-r----- 1 orasad dba 1118 Sep 02 2006 .sapsrc.sh

-rw-r----- 1 orasad dba 1322 Sep 02 2006 .sapsrc.csh

-rw-r----- 1 orasad dba 8325 Sep 02 2006 .sapenv.csh

-rwxr----- 1 orasad dba 1372 Sep 02 2006 .profile.2

-rw-r----- 1 orasad dba 1322 Sep 02 2006 .login.1

-rw-r----- 1 orasad dba 1322 Sep 02 2006 .cshrc.1

-rw-r----- 1 orasad dba 4790 Sep 02 2006 .dbenv_sapodev.sh

-rw-r----- 1 orasad dba 4790 Sep 02 2006 .dbenv.sh

-rwxr----- 1 orasad staff 1717 Sep 02 2006 .profile

-rw-r----- 1 orasad dba 1575 Sep 02 2006 .login

-rw-r----- 1 orasad dba 4823 Sep 02 2006 .dbenv_sapodev.csh

-rw-r----- 1 orasad dba 4823 Sep 02 2006 .dbenv.csh

-rw-r----- 1 orasad dba 1575 Sep 02 2006 .cshrc

-rwxr-xr-x 1 orasad dba 11119 Sep 02 2006 stopdb

-rwxr-xr-x 1 orasad dba 15752 Sep 02 2006 startdb

drwxr-xr-x 4 orasad dba 256 Sep 04 2006 saptrace

drwxr-xr-x 3 orasad dba 256 Sep 04 2006 origlogA

drwxr-xr-x 2 orasad dba 256 Sep 04 2006 mirrlogA

drwxr-xr-x 3 orasad dba 256 Sep 04 2006 origlogB

drwxr-xr-x 2 orasad dba 256 Sep 04 2006 mirrlogB

-rw-rw---- 1 orasad sapsys 895 Jan 02 2007 LASVerify.pse

-rw-rr 1 orasad dba 83 Jan 27 2007 startsap_.log

drwxr-xr-x 2 orasad dba 256 Jun 05 2007 saparch

-rw-rr 1 orasad dba 166 Sep 30 2007 stopsap_.log

drwxr-xr-x 3 orasad dba 4096 Jan 30 2008 sapreorg

drwxr-xr-x 60 orasad dba 4096 May 02 16:13 102_64

drwxrwxr-x 6 orasad dba 4096 May 02 16:30 oraInventory

-rw-rr 1 orasad dba 464515 May 02 18:32 patch.log

-rw-r----- 1 orasad dba 8359 May 03 09:05 .sapenv_sapodev.csh

-rw-r----- 1 orasad dba 7727 May 03 09:06 .sapenv_sapodev.sh

drwxr-xr-x 7 orasad dba 256 May 03 16:01 sapdata4

drwxr-xr-x 6 orasad dba 256 May 03 16:01 sapdata3

drwxr-xr-x 7 orasad dba 256 May 03 16:01 sapdata2

drwxr-xr-x 15 orasad dba 4096 May 03 20:43 sapdata1

-rw-rr 1 orasad dba 8506 Jun 16 13:08 trans.log

-rw------- 1 orasad dba 11328 Jul 22 19:13 .sh_history

drwxrwxrwx 2 orasad dba 53248 Aug 02 11:44 sapcheck

drwxr-xr-x 2 orasad dba 102400 Aug 02 12:35 oraarch

drwxr-xr-x 3 orasad dba 16384 Aug 02 12:41 sapbackup

......................................................................................................

thanks

sachin

[former_member227600 · Accepted solution]

Hi,

drwxr-xr-x 3 orasad dba 16384 Aug 02 12:41 sapbackup

You can see clearly your sapbackup directory name is sapbackup not sapbkup .

backup root directory (<path_name_list>)

default: $SAPDATA_HOME/sapbackup

backup_root_dir = /sapbkup

This is your init<sid>.sap file & you can see clearly backup

rootdir have the wrong name sapbkup.

Please rename your backup dir from sapbkup to sapbackup in init<SID>.sap

After start backup & let

Karan

[Former Member · Accepted solution]

hhi

Karan thanks.

see /sapbkup is the mount point for save backup.

it same way working fine.

basicaly system is not able compress,

/oracle/SAD/sapdata2/sr3_5/sr3.data5: Invalid argument.

_____________________________________________________

thanks & regards

sachin