Online backup fail through DB13

[Former Member]

Dear experts,

I am using sap BW 7.4 under oracle 11.0.2.4

I am trying to take online backup on disk

I select action whole database online backup + redo file backup as will as

Full database online backup and BRACHIVE function is -sd

but  backup was failed I am unable to resolve it  following are logs generated during backup

#SAVED.... /oracle/online/beokvzrl/system.data1  #1/17

BR0280I BRBACKUP time stamp: 2014-08-02 10:58:20

BR0063I 17 of 17 files processed - 51610.133 of 51610.133 MB done

BR0204I Percentage done: 100.00%, estimated end time: 10:58

BR0001I **************************************************

BR0280I BRBACKUP time stamp: 2014-08-02 10:58:20

BR0317I 'Alter tablespace SYSTEM end backup' successful

BR0252W Function kill() failed for '17891582:15' at location BrKill-3

BR0253W errno 3: No such process

BR0278I Command output of '/usr/sap/BWD/SYS/exe/run/brconnect':

BR0801I BRCONNECT 7.40 (6)

PID=17891582

BR0252E Function fopen() failed for '/oracle/BWD/sapbackup/.user.pas' at location global_set-1

BR0253E errno 13: Permission denied

BR0074W BRCONNECT call failed

BR0280I BRBACKUP time stamp: 2014-08-02 10:58:22

BR0530I Cataloging backups of all database files...

BR0278E Command output of 'SHELL=/bin/sh /oracle/BWD/112_64/bin/rman nocatalog':

Recovery Manager: Release 11.2.0.4.0 - Production on Sat Aug 2 10:58:23 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

RMAN>

RMAN> connect target *

connected to target database: BWD (DBID=2340275772)

using target database control file instead of recovery catalog

RMAN> **end-of-file**

RMAN>

host command complete

RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19>

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03009: failure of catalog command on default channel at 08/02/2014 10:58:25

ORA-19564: error occurred writing 8192 bytes at block number 1

ORA-27091: unable to queue I/O

ORA-27041: unable to open file

IBM AIX RISC System/6000 Error: 13: Permission denied

Additional information: 3

Additional information: 4

Additional information: 4194434

RMAN>

Recovery Manager complete.

BR0280I BRBACKUP time stamp: 2014-08-02 10:58:25

BR0279E Return code from 'SHELL=/bin/sh /oracle/BWD/112_64/bin/rman nocatalog': 1

BR0536E RMAN call for database instance BWD failed

BR0200I BR_TRACE: location BrRmanCall-56, commands for RMAN in: /oracle/BWD/sapbackup/.beokvzrl.cmd

@/oracle/BWD/sapbackup/..beokvzrl..cmd

host '/usr/sap/BWD/SYS/exe/run/brtools -f delete /oracle/BWD/sapbackup/..beokvzrl..cmd';

catalog datafilecopy

'/oracle/online/beokvzrl/sr3.data1',

'/oracle/online/beokvzrl/sr3.data2',

'/oracle/online/beokvzrl/sr3.data3',

'/oracle/online/beokvzrl/sr3.data4',

'/oracle/online/beokvzrl/sr3.data5',

'/oracle/online/beokvzrl/sr3.data6',

'/oracle/online/beokvzrl/sr3740.data1',

'/oracle/online/beokvzrl/sr3740.data2',

'/oracle/online/beokvzrl/sr3740.data3',

'/oracle/online/beokvzrl/sr3740.data4',

'/oracle/online/beokvzrl/sr3740.data5',

'/oracle/online/beokvzrl/sr3740x.data1',

'/oracle/online/beokvzrl/sr3740x.data2',

'/oracle/online/beokvzrl/sr3usr.data1',

'/oracle/online/beokvzrl/undo.data1',

'/oracle/online/beokvzrl/sysaux.data1',

'/oracle/online/beokvzrl/system.data1'

level 0 tag beokvzrl;

exit;

BR0280I BRBACKUP time stamp: 2014-08-02 10:58:25

