RMAN Backup using brtool via DB13 calendar

[Former Member]

Hi guys,

Could you please let me know how to schedule RMAN incremental database backup with RMAN(BCTF).

My system details,

SAP Version 731

BRTOOLS version 7.20 (25)

Oracle version 11.2.0.3

Many thanks in Advance.

Thanks,

Dhavan

[former_member188883 · Accepted solution]

Hi Dhavan,

Please refer below links

http://help.sap.com/saphelp_sm40/helpdata/en/fd/dba41eb4aa2943b88c46d06f693d2e/content.htm

http://scn.sap.com/thread/1686294

Hope this helps.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Thanks Deepak,

while trying RMAN archive log backup using brtool via db13 as am getting below error message.

BR0280I BRARCHIVE time stamp: 2014-02-24 06.53.49

BR0541I Starting offline redolog backup using RMAN...

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

     Recovery Manager: Release 11.2.0.3.0 - Productionon Mon Feb
24 06:53:49 2014

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

     RMAN

RMAN> connect target *

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

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

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

  ORA-01031: insufficient privileges

Thanks,

Dhavan

[Former Member · Accepted solution]

Check permissions for brbackup, brarchive executables. In Linux you must set s-bit for group permissions.

[Former Member · Accepted solution]

I checked Brtools permission are correctly.

The above issue is RMAN not able to connect target database. I think some user privilege issue but I don't know what exact is?

[Former Member · Accepted solution]

Can you provide screenshot with permissions?

[Former Member · Accepted solution]

-rwxr-xr-x 1 SIDadm sapsys 3320603 Oct 22  2012 brtools

-rwxr-xr-x 1 SIDadm sapsys 8909673 Oct 22  2012 brspace

-rwxr-xr-x 1 SIDadm sapsys 2431752 Oct 22  2012 brrestore

-rwxr-xr-x 1 SIDadm sapsys 7100570 Oct 22  2012 brrecover

-rwsrwxr-x 1 oraSID sapsys 6522048 Dec  9 10:51 brarchive

-rwsrwxr-x 1 oraSID sapsys 6652235 Dec  9 10:51 brbackup

-rwsrwxr-x 1 oraSID sapsys 8480602 Dec  9 10:51 brconnect

[Former Member · Accepted solution]

Please execute

> chmod 6754 brbackup brarchive

and check again.

[Former Member · Accepted solution]

As per SAP note 113747 all set.

[Former Member · Accepted solution]

You must have -rwsr-sr-- rights (pay attention to s bit) set for brbackup and brarchive.

[Former Member · Accepted solution]

but it is working fine normal archive log backup and whole database online backup.

while I changed the setting to RMAN configuration as am getting above error.

for above permission changes for RMAN backup. Please share the document or note.

[Former Member · Accepted solution]

In addition to s-bit you must also change group to dba for brbackup and brarchive.

776505 - ORA-01017/ORA-01031 in BR*Tools on Linux and Solaris 11

[Former Member · Accepted solution]

Thanks a lot Roman it is working fine ...I get some different error and check with my side first.

Let you know if any help..

[Former Member · Accepted solution]

we are getting below error message while tried to take backup from DB13 calendar but it is working fine unix level orasid and sidadm.

BR0280I BRARCHIVE time stamp: 2014-02-25 08.08.10
BR0202I Saving /oracle/SID/oraarch/SIDarch1_8912_793122936.dbf ...
BR0278E Command output of 'SHELL=/bin/sh /oracle/SID/112_64/bin/rman nocatalog':

Recovery Manager: Release 11.2.0.3.0 - Production on Tue Feb 25 08:08:07 2014

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

RMAN>
RMAN> connect target *
connected to target database: SID (DBID=1683077722)
using target database control file instead of recovery catalog

RMAN> **end-of-file**

RMAN>
host command complete

RMAN> 2> 3> 4>
allocated channel: sbt_1
channel sbt_1: SID=123 device type=SBT_TAPE
channel sbt_1: Data Protection for SAP(R)

Starting backup at 25-FEB-14
channel sbt_1: starting archived log backup set
channel sbt_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=8912 RECID=8776 STAMP=840434379
channel sbt_1: starting piece 1 at 25-FEB-14
released channel: sbt_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on sbt_1 channel at 02/25/2014 08:08:11
ORA-19506: failed to create sequential file, name="SID_aenhauna.38_1", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
   BKI7051E: The environment variable XINT_PROFILE is not set. It must be set and contain the fully qualified path to the *.utl file to be used.

RMAN>
specification does not match any backup in the repository

RMAN>

Recovery Manager complete.
BR0280I BRARCHIVE time stamp: 2014-02-25 08.08.12