Register Login

SAP Oracle Backup Type (Offline, Online Incremental, Partial) Backups

Updated May 18, 2018


BR Backup is used to take backup of the database (Datafiles). When ever a backup is triggered BR Backup is initialized.

There are various types of backups

1. Offline Backup
2. Online Backup
3. Incremental Backup
4. Partial Backup

1. Offline Backup (Cold Backup)

                                The database is down during backup and no transaction is allowed as it is down. It is consistent and reliable.

Whole Offline Backup: The backup taken fully and a catalog is opened to start the incremental backup.

Eg: A database is of 2000 GB Which is not possible to take a daily full offline backup with a backup speed of 150GB/ Hour.

Full Offline Backup: It is a complete database backup without any Catalog.
Catalog (SUNDAY - The rest will be taken)

2. Online Backup

The DB is up and running with out effecting the user transactions. It is consistent and reliable with redo logs that are generating during backup.

Whole Online Backup: The backup is taken fully and a catalog is opened to start the online incremental backup.

Full Online Backup: It is complete database backup with out any catalogs.

Online Backup: It is consistent always with redo logs.

3. Incremental Backup

                                It is initiated from level0 backup and used when the database size is too big. It can be online or offline.

4. Partial Backup

                                It is taken for a specific table during a patch (Especially HR Patches)

Backup type is defined by a parameter

Backup_mode = all
Backup_type = offline
Backup_dev_type = Tape or Disk
Backup_root_dir = H:\oracle\SID\sapbackup

All the above backups are performed by using brbackup.


It is used to backup the offline redolog file to tape or disk i.e. from ORAARCH directory to tape or disk.

Archive_function = SAVE/ COPY/ DELETE
Archive_copy_dir = H:\Oracle\NWD
Tape_size= 100G
Volume_archive=NWDA01...... NWDA30...

Reads content from Log Buffer. Log writer writes to OrigLogA and OrigLog B, Mirror Log A, Mirror Log B. When OrigLog A is full it is moved to OrigLog B When OraArch is full it is backed up to a tape or disk.

- Archive function means the saving mechanism of log files.
- Log writer logs into OriglogA, OriglogB, MirrorLogA, MirrorLogB
-When online redo logs are full then Arch writes contents to Oraarch i.e
(Offline redologs) the content of oraarch is referred as offline redo logs.
- If Oraarch is full the archive gets stuck and the complete update mechanism stuck and users encounter congestion.
- So the Oraarch content needs to be moved to alternative location on hourly, bi-hourly for every 4 hours or daily depending upon the frequency of updates.

- While copying Oracle provides various means of log save because we don't want the corruption of logs.

The data transfer from Oraarch to disk is done by BRArchive.


It uses BRConnect, BRBackup, BRRestore, BRRecover with various options.
We can do the following with BRTools.

- Start and stop the database
- Database backup
- Redolog Backup
- Restore Database - from database backup
- Recover Database from Redolog Backup
- Extend the tablespace by adding datafile or resizing datafile. Max datafiles are 250 in SAP.

Each datafile size is 1% of the Whole database (100-200) 2 GB 200-400 4GB...

- Tablespace management (Create drop alter. mostly create and drop are not used)
- Reorganisation (Create, Rebuild, Indexes Export and Import tables)
- Database standard house keeping jobs (DBStatistics, cleanup logs, dbcheck, adapt next extents)
- Display profiles, change schema password etc.