SAP Note 15595 - Availability of BRRESTORE

Symptom:

Entire DB (or individual files) defective

Cause and prerequisites

Database completely or partially restored.
Parallel restore from several tape stations
Restore in different target directories.

Solution
SAPDBA/BRBACKUP uses CPIO to back up DB files. Previously, this had to be done manually with cpio. Starting with R/3 Release 3.0, a new BRRESTORE tool will be shipped, which can be used to restore DB backups created with SAPDBA/BRBACKUP (complete DB, one tablespace at a time, directories, or individual files). In addition, an SAPDBA function for complete or partial restore of the DB is available from 2.2C onwards (see main menu of SAPDBA).

Customer who have an X.25 connection can fetch the BRRESTORE tool (regardless of the customer R/3 version) from sapserv3 via ftp:

ftp sapserv3 (|sapserv3a|sapserv4)
> username: ftp
> password: ftp
> cd dist/permanent/sapdba
> get brrestore.readme.e (description of BRRESTORE,
identical to note no. 14004)
> cd hp (|sni|ibm|sun|dec|nt - depending on operating system)
> bin
> get brrestore.Z
> quit

uncompress brrestore.Z (decompress)
cp brrestore /usr/sap//SYS/exe/run
Set Owner,Group,Permissions as with sapdba,brbackup, e.g.
chmod 755 /usr/sap//SYS/exe/run/brrestore
chgrp sapsys /usr/sap//SYS/exe/run/brrestore
chown c11adm /usr/sap//SYS/exe/run/brrestore
Before you start BRRESTORE, you must enter 3 additional parameters in
profile
$ORACLE_HOME/dbs/init<>.sap (see brrestore.readme.e
cpio_in_flags, uncompress_cmd, tape_pos_cmd or note no. 14004)

Because BRRESTORE will not be officially released until Version 3.0, these 3 new parameters will not be compatible with BRBACKUP and BRARCHIVE until then, and must therefore be deactivated once you exit BRRESTORE.