Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

BRBACKUP ENDED WITH ERRORS

Unable to schedule the full online backup on our production server.I have paste the logs below can any one help.?

Job started

Step 001 started (program RSDBAJOB, variant &0000000000007, user ID ADMIN)

Execute logical command BRBACKUP On host ora-pro

Parameters:-u / -jid ALLOG20110601231705 -c force -t online -m all -p initPRO_Disk.sap -a -c force -p initPRO_D

isk.sap -s

BR0051I BRBACKUP 7.00 (40)

BR0055I Start of database backup: begaalyg.and 2011-06-01 23.17.06

BR0484I BRBACKUP log file: /oracle/PRO/sapbackup/begaalyg.and

BR0477I Oracle pfile /oracle/PRO/102_64/dbs/initPRO.ora created from spfile /oracle/PRO/102_64/dbs/spfilePRO.ora

BR0280I BRBACKUP time stamp: 2011-06-01 23.17.06

BR0319I Control file copy created: /oracle/PRO/sapbackup/cntrlPRO.dbf 13844480

BR0066E For online backup, the database must be in ARCHIVELOG mode

BR0056I End of database backup: begaalyg.and 2011-06-01 23.17.06

BR0280I BRBACKUP time stamp: 2011-06-01 23.17.06

BR0054I BRBACKUP terminated with errors

BR0280I BRBACKUP time stamp: 2011-06-01 23.17.06

BR0291I BRARCHIVE will be started with options '-U -jid ALLOG20110601231705 -d disk -c force -p initPRO_Disk.sap -s'

BR0002I BRARCHIVE 7.00 (40)

BR0006I Start of offline redo log processing: aegaalyg.sve 2011-06-01 23.17.06

BR0484I BRARCHIVE log file: /oracle/PRO/saparch/aegaalyg.sve

BR0477I Oracle pfile /oracle/PRO/102_64/dbs/initPRO.ora created from spfile /oracle/PRO/102_64/dbs/spfilePRO.ora

BR0252E Function fopen() failed for '/oracle/PRO/saparch/archPRO.log' at location arch_last_get-1

BR0253E errno 13: Permission denied

BR0016I 0 offline redo log files processed, totalsize 0.000 MB

BR0252W Function fopen() failed for '/oracle/PRO/saparch/archPRO.log' at location BrCleanup-8

BR0253W errno 13: Permission denied

BR0121W Processing of log file /oracle/PRO/saparch/archPRO.log failed

BR0007I End of offline redo log processing: aegaalyg.sve 2011-06-01 23.17.07

BR0280I BRARCHIVE time stamp: 2011-06-01 23.17.07

BR0005I BRARCHIVE terminated with errors

BR0280I BRBACKUP time stamp: 2011-06-01 23.17.07

BR0292I Execution of BRARCHIVE finished with return code 3

External program terminated with exit code 3

BRBACKUP returned error status E

Job finished

Can any tell me what permission need to be given to which folder...??

Edited by: letzfriend on Jun 1, 2011 11:15 PM

Former Member
Former Member replied

Hi Liz,

It is clearly saying that the database should be archive log mode

BR0280I BRBACKUP time stamp: 2011-06-01 23.17.06

BR0319I Control file copy created: /oracle/PRO/sapbackup/cntrlPRO.dbf 13844480

BR0066E For online backup, the database must be in ARCHIVELOG mode

Enable archivelogs in database with the following procedure ..

schedule a outage .. shutdown all applications .. and do a shutdown of database

SQL> shutdown immediate

now check status of archive log

SQl> archive log list;

it will be in disabled state .. now start database in mount

SQL> startup mount

now setup archive logs

SQL> alter database archivelog;

open database

SQL> alter database open;

now check with the command

SQL> archive log list;

now the status will be enabled. Start all applications and listener and schedule the backup

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question