- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536.1K 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
Comparing Recovery Strategy
Hi, we are using version 18.104.22.168 of Oracle Exadata. We have RMAN L1 backup scheduled on weekdays and LO runs each sunday. We do have physical standby exists which is running with zero lag and is there for disaster recovery. We have a critical database and the business need , to recover the DB object in case of any logical error and the recovery should happen within ~4hrs. We have flashback ON to cater this need as because in earlier versions even to recover a single object from RMAN backup we were supposed to restore the whole database which was time consuming so was not a viable option for us.
Now currently , we are seeing significant I/O overhead due to flashback write(flashback buf free by RVWR waits) during peak hours and those affecting application query(mainly writes/DMLS) performance. As its doing additional logging for flashback affecting application performance, So we are evaluating if we can turn off the flashback and use the RMAN backup to recover the DB objects in case of mishap without breaching sla.
1)So want to understand from experts if its advisable here to replace FLASHBACK with the recovery using RMAN? Is this a standard practice?
2)What would be the Approx. turnaround time difference between flashback VS RMAN recovery option(say for an object having size ~10TB)?
3)In current scenario, we can't think of any good reason for take whole database back to past point in time.And in that case i think ofcourse flashback will be significantly faster than RMAN restore. but want to understand from experts if there is any such real need(or any standard practice) in which we have to take the whole database back to a point in time?