No question at this time
DBA Top 10
1 B. Vroman 16200
2 M. Cadot 10100
3 T. Boles 8150
4 J. Schnackenberg 7700
5 A. Kavsek 7000
6 M. Hidayathullah ... 3000
7 G. Lambregts 1100
7 P. Wisse 1100
9 T. P 1000
10 B. Derous 500
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48261
Total active users1615
Act. users last 24h3
Act. users last hour0
Registered user hits last week315
Registered user hits last month1260
Go up

rman backup failures
Next thread: select from v$sql hangs
Prev thread: startup failure

Message Score Author Date
Hi Guys We are experiencing issues all of a sud...... Tso P Jul 02, 2018, 09:45
Somebody changed the permissions of the oracle/rma...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Rob Pattyn Jul 02, 2018, 11:39
Thanks Rob It was McaFee anti virus that was pr...... Score: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 Pts Tso P Jul 02, 2018, 14:43

Follow up by mail Click here


Subject: rman backup failures
Author: Tso P, South Africa
Date: Jul 02, 2018, 09:45, 80 days ago
Os info: Red Hat Enterprise Linux Server release 5.11 (Tikanga)
Oracle info: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
Message: Hi Guys

We are experiencing issues all of a sudden, we have rman backup that run every night. Now, the backup is failing with the below error:

ORA-19504: failed to create file "/oradata/flash_recovery_area/ORCL/backupset/2018_06_22/o1_mf_nnndf_TAG20180622T180058_%u_.bkp"
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied

I have decided to do a backup of a datafile to a different filesystem as a test.

Below is the errors:

RMAN-03009: failure of backup command on disk1 channel at 07/02/2018 09:20:34
ORA-19504: failed to create file "/tmp/test_bk/evt6vrv1_1_1"
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 2

I can touch a file and spool files in both these directories.

But when rman try to write a file during backup I get these errors.

Please Help!!!

Thanks in advance...
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: rman backup failures
Author: Rob Pattyn, Belgium
Date: Jul 02, 2018, 11:39, 80 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Somebody changed the permissions of the oracle/rman user?
Under what account is the rmanbackup started?
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: rman backup failures
Author: Tso P, South Africa
Date: Jul 02, 2018, 14:43, 80 days ago
Score:   Score: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 Pts
Message: Thanks Rob

It was McaFee anti virus that was preventing rman to run backups.

We had to disable the scan and now the backups are running fine.

Thanks for the reply.

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here