欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

RMAN备份报Erroroccurredgettingresponse-assumingNOresponse错

程序员文章站 2022-06-12 20:46:57
...

1、一个RMAN备份脚本报错信息 Do you really want to delete the above objects (enter YES or NO)? Do you really want to delete the above objects (enter YES or NO)? exit; is an invalid response - please re-enter. Do you really want to delete th

1、一个RMAN备份脚本报错信息

Do you really want to delete the above objects (enter YES or NO)?

Do you really want to delete the above objects (enter YES or NO)? "exit;" is an invalid response - please re-enter.

Do you really want to delete the above objects (enter YES or NO)?

Error occurred getting response - assuming NO response

released channel: c1

released channel: c2

released channel: c3

上面错误信息:Error occurred getting response - assuming NO response

2、原因分析

(1)检查脚本代码:

发现脚本代码中有一段:

delete archivelog all completed before 'sysdate-0.005';

(1)执行上面delete archivelog脚本时,给出提问选择信息:Do you really want to delete the above objects (enter YES or NO)?

(2)由于执行的是脚本代码,无法人工参与输入提问的选择值,所以报出“没有得到响应”的错误“Error occurred getting response - assuming NO response”

3、解决方法

修改脚本代码,加入noprompt关键字,即“不提示提问”,修改后代码如下:

delete noprompt archivelog all completed before 'sysdate-0.005';

本文作者:踩点

欢迎 加入 系统性能优化专业群 ,共同探讨性能优化技术。群号:258187244