legato备份不成功,报ORA-00604, ORA-01115,ORA-01110,ORA-15081
今天客户新配置了legato磁带备份数据库的脚本,但是执行rman时候一直报错:
1.报错信息如下:
RMAN> connect target sys/password@XXXX;
2> run{
3> CONFIGURE CONTROLFILE AUTOBACKUP ON;
..........
35>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-00604: error occurred at recursive SQL level 1
ORA-01115: IO error reading block from file (block # )
ORA-01110: data file 1: '+DATAVG/wzdb/datafile/system.261.787207209'
ORA-15081: failed to submit an I/O operation to a disk
RMAN-04015: error setting target database character set to US7ASCII
2.测试排除
.本地备份是成功的。
.用legato 备份不成功。
.测试connect target sys/password@XXXX; 是否登录成功,配置legato需要sys用户。
远程登录sys用户报错:ORA-01017: invalid username/password; logon denied
3.知道是密码问题就好办了
参考以前的“远程登录sys用户报错:ORA-01017: invalid username/password; logon denied”的处理方式后,再次执行legato备份,备份成功。
--------------------------------------分割线 --------------------------------------
在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm
Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm
Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm
--------------------------------------分割线 --------------------------------------
更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12
本文永久更新链接地址:http://www.linuxidc.com/Linux/2014-06/103161.htm