You are maintaining a 100 GB database, which is continuously growing. Based on existing hardware, you determine that open backups of the entire database take 4 hours. The database is online 24 hours a day, 7 days a week and the backups are consuming too much of the system resources during this period of time. Level 0 backups cannot be performed more than once a week, but fast recovery in case of failure is required. You therefore decide on the following backup and recovery strategy:
•A level 0 backup will be performed each week on the day with the least activity. You determine this day to be Sunday.
RMAN> BACKUP INCREMENTAL level 0 database;
•Incremental level 2 backups will be performed every day, except Wednesday. In this way, backups will be fast because only changed blocks from the previous day will be copied:
