ora-19550无法在使用调度程序时使用备份/恢复功能

最新推荐文章于 2021-06-10 10:43:54 发布

闭眼忘世界

最新推荐文章于 2021-06-10 10:43:54 发布

阅读量1.4k

点赞数

分类专栏： Oracle Troubleshooting

本文链接：https://blog.csdn.net/hughwang1216/article/details/14157403

版权

Oracle Troubleshooting 专栏收录该内容

13 篇文章 0 订阅

订阅专栏

ora-19550无法在使用调度程序时使用备份/恢复功能

RMAN> list backup;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of register command at 05/07/2007 10:32:31
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of full resync command on default channel at 05/07/2007 10:32:31
ORA-19550: cannot use backup/restore functions while using dispatcher



--错误原因
rman target sys/system@x catalog rman/rman@rman
@x ,x为使用shared模式的服务名，rman需要使用dedicated模式连接否则，连接上后执行
backup database,register database,resync catalog均出现以上错误
--解决
因db配置为MTS，修改tnsnames.ora文件把connect mode改为dedicated即可。
或者有连接时用使用dedicated模式的服务名连接即可
如 rman target sys/system@abc catalog rman/rman@rman

tnsnames.ora
ABC =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 2012-20130722VO)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = test)
    )
  )