While taking backup of Archive and datbase.

[Former Member]

Dear All

I have production server 4.6c on windows 2000 server. Database is oracle.

My problem is backup (Brarchive Redolog and Database Backup).

I am unable to take both type of backup. Error log is bellow.

Please help me out.

BR002I BRARCHIVE 6.20 (135)

BR006I Start of offline redo log processing: aeaohozy.cds 2009-05-13 11.22.18

BR101I Parameters

Name Value

oracle_sid P01

oracle_home C:\ORACLE\P01\920

oracle_profile C:\ORACLE\P01\920\DATABASE\initP01.ora

sapdata_home D:\oracle\P01

sap_profile C:\ORACLE\P01\920\DATABASE\initP01.sap

backup_dev_type tape

compress hardware

tape_copy_cmd dd

cpio_flags -ovB

cpio_in_flags -iuvB

dd_flags bs=32k

dd_in_flags bs=32k

rewind mt -f $ rewind

rewind_offline mt -f $ offline

tape_size 70000.000 MB

tape_address /dev/nmt0

tape_address_rew /dev/mt0

volume_archive P01A23

expir_period 20

tape_use_count 100

system_info P01adm SAPPR1 Windows NT 5.0 Build 2195 Service Pack 4 Intel

oracle_info P01 9.2.0.6.0 8192 3 242759136

sap_info 46C SAPR3 P01 V1630189933 R3_ORA 0020099301

make_info NTintel OCI_920_SHARE Apr 4 2005

command_line C:\USR\SAP\P01\SYS\EXE\RUN\brarchive.exe -cds -p initP01.sap -c -l E -d tape -v P01A23 -k hardware -U

BR280I Time stamp 2009-05-13 11.22.43

BR008I Offline redo log processing for database instance: P01

BR009I BRARCHIVE action ID: aeaohozy

BR010I BRARCHIVE function ID: cds

BR048I Archive function: copy_delete_save

BR011I 2 offline redo log files found for processing, total size 59.999 MB

BR113I Files will be compressed by hardware

BR130I Backup device type: tape

BR102I Following backup device will be used: /dev/nmt0

BR103I Following backup volume will be used: P01A23

BR126I Unattended mode active - no operator confirmation required

BR208I Volume with name P01A23 required in device /dev/nmt0

BR280I Time stamp 2009-05-13 11.22.43

BR226I Rewinding tape volume in device /dev/mt0 ...

BR351I Restoring E:\ORACLE\P01\SAPREORG\.tape.hdr0

BR355I from /dev/nmt0 ...

BR241I Checking label on volume in device /dev/nmt0

BR280I Time stamp 2009-05-13 11.22.51

BR226I Rewinding tape volume in device /dev/mt0 ...

BR202I Saving E:\ORACLE\P01\SAPREORG\.tape.hdr0

BR203I to /dev/nmt0 ...

BR209I Volume in device /dev/nmt0 has name P01A23

BR202I Saving init_ora

BR203I to /dev/nmt0 ...

BR202I Saving C:\ORACLE\P01\920\DATABASE\initP01.sap

BR203I to /dev/nmt0 ...

BR280I Time stamp 2009-05-13 11.23.06

BR198I Profiles saved successfully

BR202I Saving D:\oracle\P01\saparch\P01archARC00001.001

BR203I to /dev/nmt0 ...

BR266E Program 'dd bs=32k conv=sync if=D:\oracle\P01\saparch\P01archARC00001.001 of=/dev/nmt0' interrupted, exit status: c0000005

BR272E Execution of program 'dd bs=32k conv=sync if=D:\oracle\P01\saparch\P01archARC00001.001 of=/dev/nmt0' through pipe failed

BR222E Copying D:\oracle\P01\saparch\P01archARC00001.001 to/from /dev/nmt0 failed due to previous errors

BR016I 0 offline redo log files processed, total size 0.000 MB

BR007I End of offline redo log processing: aeaohozy.cds 2009-05-13 11.23.09

BR280I Time stamp 2009-05-13 11.23.09

BR005I BRARCHIVE terminated with errors

Thanks

Hemant

[abhimanyu_pandey]

Hi..

I think error is in the dd program and named pipe used by it.

BR266E Program 'dd bs=32k conv=sync if=D:\oracle\P01\saparch\P01archARC00001.001 of=/dev/nmt0' interrupted, exit status: c0000005 BR272E Execution of program 'dd bs=32k conv=sync if=D:\oracle\P01\saparch\P01archARC00001.001 of=/dev/nmt0' through pipe failed BR222E Copying D:\oracle\P01\saparch\P01archARC00001.001 to/from /dev/nmt0 failed due to previous errors

Just try to save a test file to a scratch tape by using command

dd bs=32K conv=sync if=D:\<some_test_file>

see http://linux.about.com/od/commands/l/blcmdl1_dd.htm for more information.

if it get executed then again try to archive logs, Otherwise i would suggest to restart the server and try again.

Regards,

Abhimanyu

[Former Member]

Hi,

Are you any third party tool for your backup (e.g. TSM). If yes then can you try by regenerating.bki file? Also update the BR*tools patch level to latest one.

Thanks,

Sushil

[Former Member]

Hello,

at any case, make sure that you use the latest version of the MKS tools (attached to note #162975). Please also note that the brtools version that you are using is very old. Before proceeding, you should also apply brtools 7.0 / 7.10.

Best Regards,

Michael