Archive log could not be backed up after OS/DB upgrade

[Former Member]

Hi everyone.

upgrade:

OS: aix4.3-----> 5.3

DB: oracle 817------->9207

After the upgrade, when i backup database and arch logs in one run using db13,the backup of database is successful. But arch logs are not backed up.

logs are as follows:

BR002I BRARCHIVE 6.20 (136)

BR006I Start of offline redo log processing: aduthyem.cds 2007-03-07 03.35.36

BR101I Parameters

Name Value

oracle_sid PRD

oracle_home /oracle/PRD/920_64

oracle_profile /oracle/PRD/920_64/dbs/initPRD.ora

sapdata_home /oracle/PRD

sap_profile /oracle/PRD/920_64/dbs/initPRD.sap

backup_dev_type tape

compress hardware

tape_copy_cmd dd

cpio_flags -ovB

cpio_in_flags -iuvB

dd_flags obs=256k bs=256k

dd_in_flags ibs=256k bs=256k

rewind tctl -f $ rewind

rewind_offline tctl -f $ offline

<b>tape_size -84800.777 MB</b>

tape_address /dev/rmt1.1

tape_address_rew /dev/rmt1

volume_archive PRDB06

expir_period 0

tape_use_count 100

system_info prdadm/oraprd AIX 3 5 0001577A4C00

oracle_info PRD 9.2.0.7.0 8192 72200 544995618

sap_info 46C SAPR3 PRD Q1264368771 R3_ORA 0020111498

make_info rs6000_64 OCI_920 Aug 23 2005

command_line /usr/sap/PRD/SYS/exe/run/brarchive +bduthyem.ant,107794427603,PRDB06,342 -d tape -c force -cds -p initPRD.sap

<b>BR019W Volume size or disk capacity reached - not all offline redo log files will be saved

BR019W Volume size or disk capacity reached - not all offline redo log files will be saved

BR013W No offline redo log files found for processing</b>

In the log, tape_size is negative, it seems so strange

Thanks in advance

Allen

[Former Member]

Can you check the value of tape_size in the initPRD.sap?

[Former Member]

Thanks Fidel for your reply.

the value of tape_size is 200G in the initPRD.sap .

following is the log of database backup:

BR051I BRBACKUP 6.20 (136)

BR055I Start of database backup: bduthyem.ant 2007-03-06 23.59.24

BR319I Control file copy created: /oracle/PRD/sapbackup/cntrlPRD.dbf 17883136

BR101I Parameters

Name Value

oracle_sid PRD

oracle_home /oracle/PRD/920_64

oracle_profile /oracle/PRD/920_64/dbs/initPRD.ora

sapdata_home /oracle/PRD

sap_profile /oracle/PRD/920_64/dbs/initPRD.sap

backup_mode ALL

backup_type online

backup_dev_type tape

compress hardware

tape_copy_cmd dd

cpio_flags -ovB

cpio_in_flags -iuvB

dd_flags obs=256k bs=256k

dd_in_flags ibs=256k bs=256k

rewind tctl -f $ rewind

rewind_offline tctl -f $ offline

<b>tape_size 204800.000 MB</b>

tape_address /dev/rmt1.1

tape_address_rew /dev/rmt1

volume_backup PRDB01,PRDB02,PRDB03,PRDB04,PRDB05,PRDB06,PRDB07,PRDB08,PRDB09,PRDB10,

PRDB11,PRDB12,PRDB13,PRDB14,PRDB15,PRDB16,PRDB17,PRDB18

expir_period 0

tape_use_count 100

exec_parallel 15

system_info prdadm/oraprd AIX 3 5 0001577A4C00

oracle_info PRD 9.2.0.7.0 8192 72150 544902435

sap_info 46C SAPR3 PRD Q1264368771 R3_ORA 0020111498

make_info rs6000_64 OCI_920 Aug 23 2005

command_line brbackup -u / -c force -t online -m all -p initPRD.sap -a -c force -cds -p initPRD.sap

BR116I ARCHIVE LOG LIST before backup for database instance PRD

Parameter Value

Database log mode Archive Mode

Automatic archival Enabled

Archive destination /oracle/PRD/saparch/PRDarch

Archive format %t_%s.dbf

Oldest online log sequence 72143

Next log sequence to archive 72150

Current log sequence 72150 SCN: 544902435

Database block size 8192 Thread: 1

Oracle version 9.2.0.7.0

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

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

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

BR056I End of database backup: bduthyem.ant 2007-03-07 03.35.34

BR280I Time stamp 2007-03-07 03.35.36

BR052I BRBACKUP terminated successfully

BR280I Time stamp 2007-03-07 03.35.36

BR291I BRARCHIVE (aduthyem) will be started with options '+bduthyem.ant,107794427603,PRDB06,342 -d tape -c force -cds -p initPRD.sap'

BR280I Time stamp 2007-03-07 03.37.16

BR292I Execution of BRARCHIVE (aduthyem) terminated with return code 1

<b>BTW, arch logs can be backed up successfully when be defined as a individual job</b>

Best regards,

Allen

[former_member204746]

when you upgraded Oracle, you also created a new ORACLE_HOME.

so, make sure that environment variable ORACLE_HOME points to /oracle/PRD/902_64

also make sure that initPRD.sap in this location has a good value.

if all fails, supply initPRD.sap.

[Former Member]

from the second log the last line is

BR292I Execution of BRARCHIVE (aduthyem) terminated with return code 1

this tells us that at least one warning occured (line starts with BR<code>W where code is a three digit integer with 6.20 brbackup, 4digit with => 6.40)

However I see no such warning from the log part provided, please re-check the log again for them