0005 error during processing

[Former Member]

Hi,

When iam taking offline backup iam getting error :

Returncode : 0005 error during processing .OS is AIX and DB is oracle.can any one guide me for to solve this error.

Thanku

[Former Member · Accepted solution]

Kumar,

Paste the Error Log.

Thanks & Regards

Babu

[Former Member · Accepted solution]

Hi,

Here iam sending the log details.

-

---

Detail log: bdzjsofn.fft

-

---

BR0051I BRBACKUP 6.40 (15)

BR0128I Option 'use_dbv' ignored for 'compress/-k yes'

BR0055I Start of database backup: bdzjsofn.fft 2008-12-02 17.21.27

BR0477I Oracle pfile /oracle/smn/920_64/dbs/initsmn.ora created from spfile /oracle/smn/920_64/dbs/spfilesmn.ora

BR0101I Parameters

Name Value

oracle_sid smn

oracle_home /oracle/smn/920_64

oracle_profile /oracle/smn/920_64/dbs/initsmn.ora

sapdata_home /oracle/smn

sap_profile /oracle/smn/920_64/dbs/initsmn.sap

backup_mode FULL

backup_type offline_force

backup_smn_type tape

compress yes

compress_cmd compress -c $ > $

uncompress_cmd uncompress -c $ > $

compress_dir /oracle/smn/sapreorg

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 tctl -f $ rewind

rewind_offline tctl -f $ offline

tape_pos_cmd tctl -f $ fsf $

tape_size 204800.000 MB

tape_address /smn/rmt0.1

tape_address_rew /smn/rmt0

volume_backup SCRATCH

expir_period 0

tape_use_count 100

exec_parallel 0

system_info smnadm/orasmn smnelopment AIX 3 5 00C00E4B4C00

oracle_info smn 9.2.0.7.0 8192 10266 82794934

sap_info 640 SAPsmn smn O1110238104 R3_ORA 0020223594

make_info rs6000_64 OCI_920 Oct 4 2004

command_line brbackup -u / -c force -t offline_force -m full -p initsmn.sap -w use_dbv -v SCRATCH -a -c force -p initsmn.sap -cds -w

BR0116I ARCHIVE LOG LIST before backup for database instance smn

Parameter Value

Database log mode Archive Mode

Automatic archival Enabled

Archive destination /oracle/smn/oraarch/smnarch

Archive format %t_%s.dbf

Oldest online log sequence 10263

Next log sequence to archive 10266

Current log sequence 10266 SCN: 82794934

Database block size 8192 Thread: 1

BR0118I Tablespaces and data files

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

PSAPsmn ONLINE* ONLINE+ /oracle/smn/sapdata3/smn_1/smn.data1 2579505152 3 2949125 NOLINK FILE 10485760000 20971520

PSAPsmn ONLINE* ONLINE+ /oracle/smn/sapdata3/smn_2/smn.data2 2579505152 4 2949125 NOLINK FILE 10485760000 20971520

PSAPsmn ONLINE* ONLINE+ /oracle/smn/sapdata3/smn_3/smn.data3 2558533632 5 2949125 NOLINK FILE 10485760000 20971520

PSAPsmn ONLINE* ONLINE+ /oracle/smn/sapdata3/smn_4/smn.data4 2453676032 6 2949125 NOLINK FILE 10485760000 20971520

PSAPsmn ONLINE* ONLINE+ /oracle/smn/sapdata4/smn_6/smn.data6 2453676032 8 2949126 NOLINK FILE 10485760000 20971520

PSAPsmn ONLINE* ONLINE+ /oracle/smn/sapdata4/smn_8/smn.data8 2495619072 10 2949126 NOLINK FILE 10485760000 20971520

PSAPsmn ONLINE* ONLINE+ /oracle/smn/sapdata4/smn_10/smn.data10 2495619072 12 2949126 NOLINK FILE 10485760000 20971520

PSAPsmn ONLINE* ONLINE+ /oracle/smn/sapdata4/smn_9/smn.data9 2537562112 11 2949126 NOLINK FILE 10485760000 20971520

PSAPsmn ONLINE* ONLINE+ /oracle/smn/sapdata4/smn_7/smn.data7 2432704512 9 2949126 NOLINK FILE 10485760000 20971520

PSAPsmn ONLINE* ONLINE+ /oracle/smn/sapdata4/smn_19/smn.data19 2306875392 52 2949126 NOLINK FILE 10485760000 20971520

