Skip to Content
0
Former Member
Aug 02, 2014 at 01:57 PM

Online backup fail through DB13

328 Views

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