Hi,
We have a 150GB Database. We would be using following RMAN Backup Strategy for 9.2.0.6.
Once a month--> Level 0 Differential Incremental
Every Sunday ---> Level 1 Cummulative Incremental
Mon to Saturday ----> Level 2 Differential Incremental.
Will this strategy work during recovery.
Regards,
Tushar Kathe
Full Version: Will this RMAN Backup Strategy work duing recovery
Test it and see. 150GB is not that big anyway. You would be just fine with a weekly full and daily incremental. What are you using for storage media? Tape or disk?
QUOTE (SteveC @ Jul 25 2008, 12:48 PM) 
Test it and see. 150GB is not that big anyway. You would be just fine with a weekly full and daily incremental. What are you using for storage media? Tape or disk?
I am using Tape and Disk both.
There is only one way to validate backup and recovery strategy, and that is to try it. In fact, your back up and recovery strategy should be validated at a minimum every three months, and monthly is better.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.