检查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.

更多推荐

oracle 转义 039,ORA-19583 – 提供7*24专业数据库(Oracle,SQL Server,MySQL等)恢复和Oracle技术服务@Tel