PSAPsmn ONLINE* ONLINE+ /oracle/smn/sapdata4/smn_18/smn.data18 2243960832 50 2949126 NOLINK FILE 10485760000 20971520

PSAPsmn ONLINE* ONLINE+ /oracle/smn/sapdata4/smn_17/smn.data17 2222989312 49 2949126 NOLINK FILE 10485760000 20971520

PSAPsmn ONLINE* ONLINE+ /oracle/smn/sapdata4/smn_16/smn.data16 2222989312 48 2949126 NOLINK FILE 10485760000 20971520

PSAPsmn ONLINE* ONLINE+ /oracle/smn/sapdata4/smn_15/smn.data15 2243960832 37 2949126 NOLINK FILE 10485760000 20971520

PSAPsmn ONLINE* ONLINE+ /oracle/smn/sapdata4/smn_14/smn.data14 2202017792 36 2949126 NOLINK FILE 10485760000 20971520

PSAPsmn ONLINE* ONLINE+ /oracle/smn/sapdata4/smn_13/smn.data13 2285903872 29 2949126 NOLINK FILE 10485760000 20971520

PSAPsmn ONLINE* ONLINE+ /oracle/smn/sapdata4/smn_12/smn.data12 2348818432 28 2949126 NOLINK FILE 10485760000 20971520

PSAPsmn ONLINE* ONLINE+ /oracle/smn/sapdata4/smn_11/smn.data11 2369789952 27 2949126 NOLINK FILE 10485760000 20971520

PSAPsmn ONLINE* ONLINE+ /oracle/smn/sapdata4/smn_30/smn.data30 5117059072 63 2949126 NOLINK FILE 10485760000 20971520

PSAPsmn ONLINE* ONLINE+ /oracle/smn/sapdata4/smn_29/smn.data29 5117059072 62 2949126 NOLINK FILE 10485760000 20971520

PSAPsmn ONLINE* ONLINE+ /oracle/smn/sapdata4/smn_28/smn.data28 2558533632 61 2949126 NOLINK FILE 10485760000 20971520

PSAPsmn ONLINE* ONLINE+ /oracle/smn/sapdata4/smn_27/smn.data27 2558533632 60 2949126 NOLINK FILE 10485760000 20971520

PSAPsmn ONLINE* ONLINE+ /oracle/smn/sapdata4/smn_26/smn.data26 2558533632 59 2949126 NOLINK FILE 10485760000 20971520

PSAPsmn ONLINE* ONLINE+ /oracle/smn/sapdata4/smn_25/smn.data25 2621448192 58 2949126 NOLINK FILE 10485760000 20971520

PSAPsmn ONLINE* ONLINE+ /oracle/smn/sapdata4/smn_24/smn.data24 2642419712 57 2949126 NOLINK FILE 10485760000 20971520

PSAPsmn ONLINE* ONLINE+ /oracle/smn/sapdata4/smn_23/smn.data23 2621448192 56 2949126 NOLINK FILE 10485760000 20971520

PSAPsmn ONLINE* ONLINE+ /oracle/smn/sapdata4/smn_22/smn.data22 2642419712 55 2949126 NOLINK FILE 10485760000 20971520

PSAPsmn ONLINE* ONLINE+ /oracle/smn/sapdata4/smn_21/smn.data21 2642419712 54 2949126 NOLINK FILE 10485760000 20971520

PSAPsmn ONLINE* ONLINE+ /oracle/smn/sapdata4/smn_20/smn.data20 2516590592 53 2949126 NOLINK FILE 10485760000 20971520

PSAPsmn ONLINE* ONLINE+ /oracle/smn/sapdata3/smn_5/smn.data5 2453676032 7 2949125 NOLINK FILE 10485760000 20971520

PSAPsmn640 ONLINE* ONLINE+ /oracle/smn/sapdata1/smn640_1/smn640.data1 2097160192 13 2949123 NOLINK FILE 10485760000 20971520

PSAPsmn640 ONLINE* ONLINE+ /oracle/smn/sapdata1/smn640_2/smn640.data2 2097160192 14 2949123 NOLINK FILE 10485760000 20971520

PSAPsmn640 ONLINE* ONLINE+ /oracle/smn/sapdata1/smn640_4/smn640.data4 2097160192 16 2949123 NOLINK FILE 10485760000 20971520

PSAPsmn640 ONLINE* ONLINE+ /oracle/smn/sapdata2/smn640_6/smn640.data6 2097160192 18 2949124 NOLINK FILE 10485760000 20971520

