oracle12152,ORA-27206 – 提供7*24专业数据库(Oracle,SQL Server,MySQL等)恢复和Oracle技术服务@Tel:+86 13429648788 - 惜分飞...

检查alert日志发现近期数据库出现了ORA-19583/ORA-27206/ORA-06512错误

Fri Dec 30 12:22:36 2011

Errors in file /oracle9/app/admin/ykcdb/udump/ykcdb_ora_5390564.trc:

ORA-19583: conversation terminated due to error

ORA-27206: requested file not found in media management catalog

ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 625

进一步查看trace文件发现

Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production

With the Partitioning option

JServer Release 9.2.0.7.0 - Production

ORACLE_HOME = /oracle9/app/product/9.2.0

System name: AIX

Node name: OFFON2

Release: 3

Version: 5

Machine: 000A36B8D600

Instance name: ykcdb

Redo thread mounted by this instance: 1

Oracle process number: 79

Unix process pid: 5390564, image: oracle@OFFON2 (TNS V1-V3)

*** 2011-12-30 12:22:36.051

*** SESSION ID:(32.62184) 2011-12-30 12:22:36.023

FATAL ERROR IN TWO-TASK SERVER: error = 12152

*** 2011-12-30 12:22:36.051

ksedmp: internal or fatal error

ORA-19583: conversation terminated due to error

ORA-27206: requested file not found in media management catalog

ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 625

----- Call Stack Trace -----

calling call entry argument values in hex

location type point (? means dubious value)

-------------------- -------- -------------------- ----------------------------

ksedmp+0148 bl ksedst 1025AE55C ?

opitsk+0968 bl ksedmp 20289E71C ?

opiino+0798 bl opitsk 000000000 ? 000000000 ?

opiodr+08c8 bl _ptrgl

opidrv+032c bl opiodr 3C00000018 ? 4101C7F40 ?

FFFFFFFFFFFF810 ? 0A03547C8 ?

sou2o+0028 bl opidrv 3C0C000000 ? 4A039C2D0

查看mos发现[ID 558993.1]提供了错误原因和解决方案

错误原因：RMAN backup to tape using veritas netbackup，The MML parameters like NB_ORA_CLIENT and NB_ORA_SERV were not given in proper case while configuring channel in RMAN backup.

解决方法：The NB_ORA_CLIENT and NB_ORA_SERV MML parameters are case sensitive. So make sure to give these parameters in same case while allocating or configuring RMAN channel as it is configure in Veritas server.