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

RMAN> register database;
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
 
ORA-19550 cannot use backup/restore functions while using dispatcher
Cause An attempt was made to use backup/restore functions while connected to the dispatcher in a multi-threaded server. This is not allowed because the device that is used for backup and restore must remain allocated to a single process.
Action Connect directly to the instance then re-execute the backup or restore function.

因db配置为MTS,修改tnsnames.ora文件把connect mode改为dedicated即可。

shared server configuration, as indicated by (SERVER=shared).

(DESCRIPTION= 
  (ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1521))
  (CONNECT_DATA=
    (SERVICE_NAME=sales.us.acme.com)
     (SERVER=shared)))

If you want the client to use a dedicated server, you can specify (SERVER=dedicated) in place of (SERVER=shared). If the SERVER parameter is not set, then shared server configuration is assumed. However, the client will use a dedicated server if no dispatchers are available.


上一篇:清华副校长杨斌 :“祛魅”, 科技创新需要避免教育“人性”缺失


下一篇:ERP软件中功能测试的实用方法