PSAPsmn640 ONLINE* ONLINE+ /oracle/smn/sapdata2/smn640_8/smn640.data8 2097160192 20 2949124 NOLINK FILE 10485760000 20971520

PSAPsmn640 ONLINE* ONLINE+ /oracle/smn/sapdata2/smn640_10/smn640.data10 2097160192 22 2949124 NOLINK FILE 10485760000 20971520

PSAPsmn640 ONLINE* ONLINE+ /oracle/smn/sapdata4/smn640_12/smn640.data12 2097160192 24 2949126 NOLINK FILE 10485760000 20971520

PSAPsmn640 ONLINE* ONLINE+ /oracle/smn/sapdata4/smn640_25/smn640.data25 2097160192 46 2949126 NOLINK FILE 10485760000 20971520

PSAPsmn640 ONLINE* ONLINE+ /oracle/smn/sapdata4/smn640_24/smn640.data24 2097160192 45 2949126 NOLINK FILE 10485760000 20971520

PSAPsmn640 ONLINE* ONLINE+ /oracle/smn/sapdata4/smn640_23/smn640.data23 2097160192 44 2949126 NOLINK FILE 10485760000 20971520

PSAPsmn640 ONLINE* ONLINE+ /oracle/smn/sapdata4/smn640_22/smn640.data22 2097160192 43 2949126 NOLINK FILE 10485760000 20971520

PSAPsmn640 ONLINE* ONLINE+ /oracle/smn/sapdata4/smn640_21/smn640.data21 2097160192 42 2949126 NOLINK FILE 10485760000 20971520

PSAPsmn640 ONLINE* ONLINE+ /oracle/smn/sapdata4/smn640_20/smn640.data20 2097160192 41 2949126 NOLINK FILE 10485760000 20971520

PSAPsmn640 ONLINE* ONLINE+ /oracle/smn/sapdata4/smn640_19/smn640.data19 2097160192 40 2949126 NOLINK FILE 10485760000 20971520

PSAPsmn640 ONLINE* ONLINE+ /oracle/smn/sapdata4/smn640_18/smn640.data18 2097160192 39 2949126 NOLINK FILE 10485760000 20971520

PSAPsmn640 ONLINE* ONLINE+ /oracle/smn/sapdata4/smn640_17/smn640.data17 2097160192 38 2949126 NOLINK FILE 10485760000 20971520

PSAPsmn640 ONLINE* ONLINE+ /oracle/smn/sapdata4/smn640_26/smn640.data26 2097160192 47 2949126 NOLINK FILE 10485760000 20971520

PSAPsmn640 ONLINE* ONLINE+ /oracle/smn/sapdata4/smn640_16/smn640.data16 2097160192 32 2949126 NOLINK FILE 10485760000 20971520

PSAPsmn640 ONLINE* ONLINE+ /oracle/smn/sapdata4/smn640_15/smn640.data15 2097160192 31 2949126 NOLINK FILE 10485760000 20971520

PSAPsmn640 ONLINE* ONLINE+ /oracle/smn/sapdata4/smn640_14/smn640.data14 2097160192 30 2949126 NOLINK FILE 10485760000 20971520

PSAPsmn640 ONLINE* ONLINE+ /oracle/smn/sapdata4/smn640_13/smn640.data13 2097160192 25 2949126 NOLINK FILE 10485760000 20971520

PSAPsmn640 ONLINE* ONLINE+ /oracle/smn/sapdata3/smn640_11/smn640.data11 2097160192 23 2949125 NOLINK FILE 10485760000 20971520

PSAPsmn640 ONLINE* ONLINE+ /oracle/smn/sapdata2/smn640_9/smn640.data9 2097160192 21 2949124 NOLINK FILE 10485760000 20971520

PSAPsmn640 ONLINE* ONLINE+ /oracle/smn/sapdata2/smn640_7/smn640.data7 2097160192 19 2949124 NOLINK FILE 10485760000 20971520

PSAPsmn640 ONLINE* ONLINE+ /oracle/smn/sapdata1/smn640_5/smn640.data5 2097160192 17 2949123 NOLINK FILE 10485760000 20971520

PSAPsmn640 ONLINE* ONLINE+ /oracle/smn/sapdata1/smn640_3/smn640.data3 2097160192 15 2949123 NOLINK FILE 10485760000 20971520

PSAPsmnUSR ONLINE* ONLINE+ /oracle/smn/sapdata4/smnusr_1/smnusr.data1 20979712 26 2949126 NOLINK FILE 10485760000 20971520

