- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.6K Security Software
How is this backup strategy ?
DB version : 19c
OS : Oracle Linux 7.7
I have a 2-Node RAC DB which serves a critical payment processing application.
This DB is currently running on version 220.127.116.11 and it will be upgraded to 19c this week. It will be around 7 TB in size.
The RTO of this DB is only 5 hours. i.e. In the event of a DB loss, the business wants the Restore + Recovery of this database to be completed in 5 hours.
Following is what I am planning:
Retention policy : Recovery window of 7 DaysIncremental Backup type : DifferentialBackup schedule :----------------Full Backup (L0) ---- > Monday and Thursday early morning 1:00AMIncremental (L1) -----> Remaining days morning 1:00 AM (Sunday, Tuesday, Wednesday, Friday and Saturday )Archive Log backup and purge every 5 hours ----> 1AM, 6AM, 10AM, 3PM and 8PM everydayBackup hardware :Dell EMC DataDomain Backup Appliance with sufficient throughput
Any suggestions/comments on Retention policy, backup type, schedule, ...etc ?