cancel
Showing results for 
Search instead for 
Did you mean: 

DB13 -Archivelog backup error

sivakumar_kilari3
Active Contributor
0 Kudos

Hi All,

While taking Archivelog backup in takpes I am getting following errs.

Date Time Message

15.11.2008 11:48:00 Job started

15.11.2008 11:48:00 Step 001 started (program RSDBAJOB, variant &0000000000006, user ID KILARIS)

15.11.2008 11:48:00 Execute logical command BRARCHIVE On host sapdev

15.11.2008 11:48:00 Parameters:-u / -jid LOG__20081115114800 -c force -p initEDV.sap -cds -w use_rmv -v SCRATCH

15.11.2008 11:48:00 BR0002I BRARCHIVE 7.00 (24)

15.11.2008 11:48:00 BR0006I Start of offline redo log processing: adzgltem.cds 2008-11-15 11.48.00

15.11.2008 11:48:00 BR0484I BRARCHIVE log file: /oracle/EDV/saparch/adzgltem.cds

15.11.2008 11:48:00 BR0477I Oracle pfile /oracle/EDV/102_64/dbs/initEDV.ora created from spfile /oracle/EDV/102_64/dbs/spfileEDV.ora

15.11.2008 11:48:00 BR0123E Format error found in line 1 of /oracle/EDV/saparch/archEDV.log, location arch_copy_delete-8

15.11.2008 11:48:00 0zffcxe sve 2008-11-08 20.30.42 2008-11-08 20.30.56 9 ........... 0 0 0 0 ---k-

15.11.2008 11:48:00 BR0121E Processing of log file /oracle/EDV/saparch/archEDV.log failed

15.11.2008 11:48:00

15.11.2008 11:48:00 BR0016I 0 offline redo log files processed, totalsize 0.000 MB

15.11.2008 11:48:00

15.11.2008 11:48:00 BR0007I End of offline redo log processing: adzgltem.cds 2008-11-15 11.48.00

15.11.2008 11:48:00 BR0280I BRARCHIVE time stamp: 2008-11-15 11.48.00

15.11.2008 11:48:00 BR0005I BRARCHIVE terminated with errors

15.11.2008 11:48:00 External program terminated with exit code 3

15.11.2008 11:48:00 BRARCHIVE returned error status E

15.11.2008 11:48:01 Job finished

Regards

Siva

Edited by: skumar k on Nov 15, 2008 8:33 AM

Edited by: skumar k on Nov 15, 2008 8:34 AM

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

>BR0123E Format error found in line 1 of /oracle/EDV/saparch/archEDV.log

try to move the file archEDV.log and start your archive log backup again.

cheers,

-Sunil

sivakumar_kilari3
Active Contributor
0 Kudos

Sunil,

I am getting following error.

15.11.2008 15:04:21 Job started

15.11.2008 15:04:21 Step 001 started (program RSDBAJOB, variant &0000000000005, user ID KILARIS)

15.11.2008 15:04:21 Execute logical command BRARCHIVE On host sapdev

15.11.2008 15:04:21 Parameters:-u / -jid LOG__20081115150420 -c force -p initEDV.sap -s -w use_rmv -v SCRATCH

15.11.2008 15:04:22 BR0002I BRARCHIVE 7.00 (24)

15.11.2008 15:04:22 BR0006I Start of offline redo log processing: adzgmkpp.sve 2008-11-15 15.04.21

15.11.2008 15:04:22 BR0484I BRARCHIVE log file: /oracle/EDV/saparch/adzgmkpp.sve

15.11.2008 15:04:22 BR0477I Oracle pfile /oracle/EDV/102_64/dbs/initEDV.ora created from spfile /oracle/EDV/102_64/dbs/spfileEDV.ora

15.11.2008 15:04:22

15.11.2008 15:04:22 BR0280I BRARCHIVE time stamp: 2008-11-15 15.04.22

15.11.2008 15:04:22 BR0008I Offline redo log processing for database instance: EDV

15.11.2008 15:04:22 BR0009I BRARCHIVE action ID: adzgmkpp

15.11.2008 15:04:22 BR0010I BRARCHIVE function ID: sve

15.11.2008 15:04:22 BR0048I Archive function: save

15.11.2008 15:04:22 BR0011I 4 offline redo log files found for processing, total size 167.772 MB

15.11.2008 15:04:22 BR0112I Files will not be compressed

15.11.2008 15:04:22 BR0130I Backup device type: tape

15.11.2008 15:04:22 BR0102I Following backup device will be used: /dev/rmt0.1

15.11.2008 15:04:22 BR0104I 1 scratch volume will be used

15.11.2008 15:04:22 BR0136I Verify option with value 'use_rmv' set - double work to do

15.11.2008 15:04:22 BR1391I RMAN will be used for verification

15.11.2008 15:04:22 BR0134I Unattended mode with 'force' active - no operator confirmation allowed

15.11.2008 15:04:22

