使用rman ORA-19550 错误提示解决

最新推荐文章于 2021-04-14 00:02:34 发布

边城cn

最新推荐文章于 2021-04-14 00:02:34 发布

阅读量2.2k

点赞数

分类专栏： oracle 文章标签： database

本文链接：https://blog.csdn.net/miyatang/article/details/24772925

版权

oracle 专栏收录该内容

96 篇文章 1 订阅

订阅专栏

[oracle@dg1 bin]$ cat delete_archive.sh
#! /bin/bash
source /home/oracle/.bash_profile

/opt/app/oracle/product/11.2.0/bin/rman target sys/sys@ stbdb nocatalog log /home/oracle/bin/logs/"`date +%m%d`"_rman.log append <<EOF

run
{

delete expired archivelog all;
delete noprompt expired archivelog all;
DELETE ARCHIVELOG ALL COMPLETED before 'SYSDATE-4';
}
EOF
[oracle@dg1 bin]$ cat logs/0429_rman.log

Recovery Manager: Release 11.2.0.3.0 - Production on Tue Apr 29 23:10:01 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

connected to target database: RACDB (DBID=809919918)
using target database control file instead of recovery catalog

RMAN>
RMAN> 2> 3> 4> 5> 6> 7>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of crosscheck command at 04/29/2014 23:10:12
ORA-19550: cannot use backup/restore functions while using dispatcher

RMAN>

Recovery Manager complete.

经分析后，在TNSNAME.ORA 文档中添加如下内容：

STBDB =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = dg1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = stbdb)
   (server=dedicated)
    )
)

问题解决。

做BACKUP时只能用独占方式连结.加上(server=dedicated),说明使用独占连接

原因是在登录时使用了服务名：/rman target sys/sys@stbdb，