PSAPTEMP ONLINE# ONLINE+ /oracle/smn/sapdata1/temp_1/temp.data1 702554112 -1 2949123 NOLINK FILE 10485760000 20971520

PSAPUNDO ONLINE- ONLINE+ /oracle/smn/sapdata1/undo_1/undo.data1 10485768192 2 2949123 NOLINK FILE 10485760000 20971520

PSAPUNDO ONLINE- ONLINE /oracle/smn/sapdata1/undo_2/undo.data2 2097160192 51 2949123 NOLINK FILE 0 0

SYSTEM ONLINE* SYSTEM+ /oracle/smn/sapdata1/system_1/system.data1 576724992 1 2949123 NOLINK FILE 10485760000 20971520

SYSTEM ONLINE* SYSTEM+ /oracle/smn/sapdata1/system_2/system.data2 576724992 33 2949123 NOLINK FILE 10485760000 20971520

SYSTEM ONLINE* SYSTEM+ /oracle/smn/sapdata1/system_3/system.data3 576724992 34 2949123 NOLINK FILE 10485760000 20971520

SYSTEM ONLINE* SYSTEM+ /oracle/smn/sapdata1/system_4/system.data4 576724992 35 2949123 NOLINK FILE 10485760000 20971520

BR0119I Redo log files

File Size Group smnice Status Link Type

/oracle/smn/origlogA/log_g11m1.dbf 52429312 1 3473413 INUSE NOLINK FILE

/oracle/smn/mirrlogA/log_g11m2.dbf 52429312 1 3473415 INUSE NOLINK FILE

/oracle/smn/origlogB/log_g12m1.dbf 52429312 2 3473414 INUSE NOLINK FILE

/oracle/smn/mirrlogB/log_g12m2.dbf 52429312 2 3473416 INUSE NOLINK FILE

/oracle/smn/origlogA/log_g13m1.dbf 52429312 3 3473413 INUSE NOLINK FILE

/oracle/smn/mirrlogA/log_g13m2.dbf 52429312 3 3473415 INUSE NOLINK FILE

/oracle/smn/origlogB/log_g14m1.dbf 52429312 4 3473414 INUSE NOLINK FILE

/oracle/smn/mirrlogB/log_g14m2.dbf 52429312 4 3473416 INUSE NOLINK FILE

BR0120I Control files

File Size Id. smnice Link Type

/oracle/smn/origlogA/cntrl/cntrlsmn.dbf 5054464 0 3473413 NOLINK FILE

/oracle/smn/sapdata1/system_1/cntrl/cntrlsmn.dbf 5054464 0 2949123 NOLINK FILE

/oracle/smn/saparch/cntrl/cntrlsmn.dbf 5054464 0 3473411 NOLINK FILE

BR0280I BRBACKUP time stamp: 2008-12-02 17.21.33

BR0057I Backup of database: smn

BR0058I BRBACKUP action ID: bdzjsofn

BR0059I BRBACKUP function ID: fft

BR0110I Backup mode: FULL

BR0077I Database files for backup:

/oracle/smn/origlogA/log_g11m1.dbf

/oracle/smn/origlogB/log_g12m1.dbf

/oracle/smn/origlogA/log_g13m1.dbf

/oracle/smn/origlogB/log_g14m1.dbf

/oracle/smn/origlogA/cntrl/cntrlsmn.dbf

BR0061I 69 files found for backup, total size 142515.322 MB

BR0143I Backup type: offline_force

BR0111I Files will be compressed

BR0130I Backup smnice type: tape

BR0102I Following backup smnice will be used: /smn/rmt0.1

BR0104I 1 scratch volume will be used

BR0136I Verify option set - double the work to do

BR0289I BRARCHIVE will be started at the end of processing

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

BR0237I Scratch volume required in smnice /smn/rmt0.1

BR0280I BRBACKUP time stamp: 2008-12-02 17.21.34

BR0226I Rewinding tape volume in smnice /smn/rmt0 ...

BR0351I Restoring /oracle/smn/sapbackup/.tape.hdr0

BR0355I from /smn/rmt0.1 ...

BR0241I Checking label on volume in smnice /smn/rmt0.1

BR0280I BRBACKUP time stamp: 2008-12-02 17.21.34

BR0226I Rewinding tape volume in smnice /smn/rmt0 ...

BR0202I Saving /oracle/smn/sapbackup/.tape.hdr0

BR0203I to /smn/rmt0.1 ...

BR0209I Volume in smnice /smn/rmt0.1 has name SCRATCH

BR0202I Saving init_ora

BR0203I to /smn/rmt0.1 ...

