on 01-24-2008 8:59 AM
Dear Friends,
I am trying to take online backup by DB13 of my CRM Dev system but it is ended with error , but when i check in SM37 it show finished.
By using BRTOOLS it work proparly but not by DB13.
Other Details :-
OS :- Win 2003 server
DB :- Oracle 10g
error message is :-
-
Detail log: bdxbnwwr.ant
BR0051I BRBACKUP 7.00 (26)
BR0055I Start of database backup: bdxbnwwr.ant 2008-01-19 10.48.21
BR0484I BRBACKUP log file: F:\oracle\CD1\sapbackup\bdxbnwwr.ant
BR0252W Function remove() failed for 'f:\oracle\cd1\102\database\sap.ora' at location BrInitOraCreate-1
BR0253W errno 13: Permission denied
BR0252W Function remove() failed for 'f:\oracle\cd1\102\database\sap.ora' at location BrInitOraCopy-7
BR0253W errno 13: Permission denied
BR0166I Parameter 'control_files' not found in file f:\oracle\cd1\102\database\initCD1.ora - default assumed
BR0252E Function CreateFile() failed for 'G:\ORACLE\CD1\SAPDATA3\TEMP_1\TEMP.DATA1' at location BrFileStatGet-2
BR0253E errno 5: Access is denied.
BR0273E Determination of file status for G:\ORACLE\CD1\SAPDATA3\TEMP_1\TEMP.DATA1 failed
BR0314E Collection of information on database files failed
BR0056I End of database backup: bdxbnwwr.ant 2008-01-19 10.48.45
BR0280I BRBACKUP time stamp: 2008-01-19 10.48.45
BR0054I BRBACKUP terminated with errors
-
So please help on this issue and reply ASAP.
Thanks,
Regards,
Sachin Jadhav
BASIS
Hi,
check whether SIDadm user is part of dba group?
Make sure that directory or executables like SAPDBA,
BRBACKUP, BRARCHIVE, BRRESTORE, BRRECOVER, BRCONNECT
and BRTOOLS have correct authorizations
Please refer the snote: 113747.
Run the sapdaba role to update the proper authorizations
Oracle 10g: sqlplus /nolog @sapdba_role <SID>
(you can get it from \usr\sap\<SID>\SYS\exe\run folder)
what is output?
regards,
kaushal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello All
I had struggeled with this problem myself for weeks, but found the solution.
SAP Note 40730 - <SID>adm user cannot start database details the following steps that resolved this for me:
Change permissions of the oracle executable in the bin directory to match above requirments :
chown ora<SID> oracle
chgrp dba oracle
chmod 6755 oracle
It may also be worthwile to chech <SID>adm is in the dba group of
/etc/group.
grep dba /etc/group
I was then able to start a backup successfully.
Hope I can score my first few points with this.....
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Friends,
I m facing one problem while taking backup form db13. can sombuddy help me to solve this problem following is the log file details
Job started
Step 001 started (program RSDBAJOB, variant &0000000000011, user ID BASIS)
Execute logical command BRBACKUP On host eccqa
Parameters:-u / -jid FLLOG20081015143102 -c force -t online -m full -p initIEQ.sap.wed -a -c force -p initIEQ.s
ap.wed -s
BR0051I BRBACKUP 7.00 (32)
BR0055I Start of database backup: bdzapxni.fnd 2008-10-15 14.31.02
BR0484I BRBACKUP log file: /oracle/IEQ/sapbackup/bdzapxni.fnd
BR0280I BRBACKUP time stamp: 2008-10-15 14.31.02
BR0301E SQL error -27140 at location BrDbConnect-2, SQL statement:
'CONNECT /'
ORA-27140: attach to post/wait facility failed
BR0310E Connect to database instance IEQ failed
BR0280I BRBACKUP time stamp: 2008-10-15 14.31.02
BR0301E SQL error -27140 at location BrDbConnect-2, SQL statement:
'CONNECT /'
ORA-27140: attach to post/wait facility failed
BR0310E Connect to database instance IEQ failed
BR0056I End of database backup: bdzapxni.fnd 2008-10-15 14.31.02
BR0280I BRBACKUP time stamp: 2008-10-15 14.31.02
BR0054I BRBACKUP terminated with errors
BR0280I BRBACKUP time stamp: 2008-10-15 14.31.02
BR0291I BRARCHIVE will be started with options '-U -jid FLLOG20081015143102 -d disk -c force -p initIEQ.sap.wed -s'
BR0002I BRARCHIVE 7.00 (32)
BR0006I Start of offline redo log processing: adzapxni.sve 2008-10-15 14.31.02
BR0484I BRARCHIVE log file: /oracle/IEQ/saparch/adzapxni.sve
BR0280I BRARCHIVE time stamp: 2008-10-15 14.31.02
BR0301W SQL error -27140 at location BrDbConnect-2, SQL statement:
'CONNECT /'
ORA-27140: attach to post/wait facility failed
BR0310W Connect to database instance IEQ failed
BR0280I BRARCHIVE time stamp: 2008-10-15 14.31.02
BR0301W SQL error -27140 at location BrDbConnect-2, SQL statement:
'CONNECT /'
ORA-27140: attach to post/wait facility failed
BR0310W Connect to database instance IEQ failed
BR0278W Command output of '/oracle/IEQ/102_64/bin/sqlplus /nolog < /oracle/IEQ/saparch/.adzapxni.spi':
SQL*Plus: Release 10.2.0.2.0 - Production on Wed Oct 15 14:31:02 2008
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> Connected to an idle instance.
SQL>
SQL> ORA-01034: ORACLE not available
SQL> Disconnected
BR0280I BRARCHIVE time stamp: 2008-10-15 14.31.02
BR0279W Return code from '/oracle/IEQ/102_64/bin/sqlplus /nolog < /oracle/IEQ/saparch/.adzapxni.spi': 0
BR0302W SQLPLUS call for database instance IEQ failed
BR0323W 'Archive log list' for database instance IEQ failed
BR0252E Function fopen() failed for '/oracle/IEQ/saparch/archIEQ.log' at location arch_last_get-1
BR0253E errno 13: Permission denied
BR0016I 0 offline redo log files processed, totalsize 0.000 MB
BR0280I BRARCHIVE time stamp: 2008-10-15 14.31.02
BR0301W SQL error -27140 at location BrDbConnect-2, SQL statement:
'CONNECT /'
ORA-27140: attach to post/wait facility failed
BR0310W Connect to database instance IEQ failed
BR0252W Function fopen() failed for '/oracle/IEQ/saparch/archIEQ.log' at location BrCleanup-8
BR0253W errno 13: Permission denied
BR0121W Processing of log file /oracle/IEQ/saparch/archIEQ.log failed
BR0007I End of offline redo log processing: adzapxni.sve 2008-10-15 14.31.02
BR0280I BRARCHIVE time stamp: 2008-10-15 14.31.02
BR0005I BRARCHIVE terminated with errors
BR0280I BRBACKUP time stamp: 2008-10-15 14.31.02
BR0292I Execution of BRARCHIVE finished with return code 3
External program terminated with exit code 3
BRBACKUP returned error status E
Job finished
it showing me above messege every time ..
Thanks
Vijay
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks,
my problem has been resolved and updated in forum.
Thanks again to all for support.
Regards,
Sachin Jadhav
BASIS
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Friends,
My problem has been resolved by just adding user permission to error file by comparing to other server (WIn 2003 server).
So thanks for your response showing
Regards,
Sachin JAdhav
BASIS
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Sachin,
i also have the same error, when i take online backup (schedule backup) of QAS through BR Tools then the error comes
BR0301E SQL ERROR-1017 AT location BR DBCONNECT-2, SQL statement, and ORA-01017: Invalid username/password, login denied.
BR0310E CONNECT TO DATABASE INSTANCE QAS failed.
Dear sachin, this error is not appear before as i take through this backup since 04 to 05 months, but now this error occurs when i see through dbacockpit.
Regards,
Yasir
Dear Sachin,
i also have the same error, when i take online backup (schedule backup) of QAS through BR Tools then the error comes
BR0301E SQL ERROR-1017 AT location BR DBCONNECT-2, SQL statement, and ORA-01017: Invalid username/password, login denied.
BR0310E CONNECT TO DATABASE INSTANCE QAS failed.
Dear sachin, this error is not appear before as i take through this backup since 04 to 05 months, but now this error occurs when i see through dbacockpit.
Regards,
Yasir
Hi Frined,
But how can i check "check whether SIDadm user is part of dba group?"
Also "Make sure that directory or executables like SAPDBA, BRBACKUP, BRARCHIVE, BRRESTORE, BRRECOVER, BRCONNECT and BRTOOLS have correct authorizations Please refer the snote: 113747.
" it is related to unix platform and out platform is WIn 2003 server
Can i run "sqlplus /nolog @sapdba_role" directly on commond prompt
OS :- Win 2003 server
DB :- Oracle 10g
Please reply,
Thanks,
Regards,
Sachin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
The error that was reported is:
BR0252W Function remove() failed for 'f:\oracle\cd1\102\database\sap.ora' at location BrInitOraCreate-1
BR0253W errno 13: Permission denied
BR0252W Function remove() failed for 'f:\oracle\cd1\102\database\sap.ora' at location BrInitOraCopy-7
BR0253W errno 13: Permission denied
BR0166I Parameter 'control_files' not found in file f:\oracle\cd1\102\database\initCD1.ora - default assumed
BR0252E Function CreateFile() failed for 'G:\ORACLE\CD1\SAPDATA3\TEMP_1\TEMP.DATA1' at location BrFileStatGet-2
BR0253E errno 5: Access is denied.
Those are OS errors, running sapdba_role will NOT help.
What you have to check is if the user that is running the BRTOOLS have proper authorizations on the files/direcories indicated.
Which user are you connected as?
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.