ORACLE rman备份之ORA-00230 无法备份控制文件
近两天原本备份正常的数据库突然备份失败,检查日志,发现卡在最后的备份控制文件的地方。
按照网上的解决方法试了,都么有作用:
1、权限问题:
$ORCLE_HOME/bin以及$GRID_HOME/bin下oracle的权限问题,经过检查,发现权限没有问题
2、RMAN残留进程
SELECT s.SID, USERNAME AS "User", PROGRAM, MODULE,
ACTION, LOGON_TIME "Logon"
FROM V$SESSION s, V$ENQUEUE_LOCK l
WHERE l.SID = s.SID
AND l.TYPE = 'CF'
AND l.ID1 = 0
AND l.ID2 = 2;
以及
SELECT s.SID, USERNAME AS "User", PROGRAM, MODULE,
ACTION, LOGON_TIME "Logon"
FROM V$SESSION s, V$ENQUEUE_LOCK l
WHERE l.SID = s.SID
AND l.TYPE = 'CF';
都没有查出有残留的RMAN进程。
alter日志内容为:
2019-06-13T02:04:34.027399+08:00
Starting control autobackup
Got error: 230
Autobackup failed with following error
ORA-00230: operation disallowed: snapshot control file enqueue unavailable
2019-06-13T02:04:51.372207+08:00
Errors in file /u01/app/oracle/diag/rdbms/xxxx/xxxx1/trace/xxxx1_ora_211136.trc:
ORA-17503: ksfdopn:2 Failed to open file +DATAC1/XXXX/PASSWORD/pwdxxxx.312.988645687
ORA-27300: OS system dependent operation:open failed with status: 13
ORA-27301: OS failure message: Permission denied
ORA-27302: failure occurred at: sskgmsmr_7
有没有大神有遇到过相同问题,感谢各位了!!!!!