近两天原本备份正常的数据库突然备份失败,检查日志,发现卡在最后的备份控制文件的地方。按照网上的解决方法试了,都么有作用:
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 autobackupGot error: 230Autobackup failed with following errorORA-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有没有大神有遇到过相同问题,感谢各位了!!!!!
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 autobackupGot error: 230Autobackup failed with following errorORA-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有没有大神有遇到过相同问题,感谢各位了!!!!!
asmcmd进入相应目录,看是不是有这个文件?
cd +DATAC1/XXXX/PASSWORD
ls看看pwdxxxx.312.988645687