Oracle BACKUP failed.

Hello.
I have Oracle DB 10.0.2 on OS Sles 10
I make every day backup on type drive. But from yestarday the archive is failed. I was only restart the DB. I not change the permissions, not install new software,patches, updates and etc.. I read many manuals for this error but cant find the reason.
Here I paste the error.


Thanks for all!!!
-------------------------------------------------------------------

24.04.2008 10:10:49 BR0317I 'Alter tablespace SYSTEM end backup'
successful
24.04.2008 10:10:49
24.04.2008 10:10:49 BR0280I BRBACKUP time stamp: 2008-04-24 10.10.36
24.04.2008 10:10:49 BR0530I Cataloging backups of all database
files...
24.04.2008 10:10:49 BR0278E Command output of 'SHELL=/bin/sh
/oracle/BLP/102_32/bin/rman nocatalog':
24.04.2008 10:10:49 Copyright (c) 1982, 2005, Oracle. All rights
reserved.
24.04.2008 10:10:49 RMAN>
24.04.2008 10:10:49 RMAN> connect target *
24.04.2008 10:10:49 connected to target database: BLP (DBID=73553200)
24.04.2008 10:10:49 using target database control file instead of
recovery catalog
24.04.2008 10:10:49 RMAN> **end-of-file**
24.04.2008 10:10:49 RMAN>
24.04.2008 10:10:49 host command complete
24.04.2008 10:10:49
24.04.2008 10:10:49 RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13>
14>15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31>
32> 33> 34
24.04.2008 10:10:49 RMAN-00571:
===========================================================
24.04.2008 10:10:49 RMAN-00569: =============== ERROR MESSAGE
STACK FOLLOWS ===============
24.04.2008 10:10:49 RMAN-00571:
===========================================================
24.04.2008 10:10:49 RMAN-03009: failure of catalog command on
defaultchannel at 04/24/2008 10:10:39
24.04.2008 10:10:49 ORA-19564: error occurred writing 8192 bytes
at block number 1
24.04.2008 10:10:49 ORA-27091: unable to queue I/O
24.04.2008 10:10:49 ORA-27041: unable to open file
24.04.2008 10:10:49 Linux Error: 13: Permission denied
24.04.2008 10:10:49 Additional information: 3
24.04.2008 10:10:49
24.04.2008 10:10:49 RMAN>
24.04.2008 10:10:49
24.04.2008 10:10:49 Recovery Manager complete.
24.04.2008 10:10:49 BR0280I BRBACKUP time stamp: 2008-04-24 10.10.39
24.04.2008 10:10:49 BR0279E Return code from 'SHELL=/bin/sh
/oracle/BLP/102_32/bin/rman nocatalog': 1
24.04.2008 10:10:49 BR0536E RMAN call for database instance BLP failed
24.04.2008 10:10:49
24.04.2008 10:10:49 BR0280I BRBACKUP time stamp: 2008-04-24 10.10.39
24.04.2008 10:10:49 BR0532E Cataloging backups of all database
files failed
24.04.2008 10:10:49
24.04.2008 10:10:49 BR0056I End of database backup: bdxtrtem.fnt
2008-04-24 10.10.39
24.04.2008 10:10:49 BR0280I BRBACKUP time stamp: 2008-04-24 10.10.49
24.04.2008 10:10:49 BR0054I BRBACKUP terminated with errors
24.04.2008 10:10:49 External program terminated with exit code 5
24.04.2008 10:10:49 BRBACKUP returned error status E

Check permissions on directories your channels are formatted to:


Linux Error: 13: Permission denied :rolleyes:

Where are this channels ?
Thanks a lot :-)
"I make every day backup on type drive. But from yestarday the archive is failed. I was only restart the DB. I not change the permissions, not install new software,patches, updates and etc.."

Normally they reside in the rman catalog -- but you are not using catalog.

Apparently you are using the SAP BR utility, therefore you may need to find out where is the rman script that is being executed and/or look at the configuration files under $OH/dbs/init{sid}.sap ;)

Hello.
I find many files to *.sap , and I don't know who is the file with wrong permissions.
Here attach screenshot.
Thanks for all.
The group is "sapsys" , and fileowner is "blpadm - sap system administrator" - 777.
Thats true?

Quote:

---

... I was only restart the DB. ...

---

Make sure you are executing the script as 'Oracle' account. :cool:

I have 2 scripts - start and stop.

stopscript is:
su blspadm -c "/sapmnt/BLP/exe/stopsap"

----
startscript is:
su orablp -c "lsnrctl start"
su blpadm -c "startdb"
su blpadm -c "/sapmnt/BLP/exe/startsap"

----
Before I run stopscript, after startscript and try to make backup , but the error is this.
So , however.
On who user or file the permissions you tell me to see and change it?