BR0532E Cataloging backups of all database files failed

BR0056I End of database backup: beokvzrl.fnd 2014-08-02 10:58:25

BR0280I BRBACKUP time stamp: 2014-08-02 10:58:25

BR0054I BRBACKUP terminated with errors

BR0280I BRBACKUP time stamp: 2014-08-02 10:58:25

I am unable to understand why RMAN is use ?

and what parameters are used when I will take backup on tape

Kindly guide me

Regards

[divyanshu_srivastava3 · Accepted solution]

Two things you need to check 1st

1. Brtools profile - initsid.sap

2. File system permission and kernel br*  files permissions

Divyanshu

[Former Member · Accepted solution]

Dear Srivastava for your reply,

I download latest brtools patch and apply it and change authorization  profile parameters is also OK ( I run whole database online backup from brtools using same profile it done successfully )

full permission ( 777) in sapbackup folder and sub folder but through db13 backup is successfully with warning

BR0204I Percentage done: 100.00%, estimated end time: 11:57

BR0001I **************************************************

BR0252W Function kill() failed for '10420324:15' at location BrKill-3

BR0253W errno 3: No such process

BR0278I Command output of '/usr/sap/BWD/SYS/exe/run/brconnect':

BR0801I BRCONNECT 7.40 (10)

PID=10420324

BR0252E Function fopen() failed for '/oracle/BWD/sapbackup/.user.pas' at location global_set-1

BR0253E errno 13: Permission denied

BR0074W BRCONNECT call failed

BR0280I BRBACKUP time stamp: 2014-08-04 11:57:59

BR0340I Switching to the next online redolog file for database instance BWD ...

BR0321I Switch to the next online redolog file for database instance BWD successful

BR0117I ARCHIVE LOG LIST after backup for database instance BWD

Parameter                      Value

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            /oracle/BWD/oraarch/BWDarch

Archive format                 %t_%s_%r.dbf

Oldest online log sequence     838

Next log sequence to archive   841

Current log sequence           841              SCN: 28074154

Database block size            8192             Thread: 1

Current system change number   28074155         ResetId: 842452156

BR0202I Saving space_log

BR0203I to /oracle/bck/online/BWD ...

BR0202I Saving /oracle/BWD/sapbackup/beolgapq.and

BR0203I to /oracle/bck/online/BWD ...

BR0202I Saving /oracle/BWD/sapbackup/backBWD.log

BR0203I to /oracle/bck/online/BWD ...

BR0056I End of database backup: beolgapq.and 2014-08-04 11:58:01

BR0280I BRBACKUP time stamp: 2014-08-04 11:58:01

BR0053I BRBACKUP completed successfully with warnings or non-fatal errors

1. BR0252W Function kill() failed for '10420324:15' at location BrKill-3

    BR0253W errno 3: No such process

2. BR0252E Function fopen() failed for '/oracle/BWD/sapbackup/.user.pas' at location  global_set-1

BR0253E errno 13: Permission denied

BR0074W BRCONNECT call failed

why it backup not open file .user.pas ( it is not exist in this folder )

Kindly guide me

Regards

[willi_eimler · Accepted solution]

Hi Shahid,

this sounds strange because permission 777 should work.

But please take a look at your br-files. They should look like this:

-rwsrwxr--  1 orasid   sapsys    10022600 Aug 23 2012  brarchive

-rwsrwxr--  1 orasid   sapsys    10251536 Aug 23 2012  brbackup

-rwsrwxr--  1 orasid   sapsys    12179560 Aug 23 2012  brconnect

-rwxr-xr-x  1 sidadm   sapsys    10708840 Aug 23 2012  brrecover

-rwxr-xr-x  1 sidadm   sapsys     4140576 Aug 23 2012  brrestore

-rwxr-xr-x  1 sidadm   sapsys    12778384 Aug 23 2012  brspace

-rwxr-xr-x  1 sidadm   sapsys     4711664 Aug 23 2012  brtools

In Note

