2011-07-18

Ora-00245 and ORA-17500 after upgrade to 11.2

After Upgrade To 11.2.0.2 We Recieve Ora-00245 During Autobackup Of The Controlfile. [ID 1308378.1]


Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.2 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Symptoms

RMAN backup reports errors in the alert.log :


2010-11-08 16:50:07.193000 +01:00
Control file backup creation failed.
Errors in file /ora_diag/diag/rdbms/twdwe8/twdwe8/trace/twdwe8_ckpt_7672.trc:
ORA-17500: ODM err:ODM ERROR V-41-4-1-83-9 Bad file number
2010-11-08 16:50:09.497000 +01:00
Errors in file /ora_diag/diag/rdbms/twdwe8/twdwe8/trace/twdwe8_ora_11983.trc:
ORA-00245: control file backup operation failed
2010-11-08 16:53:44.564000 +01:00
Control file backup creation failed.
Errors in file /ora_diag/diag/rdbms/twdwe8/twdwe8/trace/twdwe8_ckpt_7672.trc:
ORA-17500: ODM err:ODM ERROR V-41-4-1-83-9 Bad file number
Errors in file /ora_diag/diag/rdbms/twdwe8/twdwe8/trace/twdwe8_ora_24081.trc:
ORA-00245: control file backup operation failed

Changes

Upgraded to 11g Release 2 (11.2.0.2.0)

Cause

This is an RDBMS Software Defect as investigated in :
Bug 10317487 - RMAN CONTROLFILE BACKUP FAILS WITH ODM ERROR ORA-17500 AND ORA-245

and is only relevant if ODM is being used.

Solution

The solution is to apply the fix for Bug 10317487 which will be included in PatchSet 11.2.0.3.
One-off patches for 11.2.0.2 might be available as Patch 10317487

A workaround is to make the controlfile backup via SQL*Plus instead of RMAN

SQL> alter database backup controlfile to '<file>';

References

BUG:10317487

2 comentarii:

  1. Acest comentariu a fost eliminat de administratorul blogului.

    RăspundețiȘtergere
  2. Acest comentariu a fost eliminat de administratorul blogului.

    RăspundețiȘtergere