cancel
Showing results for 
Search instead for 
Did you mean: 

RMAN Level 0 Backup to Disk using BRTOOLS.

Former Member
0 Kudos

Hi,

We have planned to implement RMAN for taking the backup of our SAP database. The backup would be taken to the local disk.

We plan to run the run the RMAN level 0 backup on every weekend (Sun) and then the incremental backup on everyday of the week(Mon-Sat).

We are not using the SAP Backup library nor any external backup libraries. But I think that backups to local disks does not require a backup Library.

The following Parameters were set in the init<sid>.sap file for our BRTOOLS.

rman_compress = yes

backup_dev_type = disk

disk_copy_cmd = rman_set

But when tried running the BRBACKUP, it failed.

brbackup -p initXID.sap -d rman_prep -t online -m all -e 8 -l E -U (RMAN Preparation Run)

RMAN> connect target *

connected to target database: XID (DBID=3524048029)

using target database control file instead of recovery catalog

RMAN> *end-of-file*

RMAN>

host command complete

RMAN> 2> 3> 4> 5> 6>

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

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

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

RMAN-03009: failure of allocate command on sbt channel at 05/12/2010 05:56:48

ORA-19554: error allocating device, device type: SBT_TAPE, device name:

ORA-27211: Failed to load Media Management Library

Additional information: 25

RMAN>

I am not sure why BRBACKP is trying to use "SBT Channel" even after setting the parameter "backup_dev_type = disk". Can someone please advise ?

Regards

Arun Brelvi

Accepted Solutions (0)

Answers (2)

Answers (2)

mohammed_anish
Participant
0 Kudos

Hi,

Set the following parameter in initSID.sap or the file you use.

backup_type = online

backup_dev_type = disk

backup_root_dir = /oracle/<SID>/sapbackup/<give any directory>

disk_copy_cmd = rman

NOTE: all the parameter I mentioned above will be applicable to rman incremental backup only. Full backup (the so called level 0) to disk is not possible using RMAN.

So in your backup strategy, schedule "Fulldatabase Online backup" (NOT whole database online) from transaction DB13...this will get registered as the level 0 for further RMAN incremental backup.

The command you gave is ending with an error because of the parmeter disk_copy_cmd = rman_set. Any value rman_* will look for tape library (SAP library or external library).

Regards,

Anish

Edited by: Mohammed Anish on May 24, 2010 4:13 PM

Former Member
0 Kudos

Hi,

Try changing the parameter in init<SID>.sap as below:

backup_dev_type = rman_disk

Also use latest BRTools.

Regards.

Rajesh Narkhede

Former Member
0 Kudos

It still gives the same error. I changed the parameter - backup_dev_type = rman_disk. I am using BRBACKUP 7.00 (48).

BR0280I BRBACKUP time stamp: 2010-05-17 04.54.52

BR0057I Backup of database: XID

BR0058I BRBACKUP action ID: bedgbcrb

BR0059I BRBACKUP function ID: fnr

BR0110I Backup mode: FULL

BR0077I Database file for backup: /oracle/XID/sapbackup/cntrlXID.dbf

BR0061I 23 files found for backup, total size 58023.500 MB

BR0143I Backup type: online

BR1397I Files will be compressed by RMAN

BR0130I Backup device type: rman_disk

BR0280I BRBACKUP time stamp: 2010-05-17 04.54.52

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRBACKUP:

BR0280I BRBACKUP time stamp: 2010-05-17 04.55.02

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0370I Directory /archive/offLine/xid/bedgbcrb created

BR0202I Saving init_ora

BR0203I to /archive/offLine/xid/XID ...

BR0202I Saving /oracle/XID/102_64/dbs/initXID.sap

BR0203I to /archive/offLine/xid/XID ...

BR0280I BRBACKUP time stamp: 2010-05-17 04.55.03

BR0198I Profiles saved successfully

BR0280I BRBACKUP time stamp: 2010-05-17 04.55.03

BR0504I Starting full database backup (level 0) using RMAN...

BR0278E Command output of 'SHELL=/bin/sh /oracle/XID/102_64/bin/rman nocatalog':

Recovery Manager: Release 10.2.0.4.0 - Production on Mon May 17 04:55:03 2010

Copyright (c) 1982, 2007, Oracle. All rights reserved.

RMAN>

RMAN> connect target *

connected to target database: XID (DBID=3524048029)

using target database control file instead of recovery catalog

RMAN> *end-of-file*

RMAN>

host command complete

RMAN> 2> 3> 4> 5>

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

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

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

RMAN-03009: failure of allocate command on sbt_1 channel at 05/17/2010 04:55:15

ORA-19554: error allocating device, device type: SBT_TAPE, device name:

ORA-27211: Failed to load Media Management Library

Additional information: 25

RMAN>

RMAN>

Recovery Manager complete.

BR0280I BRBACKUP time stamp: 2010-05-17 04.55.21

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

BR0522E 0 of 22 files/save sets processed by RMAN

BR0536E RMAN call for database instance XID failed

BR0280I BRBACKUP time stamp: 2010-05-17 04.55.21

BR0506E Full database backup (level 0) using RMAN failed

BR0056I End of database backup: bedgbcrb.fnr 2010-05-17 04.55.21

BR0280I BRBACKUP time stamp: 2010-05-17 04.55.24

BR0054I BRBACKUP terminated with errors

Former Member
0 Kudos

Hi,

Try setting the below parameter in init<SID>.sap

First try with:

backup_dev_type = stage
disk_copy_cmd = rman

If it doesn't work then:

backup_dev_type = disk
disk_copy_cmd = rman

Test the backup from command line (as ora<sid> user):

# brbackup u2013m full u2013d disk

Also refer the below useful link:

[http://help.sap.com/saphelp_nw04/helpdata/EN/3f/9d800e1aec11d2b42c00609419997a/frameset.htm|http://help.sap.com/saphelp_nw04/helpdata/EN/3f/9d800e1aec11d2b42c00609419997a/frameset.htm]

Regards.

Rajesh Narkhede