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
- login as ora<sid>
- then run brbackup -i force -v SCRATCH;
- continue until tape initialized
Take bakup
- run Brtools
- select to backup type 4
- type 1 to batabase backup
- 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
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
- 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)