15.11.2008 15:04:22 BR0237I Scratch volume required in device /dev/rmt0.1

15.11.2008 15:04:22

15.11.2008 15:04:22 BR0280I BRARCHIVE time stamp: 2008-11-15 15.04.22

15.11.2008 15:04:22 BR0226I Rewinding tape volume in device /dev/rmt0...

15.11.2008 15:04:22 BR0278E Command output of 'LANG=C tctl -f /dev/rmt0 rewind':

15.11.2008 15:04:22 /dev/rmt0: Device not ready

15.11.2008 15:04:22 BR0280I BRARCHIVE time stamp: 2008-11-15 15.04.22

15.11.2008 15:04:22 BR0279E Return code from 'LANG=C tctl -f /dev/rmt0 rewind': 2

15.11.2008 15:04:22 BR0213E Winding tape volume in device /dev/rmt0.1failed

15.11.2008 15:04:22

15.11.2008 15:04:22 BR0016I 0 offline redo log files processed, totalsize 0.000 MB

15.11.2008 15:04:22

15.11.2008 15:04:22 BR0007I End of offline redo log processing: adzgmkpp.sve 2008-11-15 15.04.22

15.11.2008 15:04:22 BR0280I BRARCHIVE time stamp: 2008-11-15 15.04.22

15.11.2008 15:04:22 BR0005I BRARCHIVE terminated with errors

15.11.2008 15:04:22 External program terminated with exit code 5

15.11.2008 15:04:22 BRARCHIVE returned error status E

15.11.2008 15:04:22 Job finished

Regards

Siva

markus_doehr2
Active Contributor
0 Kudos

15.11.2008 15:04:22 /dev/rmt0: Device not ready

Your tape device is not ready - you will need to check from OS level if it´s available. Also check if you have a tape in it.

Markus

sivakumar_kilari3
Active Contributor
0 Kudos

Markus,

Init also I am getting error.

15.11.2008 15:03:22 Job started

15.11.2008 15:03:22 Step 001 started (program RSDBAJOB, variant &0000000000004, user ID KILARIS)

15.11.2008 15:03:22 Execute logical command BRBACKUP On host sapdev

15.11.2008 15:03:22 Parameters:-u / -jid TAPIN20081115150322 -i force -c force -n 1 -v SCRATCH

15.11.2008 15:03:22 BR0051I BRBACKUP 7.00 (24)

15.11.2008 15:03:22 BR0055I Start of database backup: bdzgmkni.tib 2008-11-15 15.03.22

15.11.2008 15:03:22 BR0484I BRBACKUP log file: /oracle/EDV/sapbackup/bdzgmkni.tib

15.11.2008 15:03:22 BR0477I Oracle pfile /oracle/EDV/102_64/dbs/initEDV.ora created from spfile /oracle/EDV/102_64/dbs/spfileEDV.ora

15.11.2008 15:03:22

15.11.2008 15:03:22 BR0205I Backup volume initialization

15.11.2008 15:03:22 BR0058I BRBACKUP action ID: bdzgmkni

15.11.2008 15:03:22 BR0059I BRBACKUP function ID: tib

15.11.2008 15:03:22 BR0102I Following backup device will be used: /dev/rmt0.1

15.11.2008 15:03:22 BR0131I All volumes get the name SCRATCH

15.11.2008 15:03:22 BR0129I Force option set - no label checking during initialization

15.11.2008 15:03:22 BR0134I Unattended mode with 'force' active - no operator confirmation allowed

15.11.2008 15:03:22

15.11.2008 15:03:22 BR0207I Volume in device: /dev/rmt0.1 will be initialized with name: SCRATCH

15.11.2008 15:03:22

15.11.2008 15:03:22 BR0280I BRBACKUP time stamp: 2008-11-15 15.03.22

15.11.2008 15:03:22 BR0226I Rewinding tape volume in device /dev/rmt0...

15.11.2008 15:03:22 BR0278E Command output of 'LANG=C tctl -f /dev/rmt0 rewind':

15.11.2008 15:03:22 /dev/rmt0: Device not ready

15.11.2008 15:03:22 BR0280I BRBACKUP time stamp: 2008-11-15 15.03.22

15.11.2008 15:03:22 BR0279E Return code from 'LANG=C tctl -f /dev/rmt0 rewind': 2

15.11.2008 15:03:22 BR0213E Winding tape volume in device /dev/rmt0.1failed

15.11.2008 15:03:22 BR0219E Initialization of volume SCRATCH in device /dev/rmt0.1 failed

15.11.2008 15:03:22

15.11.2008 15:03:22 BR0206I End of backup volume initialization

15.11.2008 15:03:22 BR0280I BRBACKUP time stamp: 2008-11-15 15.03.22

15.11.2008 15:03:22 BR0054I BRBACKUP terminated with errors

15.11.2008 15:03:22 External program terminated with exit code 3

15.11.2008 15:03:22 BRBACKUP returned error status E

15.11.2008 15:03:22 Job finished

Regards

