您好,登录后才能下订单哦!
密码登录
登录注册
点击 登录注册 即表示同意《亿速云用户服务条款》
小编给大家分享一下rman备份密码报错的示例分析,相信大部分人都还不怎么了解,因此分享这篇文章给大家参考一下,希望大家阅读完这篇文章后大有收获,下面让我们一起去了解一下吧!
同事备份遇到了一个报错,提示用户密码拒绝。经过确认用户和密码都没有问题,那可能是什么问题呢!
1、现象
<roidb01:orcl:/u01/app/oracle/product/11.2.0/dbhome_1/network/admin>$ <roidb01:orcl:/u01/app/oracle/product/11.2.0/dbhome_1/network/admin>$sh rman.sh Recovery Manager: Release 11.2.0.4.0 - Production on Tue Feb 13 22:12:56 2018 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database: ORCL (DBID=1483481154) RMAN> 2> 3> using target database control file instead of recovery catalog RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-12001: could not open channel t1 RMAN-10008: could not create channel context RMAN-10003: unable to connect to target database ORA-01017: invalid username/password; logon denied RMAN>
2、部分脚本内容
<roidb01:orcl:/u01/app/oracle/product/11.2.0/dbhome_1/network/admin>$vi rman.sh $ORACLE_HOME/bin/rman target / <<EOF run{ allocate channel t1 device type disk connect 'sys/xxxx$2017_sys@orcl'; #发现这个密码里有特殊符号$ } exit EOF
3、解决方法
<roidb01:orcl:/u01/app/oracle/product/11.2.0/dbhome_1/network/admin>$ <roidb01:orcl:/u01/app/oracle/product/11.2.0/dbhome_1/network/admin>$cat rman.sh $ORACLE_HOME/bin/rman target / <<EOF run{ allocate channel t1 device type disk connect 'sys/xxxx\$2017_sys@orcl'; } exit EOF
shell 脚本中特殊符号需要使用\转义处理一下。
再次执行
<roidb01:orcl:/u01/app/oracle/product/11.2.0/dbhome_1/network/admin>$sh rman.sh Recovery Manager: Release 11.2.0.4.0 - Production on Tue Feb 13 22:13:20 2018 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database: ORCL (DBID=1483481154) RMAN> 2> 3> using target database control file instead of recovery catalog allocated channel: t1 channel t1: SID=46 device type=DISK released channel: t1 RMAN>
当我们在shell脚本里执行相关命令,一定要关注特殊符号的转义问题。
以上是“rman备份密码报错的示例分析”这篇文章的所有内容,感谢各位的阅读!相信大家都有了一定的了解,希望分享的内容对大家有所帮助,如果还想学习更多知识,欢迎关注亿速云行业资讯频道!
免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。