on 05-28-2009 8:14 AM
Hi Experts,
We are getting error during the redolog backup.I m paste the logs here for your ready refrence.
this is on ECC5.0 on AIX bascop08 3 5 00396F7C4C00 with database oracle 9.2.0.7.0
We would appreciate for your quick response towards corrective action.
BR0002I BRARCHIVE 6.40 (50)
BR0006I Start of offline redo log processing: aeardegy.svd 2009-05-28 07.08.28
BR0484I BRARCHIVE log file: /oracle/QBS/saparch/aeardegy.svd
BR0252W Function remove() failed for '/oracle/QBS/920_64/dbs/sap.ora' at location BrInitOraCreate-1
BR0253W errno 13: Permission denied
BR0252W Function fopen() failed for '/oracle/QBS/920_64/dbs/initQBS.ora' at location BrInitOraCopy-2
BR0253W errno 13: Permission denied
BR0101I Parameters
Name Value
oracle_sid QBS
oracle_home /oracle/QBS/920_64
oracle_profile /oracle/QBS/920_64/dbs/initQBS.ora
sapdata_home /oracle/QBS
sap_profile /oracle/QBS/920_64/dbs/initQBS.sap
backup_dev_type util_file
util_par_file /oracle/QBS/920_64/dbs/initQBS.utl
archive_dupl_del only
system_info oraqbs/oracbs bascop08 AIX 3 5 00396F7C4C00
oracle_info QBS 9.2.0.7.0 8192 423 5563906655
sap_info 640 SAPR3 QBS W1421187153 R3_ORA 0020121351
make_info rs6000_64 OCI_920 Oct 11 2008
command_line brarchive -u system/******** -c -d util_file -sd
BR0252E Function fopen() failed for '/oracle/QBS/saparch/archQBS.log' at location arch_last_get-1
BR0253E errno 13: Permission denied
BR0016I 0 offline redo log files processed, total size 0.000 MB
BR0252W Function fopen() failed for '/oracle/QBS/saparch/archQBS.log' at location BrCleanup-8
BR0253W errno 13: Permission denied
BR0121W Processing of log file /oracle/QBS/saparch/archQBS.log failed
BR0007I End of offline redo log processing: aeardegy.svd 2009-05-28 07.08.29
BR0280I BRARCHIVE time stamp: 2009-05-28 07.08.29
BR0005I BRARCHIVE terminated with errors
Hi,
I am taking offline backup iam getting error :
Returncode : 0005 error during processing .OS is AIX and DB is oracle.can any one guide me for to solve this error.
BR0280I BRBACKUP time stamp: 2010-11-06 02.15.42
BR0063I 32 of 33 files processed - 79001.775 MB of 79006.924 MB done
BR0204I Percentage done: 99.99%, estimated end time: 2:15
BR0001I **************************************************
BR0202I Saving /oracle/PRD/origlogA/cntrl/cntrlPRD.dbf
BR0203I to /dev/rmt0.1 ...
#FILE..... /oracle/PRD/origlogA/cntrl/cntrlPRD.dbf
#SAVED.... cntrlPRD.dbf PRDB05/36
BR0280I BRBACKUP time stamp: 2010-11-06 02.15.45
BR0063I 33 of 33 files processed - 79006.924 MB of 79006.924 MB done
BR0204I Percentage done: 100.00%, estimated end time: 2:15
BR0001I **************************************************
BR0280I BRBACKUP time stamp: 2010-11-06 02.15.47
BR0304I Starting and opening database instance PRD ...
BR0280I BRBACKUP time stamp: 2010-11-06 02.16.34
BR0305I Start and open of database instance PRD successful
BR0117I ARCHIVE LOG LIST after backup for database instance PRD
Parameter Value
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oracle/PRD/oraarch/PRDarch
Archive format %t_%s.dbf
Oldest online log sequence 9812
Next log sequence to archive 9815
Current log sequence 9815 SCN: 156140548
Database block size 8192 Thread: 1
BR0056I End of database backup: beemrney.afp 2010-11-06 02.16.34
BR0280I BRBACKUP time stamp: 2010-11-06 02.16.36
BR0052I BRBACKUP completed successfully
BR0280I BRBACKUP time stamp: 2010-11-06 02.16.36
BR0291I BRARCHIVE (action ID aeemrney) will be started with options '+beemrney.afp,19628058347,PRDB05,33:286938 -d pipe -c force -p initPR
BR0280I BRBACKUP time stamp: 2010-11-06 02.35.03
BR0292I Execution of BRARCHIVE (action ID aeemrney) finished with return code 5
thank you
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
> BR0002I BRARCHIVE 6.40 (50)
> BR0006I Start of offline redo log processing: aeardegy.svd 2009-05-28 07.08.28
> BR0484I BRARCHIVE log file: /oracle/QBS/saparch/aeardegy.svd
> BR0252W Function remove() failed for '/oracle/QBS/920_64/dbs/sap.ora' at location BrInitOraCreate-1
>
> BR0253W errno 13: Permission denied
>
> BR0252W Function fopen() failed for '/oracle/QBS/920_64/dbs/initQBS.ora' at location BrInitOraCopy-2
>
> BR0253W errno 13: Permission denied
make sure the owner of brarchive in the kernel directory is ora<SID> and that the s-bit is set (or simply execute "./saproot.sh <SID>" in the kernel directory).
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Same message raised by shisir
Check Permission of archived file which is giving error .
It can be happen archive file not filled by arcn process supplied by online redolog file.
You can take online archive backup again only with -s option .
For Br error code and action see Snote -17163.
Check Your userID,UserGroup which you r using for brarchive.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
seems to be permission issue, check the permissions/owner for brarchive
Note 113747 - Permissions for DBA tools BR*Tools and SAPDBA
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
as per logs,
two reasons possible,
permission/owner the tool or permission/owner of the target on which this tool is trying to act
as per Note, you could check the permission and owner of brtools, brarchive etc by going into exe directory
at os, as sidadm, type
cdexe or cd /sapmnt/SID/exe
ls -l brarchive
and check ther permission and owner, should be good as per Note, otherwise change them manually by chmod or chown or run saproot.sh SID, which automatically adjusts the permissions for these
and other alternative, check permission/owner of /oracle/SID/saparch, should be orasid and with dba group, as already suggested by Prasanna
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.