Siva

markus_doehr2
Active Contributor
0 Kudos

Yes - your device is not ready (tape inserted? accessible from OS?)

Markus

sivakumar_kilari3
Active Contributor
0 Kudos

yes, It is showing in OS level.

Regards

Siva

markus_doehr2
Active Contributor
0 Kudos

Your problem is not a SAP problem.

BR*tools just use the native OS interface to access the tape - this is not working. Neither me nor anyone else can help you but tell you to check if the tape is accessible from OS (using "tar" or "cpio" or "mt"). Check your OS´ messages log, if all does not work reboot the machine.

Markus

sivakumar_kilari3
Active Contributor
0 Kudos

Markus,

I restarted the server but same

15.11.2008 16:58:09 Job started

15.11.2008 16:58:11 Step 001 started (program RSDBAJOB, variant &0000000000009, user ID KILARIS)

15.11.2008 16:58:11 Execute logical command BRBACKUP On host sapdev

15.11.2008 16:58:11 Parameters:-u / -jid TAPIN20081115165809 -i force -c force -n 1 -v SCRATCH

15.11.2008 16:58:13 BR0051I BRBACKUP 7.00 (24)

15.11.2008 16:58:13 BR0055I Start of database backup: bdzgmusi.tib 2008-11-15 16.58.12

15.11.2008 16:58:13 BR0484I BRBACKUP log file: /oracle/EDV/sapbackup/bdzgmusi.tib

15.11.2008 16:58:13 BR0477I Oracle pfile /oracle/EDV/102_64/dbs/initEDV.ora created from spfile /oracle/EDV/102_64/dbs/spfileEDV.ora

15.11.2008 16:58:13

15.11.2008 16:58:13 BR0205I Backup volume initialization

15.11.2008 16:58:13 BR0058I BRBACKUP action ID: bdzgmusi

15.11.2008 16:58:13 BR0059I BRBACKUP function ID: tib

15.11.2008 16:58:13 BR0102I Following backup device will be used: /dev/rmt0.1

15.11.2008 16:58:13 BR0131I All volumes get the name SCRATCH

15.11.2008 16:58:13 BR0129I Force option set - no label checking during initialization

15.11.2008 16:58:13 BR0134I Unattended mode with 'force' active - no operator confirmation allowed

15.11.2008 16:58:13

15.11.2008 16:58:13 BR0207I Volume in device: /dev/rmt0.1 will be initialized with name: SCRATCH

15.11.2008 16:58:13

15.11.2008 16:58:13 BR0280I BRBACKUP time stamp: 2008-11-15 16.58.12

15.11.2008 16:58:13 BR0226I Rewinding tape volume in device /dev/rmt0...

15.11.2008 16:58:13 BR0278E Command output of 'LANG=C tctl -f /dev/rmt0 rewind':

15.11.2008 16:58:13 /dev/rmt0: No such device or address

15.11.2008 16:58:13 BR0280I BRBACKUP time stamp: 2008-11-15 16.58.12

15.11.2008 16:58:13 BR0279E Return code from 'LANG=C tctl -f /dev/rmt0 rewind': 2

15.11.2008 16:58:13 BR0213E Winding tape volume in device /dev/rmt0.1failed

15.11.2008 16:58:13 BR0219E Initialization of volume SCRATCH in device /dev/rmt0.1 failed

15.11.2008 16:58:13

15.11.2008 16:58:13 BR0206I End of backup volume initialization

15.11.2008 16:58:13 BR0280I BRBACKUP time stamp: 2008-11-15 16.58.13

15.11.2008 16:58:13 BR0054I BRBACKUP terminated with errors

15.11.2008 16:58:13 External program terminated with exit code 3

15.11.2008 16:58:13 BRBACKUP returned error status E

15.11.2008 16:58:13 Job finished

Regards

Siva

markus_doehr2
Active Contributor
0 Kudos

> 15.11.2008 16:58:13 /dev/rmt0: No such device or address

This is a different error message.

The OS has not detected a tape device at that adresse.

What OS are you using?

Markus

sivakumar_kilari3
Active Contributor
0 Kudos

AIX 5.3

Siva

Former Member
0 Kudos

check whether your tape is accessible and are you able to take a backup from OS first,

cheers,

-Sunil

sivakumar_kilari3
Active Contributor
0 Kudos

Sunil,

I am getting following message.

  1. mt -f /dev/rmt0 rewind

/dev/rmt0: There is a request to a device or address that does not exist.

Regards

Siva

markus_doehr2
Active Contributor
0 Kudos

The device is not recognized by the OS.

Check cabling (inside the system) and termination and if you can´t find anything contact IBM. This is not a SAP problem.

Markus

Answers (1)

Answers (1)

former_member195313
Participant
0 Kudos

Hello ,

Please try the soluiton of;

Creating new and empty "ARCH<SID>.LOG" file instead of corrupted old one.

Solution : BR0123E Format error found in line

Best Regards

Fatih YUKSEL