113747  - Owners and authorizations for BR*Tools            

You can find the statements you neeed. Please try it and give us response.

Best regards

Willi Eimler

[divyanshu_srivastava3 · Accepted solution]

Hi Shahid,

Now check on permission part with below notes:

113747 - Owners and authorizations for BR*Tools

651351 - BR tools on UNIX: Error due to executable permissions

Divyanshu

[Former Member · Accepted solution]

Hi,

It clearly says you have permission issue with br* components.

BR0278I Command output of '/usr/sap/BWD/SYS/exe/run/brconnect':
BR0801I BRCONNECT 7.40 (10)
PID=10420324
BR0252E Function fopen() failed for '/oracle/BWD/sapbackup/.user.pas' at location global_set-1
BR0253E errno 13: Permission denied

As said above, go through the note 113747 and give proper permissions to the br* components.

Regards,

Nick Loy

[Former Member]

Dear

ORA-19564: error occurred writing 8192 bytes at block number 1

ORA-27091: unable to queue I/O

ORA-27041: unable to open file

IBM AIX RISC System/6000 Error: 13: Permission denied

Additional information: 3

Additional information: 4

the above log shows it is an issue with permissions and permission should be 775 rwx then it will go

Regards

[Former Member]

My offline backup is successfully completed but online backup has issue now I want to take offline backup in tape , tape initialization error

Job started

Step 001 started (program RSDBAJOB, variant &0000000000035, user ID BWDBASIS)

Execute logical command BRBACKUP On host BWDEV

Parameters:-jid TAPIN20140805161238 -u / -i force -c force -n 1 -v SCRATCH

BR0051I BRBACKUP 7.40 (10)

BR0055I Start of database backup: beollvud.tib 2014-08-05 16:12:39

BR0484I BRBACKUP log file: /oracle/BWD/sapbackup/beollvud.tib

BR0477I Oracle pfile /oracle/BWD/112_64/dbs/initBWD.ora created from spfile /oracle/BWD/112_64/dbs/spfileBWD.ora

BR0205I Backup volume initialization

BR0058I BRBACKUP action ID: beollvud

BR0059I BRBACKUP function ID: tib

BR0102I Following backup device will be used: /dev/rmt0.1

BR0131I All volumes get the name SCRATCH

BR0129I Force option set - no label checking during initialization

BR0134I Unattended mode with 'force' active - no operator confirmation allowed

BR0207I Volume in device: /dev/rmt0.1 will be initialized with name: SCRATCH

BR0280I BRBACKUP time stamp: 2014-08-05 16:12:39

BR0226I Rewinding tape volume in device /dev/rmt0...

BR0278E Command output of 'LANG=C tctl -f /dev/rmt0 rewind':

/dev/rmt0: I/O error

BR0280I BRBACKUP time stamp: 2014-08-05 16:12:58

BR0279E Return code from 'LANG=C tctl -f /dev/rmt0 rewind': 2

BR0213E Winding tape volume in device /dev/rmt0.1failed

BR0219E Initialization of volume SCRATCH in device /dev/rmt0.1 failed

BR0206I End of backup volume initialization

BR0280I BRBACKUP time stamp: 2014-08-05 16:12:58

BR0054I BRBACKUP terminated with errors

External program terminated with exit code 3

BRBACKUP returned error status E

Job finished

Kindly help

Regards

[divyanshu_srivastava3]

Hi,

If your old issue is resolved please mark and close this thread. Open a new with new issue. It's easy and goid for future references.

Also, we are looking into your new issue, so no worries

Divyanshu

[Former Member]

Thanks  all kind and informative help following is the output of br*

as per sap note 113747 I am unable to understand

point 2 <sid>adm on the database server has the rhosts entry: "+ <sid>adm".  how can I check and update in AIX

still issue is same in online backup.

Regards

[divyanshu_srivastava3]

Open .rhosts in VI and add entry for sidadm as suggested.

check $HOME/.rhosts for current user.

do ls-lart | grep rhosts to find the file

Divyanshu