IT technologies and concepts explorer and analyser in the web.

  • RSS
  • Delicious
  • Digg
  • Facebook
  • Twitter
  • Linkedin

New IT Concepts

Share Your Comments

Posted by Priyan Fernando - - 0 comments


For SAP for Oracle, use the BRBACKUP program from the SAP command line to back up data. The BRBACKUP program can back up control files, data files within one or more table spaces, and (if necessary) online redo log files. BRBACKUP can back up all of these file types with the database either online or offline. Also, BRBACKUP saves the profiles and logs relevant to the backup.



making backup through brbackup, the init<sid>.sap file should be edited to mactch the backup.


sample list for init<sid>.sap file is below to making backup to remote tape device.
file location on unix - /oracle/<SID>/102_64/dbs


*******************************************************************


pi2:/oracle/PRI/102_64/dbs # grep -v \^# initPRI.sap


backup_mode = all
restore_mode = all
backup_type = offline
backup_dev_type = pipe
backup_root_dir = /oracle/PRI/sapbackup
stage_root_dir = /oracle/PRI/sapbackup
compress = no
compress_cmd = "gzip -c $ > $"
uncompress_cmd = "gunzip -c $ > $"
compress_dir = /oracle/PRI/sapreorg
archive_function = save
archive_copy_dir = /oracle/PRI/sapbackup
archive_stage_dir = /oracle/PRI/sapbackup
remote_host = remoteSvr  // provide the remote svr name
remote_user = root
tape_copy_cmd = dd
disk_copy_cmd = copy
stage_copy_cmd = rcp
pipe_copy_cmd = rsh
cpio_flags = -ovcB
cpio_in_flags = -iuvcB
cpio_disk_flags = -pdcu
dd_flags = "obs=64k bs=64k"
dd_in_flags = "ibs=64k bs=64k"
saveset_members = 1
copy_out_cmd = "dd ibs=8k obs=64k of=$"
copy_in_cmd = "dd ibs=64k obs=8k if=$"
rewind = "mt -f $ rewind"
rewind_offline = "mt -f $ offline"
tape_pos_cmd = "mt -f $ fsf $"
tape_size = 800G
exec_parallel = 0
tape_address = /dev/nst0
tape_address_rew = /dev/st0
volume_archive = (PRIA01, PRIA02, PRIA03, PRIA04, PRIA05,
                  PRIA06, PRIA07, PRIA08, PRIA09, PRIA10,
                  PRIA11, PRIA12, PRIA13, PRIA14, PRIA15,
                  PRIA16, PRIA17, PRIA18, PRIA19, PRIA20,
                  PRIA21, PRIA22, PRIA23, PRIA24, PRIA25,
                  PRIA26, PRIA27, PRIA28, PRIA29, PRIA30)
volume_backup = (PRIB01, PRIB02, PRIB03, PRIB04, PRIB05,
                 PRIB06, PRIB07, PRIB08, PRIB09, PRIB10,
                 PRIB11, PRIB12, PRIB13, PRIB14, PRIB15,
                 PRIB16, PRIB17, PRIB18, PRIB19, PRIB20,
                 PRIB21, PRIB22, PRIB23, PRIB24, PRIB25,
                 PRIB26, PRIB27, PRIB28, PRIB29, PRIB30)
expir_period = 30
tape_use_count = 100
primary_db = PRI.WORLD


*******************************************************************

while using remote tape as the backup device the hosts file should be used to map hostname to IP on both local and remote servers. and .rhosts on remote host.

How to take backup.

initializing the tape

  1. login as ora<sid>
  2. then run   brbackup -i force -v SCRATCH;
  3. continue until tape initialized


Take bakup

  1. run Brtools
  2. select to backup type 4
  3. type 1 to batabase backup
  4. then continue until fire the backup



contact me for any help
*******************************************************************************

from help.sap


BRBACKUP/BRARCHIVE do not use a graphical user interface in a UNIX environment. You can run them in any UNIX window and under any shell.
Both programs use standard commands for backing up the relevant files on a volume:
  • cpio
  • for backup to tape, cp for backup to disk if you are working with file systems.
  • dd
  • for backup of raw devices on tape or disk
BRBACKUP/BRARCHIVE must be configured. Some of the parameters for the initialization profile init<DBSID>.sap (see Description of Parameters) are described below.
The default configurations of both programs require online user interaction in several places. You can also run the programs without interaction - see Unattended Backup.
  • BRBACKUP saves objects in the database (in accordance with the selected options):
  • Data files of the database
  • Control file
  • Online redo log files
You can also use BRBACKUP to back up non-database files and directories. See Backing up Non-Database Files and Directories.
  • BRARCHIVE normally archives the online redo logs that ORACLE backs up in the archiving directory (offline redo log files) to tape. It is also possible to back up the offline redo log files to disk for special purposes (for example in a parallel server configuration).
  • BRBACKUP/BRARCHIVE also backs up the following files to the volume (when database objects or offline redo log files are backed up) or to the first directory named in
  • backup_root_dir for a backup of database files to disk:
  • A copy of profile
  • init<DBSID>.ora , init<DBSID>.dba (OPS: init.ora - /init.dba profiles of all the involved ORACLE instances)
  • A copy of profile
  • init<DBSID>.sap
  • The main log of SAPDBA
  • reorg<DBSID>.log , the structure log struct<DBSID>.log (OPS: script create_raw_links )
  • The detail BRBACKUP/BRARCHIVE log
  • The summary BRBACKUP/BRARCHIVE log (OPS: the summary logs of all the involved ORACLE instances)
The logs are saved on every volume (e.g. tape) used for the backup. As a result, you can still determine the contents of the volume, even when the BRBACKUP/BRARCHIVE database and file system logs have been lost.







Leave a Reply