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

来源:互联网 发布:关于网络的作文 高中 编辑:程序博客网 时间:2024/05/16 18:56
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:31RMAN-03014: implicit resync of recovery catalog failedRMAN-03009: failure of full resync command on default channel at 05/07/2007 10:32:31ORA-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@rmantnsnames.oraABC =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = 2012-20130722VO)(PORT = 1521))    )    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = test)    )  )

原创粉丝点击