brarchive backup other than /oracle/SID/oraarch

[Former Member]

Dear Experts,

I need to configure archive log backup using brarchive function so that , backup is taken from other local mount point other than /oracle/SID/oraarch.

I have configured init.sap profile so that it copies from /oracle/SID/oraarch to /backup mount point which is local mounted.

Now I need init*.sap so that brarchive will take backup from /backup to tape. We are using TSM for backups.

I have gone through many sap note and blogs but couldnt able to see any information nor supported document for the same. Please help

Regards

ks

[Reagan · Accepted solution]

By default BRARCHIVE archives or backs up the offline redo logs present in the archiving directory. What you have done now is configured BRARCHIVE to backup up the redos to another file system as explained here. Common Features of BRBACKUP and BRARCHIVE - SAP Database Guide: Oracle (BC-DB-ORA-DBA) - SAP Library

As far as I know there is no possibility to let BRARCHIVE backup the offline redo logs from /backup to the TSM tape. You can instead use BRBACKUP to do a file system backup like mentioned here.

Backing Up Non-Database Files and Directories - SAP Database Guide: Oracle (BC-DB-ORA-DBA) - SAP Lib...

Regards

RB

[volker_borowski2 · Accepted solution]

Backing up NON-SAP- dirs is the wrong approach.

Check out Two Phase Backup instead:

http://help.sap.com/saphelp_nw70/helpdata/DE/83/8fcf54ac5dfe4ba5fccf0516454ecf/content.htm?frameset=...

That would be

brarchive -d disk ...

for run 1

and

brarchive -a -d util_file

for run 2

at least as far as I understood the documentation.

(Never did set it up that way myself)

Volker

[former_member188883]

Hi ,

Can you check your init<SID>.sap files and compare the contents with the sample below

backup_dev_type = util_file

backup_mode = all

backup_type = online

backup_root_dir = /oracle/SID/sapbackup

archive_function = save_delete

compress = no

compress_cmd = "compress -c $ > $"

compress_dir = /oracle/SID/sapreorg

cpio_flags = -ovB

read_fifo_cmd = "rsh us0001"

copy_in_cmd = "dd bs=5k if=$"

copy_out_cmd = "dd bs=5k of=$"

rewind = "mt -f $ rew"

rewind_offline = "mt -f $ offline"

tape_size = 1200M

tape_address = /dev/rmt/3mn

tape_address_rew = /dev/rmt/3m

expir_period = 30

tape_use_count = 100

util_par_file = /dbs/initSID.utl

Update the entries with relevant information based on your system.

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Hi Deepak,

Using brbackup i was able to configure, used the function backup_mode =  /backup followed by command

brbackup -u user/password -c force -p init*.sap -m /backup which has picked up

BR0280I BRBACKUP time stamp: 2014-05-29 13.20.15

BR0057I Backup of database: SID

BR0058I BRBACKUP action ID: benyperl

BR0059I BRBACKUP function ID: pnf

BR0110I Backup mode: NON_DB

BR0077I Database files for backup:

BR0079I Directory for backup: /backup

BR0062I 1 file/directory found for backup, size 94085.700 MB

BR0143I Backup type: online

BR0130I Backup device type: util_file

BR0109I Files will be saved by backup utility at file level

  BR0134I Unattended mode with 'force' active - no operator confirmation allowed

But ending with error

BKI1207E: Directory backup not supported.

BKI1215I: Average transmission rate was 0.000 GB/h (0.000 MB/sec).

BKI1227I: Average compression factor was 1.000.

BKI0020I: End of program at: Thu May 29 13:20:22 GST 2014.

BKI0021I: Elapsed time: 07 sec.

BKI0024I: Return code is: 2

And also can i use save_delete in *.sap so that files that are backed up are deleted. Or how can i pass command so that deletion will be done for file older than 2 days.

Otherwise i need to use -mtime OS command to do this job

Regards

KSK

[former_member188883]

Hi ,

From the error message it looks like TDP installed is not compatible with SAP release.

Please check below documentation from IBM for TDP version required for your SAP release.

Also ensure TSM configuration is in-line with IBM documentation for TSM.

http://www.redbooks.ibm.com/redbooks/pdfs/sg247686.pdf

Check for relevant parameters for TSM in the link below.

IBM Tivoli Storage Manager Version 6.1 Information Center

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Hi Deepak,

Currently TSM version is 6.3 version. but let me check pdf you have shared.

I have gone through few blogs which says currently this is not supported version 6.3

Regards

KSK

[former_member188883]

This message was moderated.