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: 

BRBACKUP terminates during FullOnline of Oracle Database

Former Member

on ‎06-09-2008 12:08 PM

0 Kudos

Hi,

Our FullOnline backups (to disk) of a Production Oracle database are failing with the following error message:

-

BR0278E Command output of 'e:\oracle\SID\920\bin\RMAN nocatalog':

Recovery Manager: Release 9.2.0.5.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

RMAN>

RMAN> connect target /;

connected to target database: SID (DBID=1609604882)

using target database controlfile instead of recovery catalog

RMAN> *end-of-file*

RMAN>

host command complete

RMAN> 2> 3> 4> 5>

allocated channel: dsk

channel dsk: sid=131 devtype=DISK

Starting copy at 07-JUN-08

released channel: dsk

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

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

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

RMAN-03002: failure of copy command at 06/07/2008 11:12:37

ORA-00235: controlfile fixed table inconsistent due to concurrent update

RMAN-06010: error while looking up datafile: G:\ORACLE\SID\SAPDATA4\SID_15\SID.DATA15

RMAN>Recovery Manager complete.

BR0280I BRBACKUP time stamp: 2008-06-07 11.12.37

BR0279E Return code from 'e:\oracle\SID\920\bin\RMAN nocatalog': 3

BR0536E RMAN call for database instance SID failed

BR0280I BRBACKUP time stamp: 2008-06-07 11.12.37

BR0503E Normal database backup using RMAN failed

BR0222E Copying G:\ORACLE\SID\SAPDATA4\SID_15\SID.DATA15 to/from S:\backtodisk\Database\bdycauxg failed due to previous errors

BR0056I End of database backup: bdycauxg.and 2008-06-07 11.12.37

BR0280I BRBACKUP time stamp: 2008-06-07 11.12.42

BR0280I BRBACKUP terminated with errors: 2008-06-07

-

We are running the following versions of software:

Windows Server 2003 Enterprise Edition 32-bit (SP0)

BRBACKUP 640 (40)

Oracle 9.2.0.5

We have gone through a number of Notes and found relatively litttle resolution to this problem. Has anyone been able to resolve this or have any suggetions, other than a DB or hardware upgrade, that might solve this issue.

Thanks and regards,

Andrew

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (3)

Answers (3)

markus_doehr2
Active Contributor
‎06-09-2008 7:23 PM
0 Kudos

Just to add:

Metalink 2391697.8 (Bug 2391697 - ORA-235 doing backup with RMAN in nocatalog mode) describes the problem, the fix is to upgrade to 9.2.0.7.

Markus

Show replies
Show replies
Former Member
‎06-10-2008 10:36 AM
0 Kudos

Hi Marcus,

Thanks for digging this one up, I hadn't started looking on Metlink yet. This looks like a possible solution to our problem and I'll kick off an Oracle upgrade project as soon as possible. Once the upgrade is complete, I'll let you know if it has resolved the issue.

Thanks again.

Andrew

Former Member
‎06-11-2008 3:04 PM
0 Kudos

Hi,

We opened an OSS message regarding this issue and SAP had the following response:

-

The errors are a result of Oracle bug 5137578: "ORA-235 AND RMAN-6010 DURING VALIDATE" base bug 2391697 from metalink as you have just mentioned. There have been other Customers experiencing this problem in 9.2.0.7.

