Skip to Content
0
Former Member
May 11, 2011 at 01:19 PM

Archive logs backup failing

503 Views

Hi,

the archive log of our sap system doesn't work.

I'm looking the solution through sapnote 490976, 10170 and others, but no solution since now.

As you can see from the following log, the brarchive can't find some .DBF files, but there's another problem when the log says:

Starting backup at 11-MAY-11

released channel: dsk

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of backup command at 05/11/2011 13:52:51

RMAN-20242: specification does not match any archive log in the recovery catalog

RMAN>

RMAN>

Recovery Manager complete.

BR0280I BRARCHIVE time stamp: 2011-05-11 13.52.52

BR0279E Return code from 'D:\oracle\PID\102\BIN\rman nocatalog': 1

BR0536E RMAN call for database instance PID failed

BR0280I BRARCHIVE time stamp: 2011-05-11 13.52.52

BR0543E Offline redo log backup using RMAN failed

Could you plese help me finding the solution?

Kind regards

Massimo Solleretto

BR0002I BRARCHIVE 7.10 (20)

BR0006I Start of offline redo log processing: aefvznds.svd 2011-05-11 13.52.44

BR0484I BRARCHIVE log file: F:\oracle\PID\saparch\aefvznds.svd

BR0477I Oracle pfile D:\oracle\PID\102\database\initPID.ora created from spfile D:\oracle\PID\102\database\spfilePID.ora

BR0101I Parameters

Name Value

oracle_sid PID

oracle_home D:\oracle\PID\102

oracle_profile D:\oracle\PID\102\database\initPID.ora

sapdata_home F:\oracle\PID

sap_profile D:\oracle\PID\102\database\initPID.sap

backup_dev_type disk

archive_copy_dir
asclepio\estia\REDO

compress no

disk_copy_cmd rman_set

cpio_disk_flags -pdcu

rman_compress yes

archive_dupl_del only

system_info SAPServicePID ESTIA Windows 5.2 Build 3790 Service Pack 2 AMD64

oracle_info PID 10.2.0.5.0 8192 21623 189105699 ESTIA UTF8 UTF8

sap_info 710 SAPSR3 0002LK0003PID0011O17864590130013NetWeaver_ORA

make_info NTAMD64 OCI_10201_SHARE Feb 9 2009

command_line brarchive -u / -jid LOG__20110511135244 -c force -p initPID.sap -sd

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20316_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20317_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20318_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20319_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20320_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20321_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20322_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20323_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20324_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20325_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20326_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20327_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20328_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20329_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20330_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20331_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20332_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20333_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20334_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20335_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20336_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20337_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20338_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20339_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20340_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20341_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20342_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20343_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20344_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20345_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20346_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20347_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20348_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20349_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20350_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20351_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20352_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20353_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20354_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20355_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20356_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20357_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20358_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20359_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20360_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20361_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20362_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20363_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20364_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20365_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20366_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20367_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20368_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20369_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20370_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20371_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20372_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20373_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20374_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20375_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20376_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20377_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20378_678482304.DBF' not found

BR0017W Offline redo log file 'F:\oracle\PID\oraarch\PIDARCH1_20379_678482304.DBF' not found

BR0280I BRARCHIVE time stamp: 2011-05-11 13.52.49

BR0008I Offline redo log processing for database instance: PID

BR0009I BRARCHIVE action ID: aefvznds

BR0010I BRARCHIVE function ID: svd

BR0048I Archive function: save_delete

BR0011I 2873 offline redo log files found for processing, total size 120929.645 MB

BR1397I Files will be compressed by RMAN

BR0130I Backup device type: disk

BR0106I Files will be saved on disk in directory:
asclepio\estia\REDO

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

BR0202I Saving init_ora

BR0203I to
asclepio\estia\REDO\PID ...

BR0202I Saving D:\oracle\PID\102\database\initPID.sap

BR0203I to
asclepio\estia\REDO\PID ...

BR0280I BRARCHIVE time stamp: 2011-05-11 13.52.50

BR0198I Profiles saved successfully

BR0202I Saving F:\oracle\PID\oraarch\PIDARCH1_18686_678482304.DBF

BR0203I to
asclepio\estia\REDO\PIDARCH1_18686_678482304.DBF.S ...

BR0278E Command output of 'D:\oracle\PID\102\BIN\rman nocatalog':

Recovery Manager: Release 10.2.0.5.0 - Production on Wed May 11 13:52:50 2011

Copyright (c) 1982, 2007, Oracle. All rights reserved.

RMAN>

RMAN> connect target *

connected to target database: PID (DBID=514142720)

using target database control file instead of recovery catalog

RMAN> *end-of-file*

RMAN>

host command complete

RMAN> 2> 3> 4> 5> 6>

allocated channel: dsk

channel dsk: sid=455 devtype=DISK

executing command: SET NOCFAU

Starting backup at 11-MAY-11

released channel: dsk

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of backup command at 05/11/2011 13:52:51

RMAN-20242: specification does not match any archive log in the recovery catalog

RMAN>

RMAN>

Recovery Manager complete.

BR0280I BRARCHIVE time stamp: 2011-05-11 13.52.52

BR0279E Return code from 'D:\oracle\PID\102\BIN\rman nocatalog': 1

BR0536E RMAN call for database instance PID failed

BR0280I BRARCHIVE time stamp: 2011-05-11 13.52.52

BR0543E Offline redo log backup using RMAN failed

BR0222E Copying F:\oracle\PID\oraarch\PIDARCH1_18686_678482304.DBF to/from
asclepio\estia\REDO failed due to previous errors

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

BR0007I End of offline redo log processing: aefvznds.svd 2011-05-11 13.52.52

BR0280I BRARCHIVE time stamp: 2011-05-11 13.52.52

BR0005I BRARCHIVE terminated with errors

Edited by: Massimo Solleretto on May 11, 2011 3:19 PM