BR0202I Saving /oracle/smn/920_64/dbs/initsmn.sap

BR0203I to /smn/rmt0.1 ...

BR0280I BRBACKUP time stamp: 2008-12-02 17.21.40

BR0198I Profiles saved successfully

BR0280I BRBACKUP time stamp: 2008-12-02 17.21.40

BR0307I Shutting down database instance smn ...

BR0280I BRBACKUP time stamp: 2008-12-02 17.23.59

BR0308I Shutdown of database instance smn successful

BR0201I Compressing /oracle/smn/sapdata3/smn_1/smn.data1

BR0203I to /oracle/smn/sapreorg/smn.data1.Z ...

BR0202I Saving /oracle/smn/sapreorg/smn.data1.Z

BR0203I to /smn/rmt0.1 ...

*BR0278E Command output of 'LANG=C dd obs=64k bs=64k if=/oracle/smn/sapreorg/smn.data1.Z of=/smn/rmt0.1'😘

dd: write error: Invalid argument

6224+1 records in

6224+1 records out

BR0280I BRBACKUP time stamp: 2008-12-02 17.28.13

*BR0279E Return code from 'LANG=C dd obs=64k bs=64k if=/oracle/smn/sapreorg/smn.data1.Z of=/smn/rmt0.1': 2*

*BR0222E Copying /oracle/smn/sapreorg/smn.data1.Z to/from /smn/rmt0.1 failed due to previous errors*

BR0280I BRBACKUP time stamp: 2008-12-02 17.28.15

BR0304I Starting and opening database instance smn ...

BR0280I BRBACKUP time stamp: 2008-12-02 17.28.33

BR0305I Start and open of database instance smn successful

BR0056I End of database backup: bdzjsofn.fft 2008-12-02 17.28.13

BR0280I BRBACKUP time stamp: 2008-12-02 17.28.34

BR0054I BRBACKUP terminated with errors

guide me for same.

Thanku

[former_member204746 · Accepted solution]

you ahve not defined your backup devide properly.

you have set it to: /smn/rmt0.1

it should be more like /dev/rmt0.1

[Former Member]

Hi,

I am taking offline backup iam getting error :

Returncode : 0005 error during processing .OS is AIX and DB is oracle.can any one guide me for to solve this error.

BR0280I BRBACKUP time stamp: 2010-11-06 02.15.42

BR0063I 32 of 33 files processed - 79001.775 MB of 79006.924 MB done

BR0204I Percentage done: 99.99%, estimated end time: 2:15

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

BR0202I Saving /oracle/PRD/origlogA/cntrl/cntrlPRD.dbf

BR0203I to /dev/rmt0.1 ...

#FILE..... /oracle/PRD/origlogA/cntrl/cntrlPRD.dbf

#SAVED.... cntrlPRD.dbf PRDB05/36

BR0280I BRBACKUP time stamp: 2010-11-06 02.15.45

BR0063I 33 of 33 files processed - 79006.924 MB of 79006.924 MB done

BR0204I Percentage done: 100.00%, estimated end time: 2:15

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

BR0280I BRBACKUP time stamp: 2010-11-06 02.15.47

BR0304I Starting and opening database instance PRD ...

BR0280I BRBACKUP time stamp: 2010-11-06 02.16.34

BR0305I Start and open of database instance PRD successful

BR0117I ARCHIVE LOG LIST after backup for database instance PRD

Parameter Value

Database log mode Archive Mode

Automatic archival Enabled

Archive destination /oracle/PRD/oraarch/PRDarch

Archive format %t_%s.dbf

Oldest online log sequence 9812

Next log sequence to archive 9815

Current log sequence 9815 SCN: 156140548

Database block size 8192 Thread: 1

BR0056I End of database backup: beemrney.afp 2010-11-06 02.16.34

BR0280I BRBACKUP time stamp: 2010-11-06 02.16.36

BR0052I BRBACKUP completed successfully

BR0280I BRBACKUP time stamp: 2010-11-06 02.16.36

BR0291I BRARCHIVE (action ID aeemrney) will be started with options '+beemrney.afp,19628058347,PRDB05,33:286938 -d pipe -c force -p initPR

BR0280I BRBACKUP time stamp: 2010-11-06 02.35.03

BR0292I Execution of BRARCHIVE (action ID aeemrney) finished with return code 5

thank you

[Former Member]

Hi,

The backup is successfully terminated, but the backup of the redologs failed. Could you please paste the log of the BRARCHIVE?

You can find this log in /oracle/PRD/saparch

Best regards,

Son