Our Development opened bug (#5285032) for another customer, but this bug was closed because it was not feasible to fix the problem in Oracle 9.2.0.7. The bug is fixed in Oracle 10.2.0.2 and the changes are too large to open a new bug for 9.2.0.7.

The only current option is to upgrade to 10.2.0.2 to resolve this problem.

-

Unfortunately, there doesn't seem to be any way around this other than upgrade to 10.2.0.2.

Regards,

Andrew

markus_doehr2
Active Contributor
‎06-09-2008 12:16 PM
0 Kudos

did you update the RMAN catalog after adding that datafile?

Markus

Show replies
Show replies
Former Member
‎06-09-2008 12:50 PM
0 Kudos

Hi,

Thanks for the replies.

Kaushal, we are running on Oracle 9.2.0.5 and the Hotfix in Note 458932 is included in version 9.2.0.3.

Markus, we have not included updating of the RMAN catalog as part of our procedure when adding data files. I have read through Note 1113677 (Recovery catalog and backups with RMAN) and it mentions that the RMAN Catalog is not supported by BRTOOLS. Is there a reason for this? Should this step always be included when running an RMAN-based backup solution?

Also, our backup fails at various intervals, sometimes it fails after writing just one data file and other times it fails after writing 100 data files. It seems to be linked to the amount of activity on the database at the time of the failure, but we can only minimise this, not stop it durting the 12 hour backup window.

Thanks.

Andrew

markus_doehr2
Active Contributor
‎06-09-2008 1:04 PM
0 Kudos

Markus, we have not included updating of the RMAN catalog as part of our procedure when adding data files. I have read through Note 1113677 (Recovery catalog and backups with RMAN) and it mentions that the RMAN Catalog is not supported by BRTOOLS. Is there a reason for this? Should this step always be included when running an RMAN-based backup solution?

The note just says, that his steps is not automatically be done by brbackup but you can do it "manually".

Also, our backup fails at various intervals, sometimes it fails after writing just one data file and other times it fails after writing 100 data files. It seems to be linked to the amount of activity on the database at the time of the failure, but we can only minimise this, not stop it durting the 12 hour backup window.

Intermittent failures are very difficult to trace, especially on a public forum. I´d open an OSS call and let the support people look on the system.

Apart from that, I HIGHLY suggest upgrading to a more current Oracle release, the least supported one for which fixes will be provided, is 9.2.0.7. Keep in mind that standard maintenance for Oracle 9i is running out in about 7 weeks (end of July 2008 - see note 1021844 - Oracle 9.2 Extended Support free until July 31, 2008). If you don´t wanna pay a high amount of money for additional maintenance I´d upgrade to 10g.

Markus

Former Member
‎06-09-2008 3:16 PM
0 Kudos

Hi Marcus,

Thanks for your answer. We are about to start a 9 month migration project, so we will be upgrading before the end of the year. I was hoping to find a short term fix that we could apply in the interim.

Thanks and regards,

Andrew

Former Member
‎07-11-2008 8:37 AM
0 Kudos

Hi,

I am using oracle 10g 10.2.0.2.0 on OS unix 11.23

on development server through DB13 backup is failed with following error. but whole online database backup & full offline database backup done successfully.

Thanks & Regards

Nikam V.B.

BR0001I **************************************************

BR0280I BRBACKUP time stamp: 2008-06-04 11.59.56

BR0317I 'Alter tablespace SYSTEM end backup' successful

BR0280I BRBACKUP time stamp: 2008-06-04 11.59.58

BR0530I Cataloging backups of all database files...

BR0278E Command output of 'SHELL=/bin/sh /oracle/DEV/102_64/bin/rman nocatalog':

Recovery Manager: Release 10.2.0.2.0 - Production on Wed Jun 4 11:59:59 2008

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

RMAN>

RMAN> connect target *

PL/SQL package SYS.DBMS_BACKUP_RESTORE version 10.02.00.00 in TARGET database is not current

PL/SQL package SYS.DBMS_RCVMAN version 10.02.00.00 in TARGET database is not current

connected to target database: DEV (DBID=3708867807)

using target database control file instead of recovery catalog

RMAN> *end-of-file*

RMAN>

host command complete

RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59> 60> 61> 62> 63> 64> 65> 6

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

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

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

RMAN-03002: failure of catalog command at 06/04/2008 12:00:03

ORA-06550: line 1, column 2273:

PLS-00302: component 'GETRANGEALBACKUP' must be declared

ORA-06550: line 1, column 2238:

PL/SQL: Statement ignored

RMAN>

Recovery Manager complete.

BR0280I BRBACKUP time stamp: 2008-06-04 12.00.03

BR0279E Return code from 'SHELL=/bin/sh /oracle/DEV/102_64/bin/rman nocatalog': 1

BR0536E RMAN call for database instance DEV failed

BR0280I BRBACKUP time stamp: 2008-06-04 12.00.03

BR0532E Cataloging backups of all database files failed

BR0056I End of database backup: bdybljkn.fnt 2008-06-04 12.00.03

BR0280I BRBACKUP time stamp: 2008-06-04 12.00.03

BR0054I BRBACKUP terminated with errors

Edited by: VIJAY NIKAM on Jul 11, 2008 10:49 AM

Edited by: VIJAY NIKAM on Jul 11, 2008 11:01 AM

Former Member
‎07-26-2008 12:45 PM
0 Kudos

Hi,

I am using oracle 10g 10.2.0.2.0 on OS unix 11.23

on development server through DB13 backup is failed with following error. but whole online database backup & full offline database backup done successfully.

Thanks & Regards

Nikam V.B.

BR0001I **************************************************

BR0280I BRBACKUP time stamp: 2008-06-04 11.59.56

BR0317I 'Alter tablespace SYSTEM end backup' successful

BR0280I BRBACKUP time stamp: 2008-06-04 11.59.58

BR0530I Cataloging backups of all database files...

BR0278E Command output of 'SHELL=/bin/sh /oracle/DEV/102_64/bin/rman nocatalog':

Recovery Manager: Release 10.2.0.2.0 - Production on Wed Jun 4 11:59:59 2008

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

RMAN>

RMAN> connect target *

PL/SQL package SYS.DBMS_BACKUP_RESTORE version 10.02.00.00 in TARGET database is not current

PL/SQL package SYS.DBMS_RCVMAN version 10.02.00.00 in TARGET database is not current

connected to target database: DEV (DBID=3708867807)

using target database control file instead of recovery catalog

RMAN> *end-of-file*

RMAN>

host command complete

RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59> 60> 61> 62> 63> 64> 65> 6

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

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

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

RMAN-03002: failure of catalog command at 06/04/2008 12:00:03

ORA-06550: line 1, column 2273:

PLS-00302: component 'GETRANGEALBACKUP' must be declared

ORA-06550: line 1, column 2238:

PL/SQL: Statement ignored

RMAN>

Recovery Manager complete.

BR0280I BRBACKUP time stamp: 2008-06-04 12.00.03

BR0279E Return code from 'SHELL=/bin/sh /oracle/DEV/102_64/bin/rman nocatalog': 1

BR0536E RMAN call for database instance DEV failed

BR0280I BRBACKUP time stamp: 2008-06-04 12.00.03

BR0532E Cataloging backups of all database files failed

BR0056I End of database backup: bdybljkn.fnt 2008-06-04 12.00.03

BR0280I BRBACKUP time stamp: 2008-06-04 12.00.03

BR0054I BRBACKUP terminated with errors

markus_doehr2
Active Contributor
‎07-26-2008 12:52 PM
0 Kudos

> PL/SQL package SYS.DBMS_RCVMAN version 10.02.00.00 in TARGET database is not current

> connected to target database: DEV (DBID=3708867807)

did you upgrade your database and "forgot" to upgrade your rman catalog?

Markus

Former Member
‎08-01-2008 11:05 AM
0 Kudos

Dear Markus

Thanks for reply.

Can you send me the procedure to upgrade RMAN. catlog ?

Thanks & Regards

Nikam V.B.

Former Member
‎06-09-2008 12:14 PM
0 Kudos

Hi,

ORA-00235: controlfile fixed table inconsistent

Please install Bug Fix for bug 2859263

check Note 625012 - ORA-235: controlfile fixed table inconsistent

also consider Note 458932 - Composite SAP note: ORA-00235

regards,

kaushal

Edited by: Kaushal Malavia on Jun 9, 2008 4:47 PM

Show replies
Show replies
Ask a Question