on 06-28-2011 3:45 AM
Hello , The Hp DP team has done integration of our SAP application server with Hp DP software. However when we check with DB13 transaction we gets following error.,. We have modified initSID.sap file to take backup on disk . Does we need to change anything else tohave ful backup in DB13.
R0278E Command output of 'SHELL=/bin/sh /oracle/GPR/102_64/bin/rman nocatalog':ecovery Manager: Release 10.2.0.4.0 - Production on Mon Jun 27 21:05:51 2011opyright (c) 1982, 2007, Oracle. All rights reserved.MAN>MAN> connect target *onnected to target database: GPR (DBID=125161044, not open)sing target database control file instead of recovery catalogMAN> *end-of-file*MAN>ost command completeMAN> 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> 35> 36> 37> 38> 39> 40> 41> 42> 43> 44> 45>MAN-00571: ===========================================================MAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============MAN-00571: ===========================================================MAN-03009: failure of catalog command on default channel at 06/27/2011 21:05:54RA-19564: error occurred writing 8192 bytes at block number 1RA-27091: unable to queue I/ORA-27041: unable to open filePUX-ia64 Error: 13: Permission denieddditional information: 3MAN>ecovery Manager complete.R0280I BRBACKUP time stamp: 2011-06-27 21.05.54R0279E Return code from 'SHELL=/bin/sh /oracle/GPR/102_64/bin/rman nocatalog': 1R0536E RMAN call for database instance GPR failedR0280I BRBACKUP time stamp: 2011-06-27 21.05.54R0532E Cataloging backups of all database files failed
please suggest.
regards
Dharm
Hi,
I believe in the BRBACKUP command you are using rman_util or rman_disk command. Please go through the below link:
http://help.sap.com/saphelp_nw70ehp1/helpdata/en/25/9fa5ec79fa8e42ba0c71dea91a18df/frameset.htm
Try to run the BRbackup command from the OS level and see.
If you are using RMAN, you have to create a catalog database and register it and then allocate channels.
Regards,
SBK
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hai...
This Parameter in the file initSID.sap will be different for both the case, there you have to change
the parameter, It will be
backup_dev_type = util_file for the case of HP DP
backup_dev_type = tape for the case of DB13
Note: check the owner should be ora<sid> dba.
Cheers
KHS
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Hari ,
I have tried both way and when i am trying to take on disk with backup_dev_type= disk , i am getting some permission error as mentioned in error above of which i am not sure. Moreover , why still the RMAN is getting called up ?
I am not getting any clue of this error with the configuration of initSID.sap file or is it something related to HP DP software integration.
Regards
Edited by: Singh Dharm on Jun 28, 2011 8:06 AM
Hai...
Check the value for the parameter backup_root_dir = it should be the location where it is to be stored
eg: backup_root_dir = /backup/db13
then the permission for the /backup & db13 should be <SID>adm , sapsys and should have permission for read,write and also should have sufficient space.
KHS
Hi Hari ,
The parameters are proper in initSID.sap and even the backup root dir have proper rights. The backup is happening at the end of the backup the RMAN is getting called up . I am pretty sure that it is something related to HP DP software as before the integration the DB13 was working fine.
Here is the copy of initSID.sap fille.
http://s000.tinyupload.com/index.php?file_id=05695225809970124808
Regards
Dharm Singh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.