Some background about Oracle, SAP and DP for ERP for Oracle:
Oracle RMAN
- RMAN ist the Oracle Backup and recovery manager and save the CONTENT of a file and not the file itself
>> backup types = full or incremental , online or offline
SAP
- SAP use for its backups and recovery the BRTools whatever you are using command line or DB13
BRTools using FILES for Backup
>> backup types = full(all) and partial , online and offline
BRTools and External Backup Utility
- SAP has designed an Backup Recovery Interface ( BRI ) to allow vendors to backup the Data to its Backup Solution. The BRTools is the master of the backup/restore process. External backup utilities like DP or DP with RMAN running under control of the BRTools, like a blue colloured worker
- Communication between BRTools and external backup tools will made over
"env variables" ( type of backup ) and files ( backup file list, errors success, .... )
DP for ERP for Oracle ( there is also a DB2 one )
-DP for ERP for Oracle is a external backup utility designed to work thogether the BRTools
( DP for ERP can only be used with an SAP system , for a Oracle without SAP you have to use DP for Oracle )
DP for ERP for Oracle has 3 read/write devices
- FILE r/w files from DISK ( backint )
- BLOCK r/w over a shared library in connection with RMAN
- TSM r/w data using TSM API
Different between partial and incremental
--- partial
= partial works only with files, or better TABLESPACES (TB), to save storage space, it's possible to running e.g. a fullbackup and the next 3 days a partial ( 1.Day TB 1-5 , 2.Day 6-10 and 3.Day 11-15 ).
!!! Restore need some additional time: restore sequence is "1. restore last full backup 2. restore
partial(s) 3. restore redologs !!!
-- incremental
= incremental works with data blocks, that means RMAN searching through the DB for blocks that have changed since last backup.
!!! Restore need some additional time: restore sequence is " 1. restore last full backup , 2. restore the last incremental, restore the redologs !!!
Keep in mind !
" incremental and partial are only reasonable to save storage on the Backup Server "
" incremental backup need nearly the same time as full backup ( checking block for block ) "
"" You save storage but you lose time on the restore ""
"" Design you Backup Strategy based on you "Restore Time Window" ""