cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Archive logs backup failing

Former Member

on ‎05-11-2011 2:19 PM

0 Kudos

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

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (1)

Answers (1)

markus_doehr2
Active Contributor
‎05-11-2011 2:48 PM
0 Kudos

> 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:

So the logs are not there?

Markus

Show replies
Show replies
Former Member
‎05-11-2011 3:19 PM
0 Kudos

In the ORAARCH, ive all DBF from PIDARCH1_18686_678482304.DBF to PIDARCH1_21625_678482304.DBF except the ones from PIDARCH1_20316_678482304.DBF to PIDARCH1_20379_678482304.DBF

So i've tryed moving all the archivelogs from the PIDARCH1_20380_678482304.DBF to the PIDARCH1_21625_678482304.DBF and executing again the brarchive.

The result was:

BR0002I BRARCHIVE 7.10 (20)

BR0006I Start of offline redo log processing: aefvmvsa.svd 2011-05-09 00.00.56

BR0484I BRARCHIVE log file: F:\oracle\PID\saparch\aefvmvsa.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 21527 188421347 ESTIA UTF8 UTF8

sap_info 710 SAPSR3 0002LK0003PID0011O17864590130013NetWeaver_ORA

make_info NTAMD64 OCI_10201_SHARE Feb 9 2009

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

BR0280I BRARCHIVE time stamp: 2011-05-09 00.01.02

BR0008I Offline redo log processing for database instance: PID

BR0009I BRARCHIVE action ID: aefvmvsa

BR0010I BRARCHIVE function ID: svd

BR0048I Archive function: save_delete

BR0011I 2841 offline redo log files found for processing, total size 119628.859 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-09 00.01.03

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 Mon May 9 00:01:03 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=450 devtype=DISK

executing command: SET NOCFAU

Starting backup at 09-MAY-11

released channel: dsk

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

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

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

RMAN-03002: failure of backup command at 05/09/2011 00:01:05

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

RMAN>

RMAN>

Recovery Manager complete.

BR0280I BRARCHIVE time stamp: 2011-05-09 00.01.06

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-09 00.01.06

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: aefvmvsa.svd 2011-05-09 00.01.06

BR0280I BRARCHIVE time stamp: 2011-05-09 00.01.06

BR0005I BRARCHIVE terminated with errors

Edited by: Massimo Solleretto on May 11, 2011 4:25 PM

Edited by: Massimo Solleretto on May 11, 2011 5:44 PM

Edited by: Massimo Solleretto on May 11, 2011 5:51 PM

Former Member
‎05-12-2011 1:27 AM
0 Kudos

Hi,

I thing they got backed up ..

try to restore those files by specifying the following command

brrestore -a 20316-20379

and after this run the archive log backup ..

Thanks,

Deepthi

Ask a Question