Skip to Content

There are two types of backups we can take from RMAN+BRBACKUP.

1. Image Copy

2. Backup Set.

I am going to keep this document very simple..

So lets start with…

RMAN IMAGE COPY Full Backup

Parameters in initT01.sap

backup_mode = full

backup_type = online

backup_dev_type = disk

disk_copy_cmd = rman   << Image Copy / backup as copy

backup_root_dir = /oracle/T02/sapbackup/T02_BR_RMAN_FULL

saveset_members = 1

rman_channels = 3

Backup Command:

brbackup -p initT02.sap -d disk -t online -m full -k no -e 0 -l E

Output:

BR0051I BRBACKUP 7.20 (25)

BR0055I Start of database backup: bejzxygl.fnd 2012-12-02 13.28.47

BR0484I BRBACKUP log file: /oracle/T02/sapbackup/bejzxygl.fnd

BR0477I Oracle pfile /oracle/T02/102_64/dbs/initT02.ora created from spfile /oracle/T02/102_64/dbs/spfileT02.ora

BR0280I BRBACKUP time stamp: 2012-12-02 13.29.00

BR0057I Backup of database: T02

BR0058I BRBACKUP action ID: bejzxygl

BR0059I BRBACKUP function ID: fnd

BR0110I Backup mode: FULL

BR0077I Database file for backup: /oracle/T02/sapbackup/cntrlT02.dbf

BR0061I 85 files found for backup, total size 765453.047 MB

BR0143I Backup type: online

BR0112I Files will not be compressed

BR0130I Backup device type: disk

BR0106I Files will be saved on disk in directory: /oracle/T02/sapbackup/T02_BR_RMAN_FULL/bejzxygl

BR0280I BRBACKUP time stamp: 2012-12-02 13.29.00

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

Background command used:

@/oracle/T02/sapbackup/..bejzxygl..cmd

host ‘/usr/sap/T02/SYS/exe/run/brtools -f delete /oracle/T02/sapbackup/..bejzxygl..cmd’;

run { allocate channel dsk device type disk;

set nocfau;

backup as copy incremental level 0 tag bejzxygl check logical

datafile ‘/oracle/T02/sapdata7/sr3_49/sr3.data49’

format ‘/oracle/T02/sapbackup/T02_BR_RMAN_FULL/bejzxygl/sr3.data49’;

release channel dsk; }

exit;

=========================================================

RMAN BACKUPSET FULL backup

Parameters used:

backup_mode = full

backup_type = online

backup_dev_type = disk

disk_copy_cmd = rmanset

backup_root_dir = /oracle/T02/sapbackup/T02_BR_RMAN_FULL

saveset_members = 1

rman_channels = 3

Command used:

brbackup -p initT02.sap -d disk -t online -m full -k no -e 0 -l E

Internal commands used:

@/oracle/T02/sapbackup/..bejzybbp..cmd

host ‘/usr/sap/T02/SYS/exe/run/brtools -f delete /oracle/T02/sapbackup/..bejzybbp..cmd’;

run { allocate channel dsk device type disk;

set nocfau;

backup incremental level 0 filesperset 1 diskratio 0 tag bejzybbp check logical

datafile ‘/oracle/T02/sapdata5/sr3_51/sr3.data51’

format ‘/oracle/T02/sapbackup/T02_BR_RMAN_FULL/bejzybbp/sr3.data51.S’;

release channel dsk; }

list backup of datafile 82 tag bejzybbp;

exit;

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

  1. Former Member

    Hi Sunil,

    How did you determine the contents for the internal commands ?

    I am trying to take a backup to a local disk, using brbackup and rman.

    Setting disk_copy_cmd = rman_set isn’t doing the trick, because the

    backup is being reported in DB14 as

    Full (level 0) online database backup to local disk

    and the FID is fnd where d stands for disk. So, the rman binary is just

    used to copy the datafiles, instead of the cp command.

    (0) 

Leave a Reply