I need an advice about BRBACKUP

[symon_braunbaer]

Dear Experts,

I am trying to configure a simple BRBACKUP using RMAN to local disk (for test purposes) and nothing more.

And here the opinions are splitting:

According to:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/a8910c3a-0d01-0010-a6a9-f4a8aae14...

this should be possible:

RMAN Full Backup at Level 0 to Disk

A full backup with RMAN and without the backup library can be made to a local disk only.

But on the other side, according to:

RMAN-Relevant Profile Parameters - SAP Database Guide: Oracle (BC-DB-ORA-DBA) - SAP Library

RMAN Backups Without Backup Library

For normal backups to disk with RMAN, you need to make the following entries in the initialization file init<DBSID>.sap or the corresponding command options:

· backup_dev_type = disk

· disk_copy_cmd = rman

Here I don't fully agree with the last statement, because I have been trying this configuration. It basically uses the rman

binary in order to just copy the files to the backup location, instead using cp, it is not the full-featured rman backup taken

at DB block level (where also the dynamic block change tracking comes into play) and also no verification takes place.

I have configured a device type disk in RMAN and when I run RMAN> backup database;

this works and takes the backup as it should, but when I run brbackup, it somehow looks for an SBT_TAPE device,

which of course I don't have.

Here I need to say, that I have specified backup_dev_type = rman_disk (which I know, is the full-featured rman backup)

Can please somebody enlighten me on how to configure brbackup, so that it would look for the device type disk and not

SBT_TAPE ? I have been checking all the rman_ options, but none of them seems to do the trick.

Many thanks in advance!

[indra_gunalan]

Hello,

You can try to call as following command

Full backup:

brbackup -c -u // -d disk -RSC -m full -p /oracle/<SID>/sapprof/init<SID>_disk.sap

Archive backup

brarchive -c -u / -p /oracle/<SID>/sapprof/init<SID>_disk.sap -n ${NUM_ARCH}

Sample: init<SID>_disk.sap

archive_copy_dir = /var/crash/sapbackup

archive_function = save_delete

archive_stage_dir = /var/crash/sapbackup

backup_dev_type = disk

backup_mode = all

backup_root_dir = /var/crash/sapbackup

backup_type = online

compress_cmd = "compress -c $ > $"

compress_dir = $SAPDATA_HOME/sapreorg

compress = no

copy_in_cmd = "dd ibs=64k obs=8k if=$"

copy_out_cmd = "dd ibs=8k obs=64k of=$"

cpio_disk_flags = -pdcu

cpio_flags = -ovB

cpio_in_flags = -iuvB

db_services = yes

dd_flags = "obs=64k bs=64k"

dd_in_flags = "ibs=64k bs=64k"

disk_copy_cmd = rman

exec_parallel = 0

expir_period = 30

pipe_copy_cmd = rsh

restore_mode = all

rewind = "mt -f $ rewind"

rewind_offline = "mt -f $ offline"

rman_channels = 4

rman_filesperset = 5

saveset_members = 2

stage_copy_cmd = rcp

stage_root_dir = /var/crash/sapbackup

tape_address = /dev/rmt/0mn

tape_address_rew = /dev/rmt/0m

tape_copy_cmd = cpio

tape_pos_cmd = "mt -f $ fsf $"

tape_size = 100G

tape_use_count = 100

uncompress_cmd = "uncompress -c $ > $"

It works on my system.

Regards,

Indra

[symon_braunbaer]

Hi Indra,

unfortunately this isn't the real deal. In your configuration file, you are suggesting:

backup_dev_type = disk

I have already tried a similar configuration. The result of the backup in DB14 is:

Full (level 0) online database backup to local disk

and the FID is fnd where d stands for disk.

while a backup done with RMAN is listed as follows:

Full (level 0) online database backup using RMAN

and the FID is fnr where r stands for RMAN.

[former_member188883]

Hi Symon,

We are running RMAN backup using brtools. We have following configuration

backup_mode = full

backup_dev_type = rman_disk

disk_copy_cmd = rman

rman_parms = "BLKSIZE=1048576,SBT_LIBRARY=$ORACLE_HOME/lib/libddobk.so,ENV

=(STORAGE_UNIT=<SAPhost>,BACKUP_HOST=<backup storage host>,ORACLE_HOME=$ORACLE_HOME)"

rman_send = ("channel sbt_1 'set username sysadmin password password servername <backup storage host>'")

rman_channels=4

rman_filesperset=1

rman_keep=30

Regards,

Deepak Kori

[symon_braunbaer]

Hi Deepak,

what you are describing is the scenario with a backup library.

You have the EMC DataDomain library. In a test VM, I cannot

use any external backup library. I am interested in only making

a backup to a local disk.

[former_member188883]

Hi Symon,

You need to set the parameter  disk_copy_cmd = rman_set to have backups/ archive logs saved on disk.

Rerfer to SAP note 1101530 - Support for RMAN savesets for backups on hard disk

Hope this helps.

Regards,

Deepak Kori

[symon_braunbaer]

Thanks Deepak,

this is what I have already tried. The backup is being taken, just I am worried, because I don't see almost nothing regarding RMAN in the logs in tx. DB14, as I already said above:

Full (level 0) online database backup to local disk

and the FID is fnd where d stands for disk.

while a backup done with RMAN is listed as follows:

Full (level 0) online database backup using RMAN

and the FID is fnr where r stands for RMAN.

Though I have now carefully compared the log of 2 backups (with disk_copy_cmd = copy and disk_copy_cmd = rman_set) and with rman_set, there is no BR0315I 'Alter tablespace xxx begin backup' successful.