Prerequisites and Must know Configure or integrate Online Database backup for SAP R/3 Online Database

SAP R/3 Online Database Backup integration/Configuration

Backup Types

• Data Protector supports offline and online backups. During an online backup, the SAP R/3 application is actively used.
• Backup Types:
• Full (Backs up all the selected SAP R/3 objects.)
• Incr (Oracle RMAN backup incremental level 1 (available only if you use Oracle RMAN). Backs up changes made to the selected Oracle data files since the last Full backup.)
• ArchiveLogs: offline (archived) redo logs

SAP R/3 database environment objects:

·         Data files

·         Control files

·         Online redo logs

·         Offline (archived) redo logs

·         SAP R/3 logs and parameter files

Below details are captured as per Data Protector backup tool:

Considerations

• SAP backup and restore utilities
• BRBACKUP: Backs up control files, data files, and online redo log files
• BRARCHIVE: Backs up offline (archived) redo logs, written by Oracle to the archiving directory
• BRRESTORE: Restores data backed up with BRBACKUP and BRARCHIVE.
• You can back up Oracle data files in two different modes:
• backint: Data is backed up using the Data Protector SAP R/3 integration.
• RMAN: Data is backed up using the Oracle Recovery Manager (RMAN).

• backinit: Backup interface between Data Protector and SAP R/3 application. It is started by SAP tools: BRBACKUP or BRARCHIVE uses BACKINT to pass a backup request to Data Protector. BRRESTORE uses BACKINT to trigger Data Protector to restore the requested files.
• sapback/saprest: Program that performs the actual backup/restore of files.
• omnisap.exe: Data Protector program that starts the SAP backup tools

Prerequisites

• Required Components:
• Application Database name: Oracle instance name (ORACLE_SID)
• Service: Specify the Oracle service name.
• Oracle home directory
• BRTOOLS home directory: Directory in which the SAP backup utilities are stored
• SAPDATA home directory
• Oracle database user account: Database user account granted at least the following Oracle roles: sysdba and sysoper
• OS user name and user group
• Operating system user account that is added to the following user groups:
• Windows systems: ORA_DBA and ORA_SID_DBA local groups
• UNIX systems: dba and sapsys
• Unix Systems: Ensure that this user is the owner of the filesystem or of the raw logical volume on which the database is mounted. The minimum permissions should be 740.
• Unix: Default operating system administrator's user account added to the dba user group.

• The database used by the SAP R/3 application must be an Oracle database.

Restore

You can restore Data Protector backups using:

• The Data Protector user interface
• The SAP BRTOOLS user interface

Share this

ChinniLax