| Physical backup(RMAN) | Logical backup(EXPDP) |
Local backup (RAC) | Write backup scripts based on Oracle’s RMAN, which backs up full data and archive log regularly every day; keep the full backup of the last week locally | Write backup scripts based on Oracle’s Backup Data Pump, which backup full data regularly every day; keep the full backup of the last two weeks locally |
Remote backup (all-in-one backup machine) | The all-in-one backup machine backs up full data and archive log regularly every day based on Oracle’s RMAN; keep the full backup of the last month on all-in-one backup machine | The all-in-one backup machine backs up the logical backup files on the RAC to the all-in-one backup machine in the way of file backup; make a full backup every Sunday and an incremental backup every day from Monday to Saturday; keep the latest month’s backup on the all-in-one backup machine |