Thanks a lot for everything!

Looks like you need this user:

Code:

---

su orablp -c "startdb"

---

;)

Quote:

---

Originally Posted by LKBrwn_DBA

Looks like you need this user:

Code:

---

su orablp -c "startdb"

---

;)

---

Ok. I now try it.
Change the user who run the DB , RUN the SAP and run the Backup ot type drive.
The make archive is long proccess and I write tomorrow whats are the results.
Thanks a lot!
Have a nice day (or night :-P )

P.S. The question is - how is work before???
But now is not?! I`m not change anything!!!

The error is same :-(
Do you have other ideas?


30.04.2008 18:13:46 #FILE..... /oracle/BLP/sapdata1/system_1/system.data1
30.04.2008 18:13:46
30.04.2008 18:13:46 BR0280I BRBACKUP time stamp: 2008-04-30 18.13.33
30.04.2008 18:13:46 BR0063I 33 of 33 files processed - 92090.258 MB of 92090.258 MB done
30.04.2008 18:13:46 BR0204I Percentage done: 100.00%, estimated end time: 18:13
30.04.2008 18:13:46
30.04.2008 18:13:46 BR0280I BRBACKUP time stamp: 2008-04-30 18.13.33
30.04.2008 18:13:46 BR0317I 'Alter tablespace SYSTEM end backup' successful
30.04.2008 18:13:46
30.04.2008 18:13:46 BR0280I BRBACKUP time stamp: 2008-04-30 18.13.35
30.04.2008 18:13:46 BR0530I Cataloging backups of all database files...
30.04.2008 18:13:46 BR0278E Command output of 'SHELL=/bin/sh /oracle/BLP/102_32/bin/rman nocatalog':
30.04.2008 18:13:46
30.04.2008 18:13:46 Recovery Manager: Release 10.2.0.2.0 - Productionon Wed Apr 30 18:13:36 2008
30.04.2008 18:13:46
30.04.2008 18:13:46 Copyright (c) 1982, 2005, Oracle. All rights reserved.
30.04.2008 18:13:46
30.04.2008 18:13:46 RMAN>
30.04.2008 18:13:46 RMAN> connect target *
30.04.2008 18:13:46 connected to target database: BLP (DBID=73553200)
30.04.2008 18:13:46 using target database control file instead of recovery catalog
30.04.2008 18:13:46
30.04.2008 18:13:46 RMAN> **end-of-file**
30.04.2008 18:13:46
30.04.2008 18:13:46 RMAN>
30.04.2008 18:13:46 host command complete
30.04.2008 18:13:46
30.04.2008 18:13:46 RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14>15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34
30.04.2008 18:13:46 RMAN-00571: ===========================================================
30.04.2008 18:13:46 RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
30.04.2008 18:13:46 RMAN-00571: ===========================================================
30.04.2008 18:13:46 RMAN-03009: failure of catalog command on defaultchannel at 04/30/2008 18:13:39
30.04.2008 18:13:46 ORA-19564: error occurred writing 8192 bytes at block number 1
30.04.2008 18:13:46 ORA-27091: unable to queue I/O
30.04.2008 18:13:46 ORA-27041: unable to open file
30.04.2008 18:13:46 Linux Error: 13: Permission denied
30.04.2008 18:13:46 Additional information: 3
30.04.2008 18:13:46
30.04.2008 18:13:46 RMAN>
30.04.2008 18:13:46
30.04.2008 18:13:46 Recovery Manager complete.
30.04.2008 18:13:46 BR0280I BRBACKUP time stamp: 2008-04-30 18.13.39
30.04.2008 18:13:46 BR0279E Return code from 'SHELL=/bin/sh /oracle/BLP/102_32/bin/rman nocatalog': 1
30.04.2008 18:13:46 BR0536E RMAN call for database instance BLP failed
30.04.2008 18:13:46 BR0280I BRBACKUP time stamp: 2008-04-30 18.13.39
30.04.2008 18:13:46 BR0532E Cataloging backups of all database files failed
30.04.2008 18:13:46 BR0056I End of database backup: bdxuwwyg.fnt 2008-04-30 18.13.39
30.04.2008 18:13:46 BR0280I BRBACKUP time stamp: 2008-04-30 18.13.46
30.04.2008 18:13:46 BR0054I BRBACKUP terminated with errors
30.04.2008 18:13:46 External program terminated with exit code 5
30.04.2008 18:13:46 BRBACKUP returned error status E

Quote:

---

.....
ORA-27041: unable to open file
Linux Error: 13: Permission denied
.....

---

It is still a "permissions" error, it is trying to write the backup to a directory where neither the 'orablp' or 'blpadm' account have permission(s).
:p