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
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
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
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?
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?
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!!!