Nearly two days originally normal backup database backup suddenly fails, check the log, found the card at the end of the backup control file,

According to the online solutions tried, yao has a role:
1, the problem of authority:
Under $$GRID_HOME ORCLE_HOME/bin and/bin oracle permissions problems, after inspection, found no problem permissions

2, RMAN residual process
The SELECT s.S ID, USERNAME AS "User", the PROGRAM, MODULE,
The ACTION, LOGON_TIME "Logon"
The FROM V $SESSION s, V $ENQUEUE_LOCK l
WHERE l.S ID=s.S ID
AND l.T YPE='CF'
AND l.I D1=0
AND l.I D2=2;

And

The SELECT s.S ID, USERNAME AS "User", the PROGRAM, MODULE,
The ACTION, LOGON_TIME "Logon"
The FROM V $SESSION s, V $ENQUEUE_LOCK l
WHERE l.S ID=s.S ID
AND l.T YPE='CF';

Are not found to have residual RMAN process,


Alter the log content is:

The 2019-06-13 T02:04:34. 027399 + 08:00
Starting control autobackup

Got error: 230

Autobackup failed with the following error

ORA - 00230: the operation disallowed: snapshot control file the enqueue unavailable


The 2019-06-13 T02:04:51. 372207 + 08:00
Errors in the file/u01/app/oracle/diag/RDBMS/XXXX xxxx1/trace/xxxx1_ora_211136 TRC:
ORA - 17503:2 ksfdopn: Failed to open the file + DATAC1/XXXX/PASSWORD/PWDXXXX.
312.988645687ORA - 27300: OS system dependent operation: open failed with status: 13
ORA - 27301: OS failure message: Permission denied
ORA - 27302: a failure occurred at: sskgmsmr_7



Have a great spirit have encountered the same problem, thank you!!!!!!!!!!!

CodePudding user response:

This sure is a control file? Look at how like a password file? The system software is also on the Shared storage? And underground error because of permissions not enough lead to a bit strange, looks really like oracle executable permissions, $ORACLE_HOME/bin/oracle with $GRID_HOME/bin/oracle beyond an s permission, their owner and user groups which have problems?

CodePudding user response:

Oralce software is not on the Shared storage,

It prompts authority is not enough, it is feel very strange, $ORACLE_HOME/bin/oracle with $GRID_HOME/bin/oracle beyond an s permission, their owner and user groups which have confirmed that there is no problem,

And the problem is not always exist, has been a normal backup before, just recently, suddenly began to complain, backup problems before, did not do any changes to your database operations,

Now use third party software, and manual backup, all in the backup control file, stuck down is no longer,

See the log, the alter only ORA - 00230 error in the log, but can see the tip in TRC log failed to open the password file error,

CodePudding user response:

If the software is not on the Shared storage, then the password file should be in the local file system, under the $ORACLE_HOME/DBS, the file is there a problem?

CodePudding user response:

You use the asm management
Asmcmd into the corresponding directory, see whether have this file?
CD + DATAC1/XXXX/PASSWORD
Ls see PWDXXXX. 312.988645687