Help - Search - Members - Calendar
Full Version: Will this RMAN Backup Strategy work duing recovery
Oracle DBA Forums > Oracle > Oracle Forum
Tushar Kathe
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
SteveC
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?
Tushar Kathe
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.
andrew kerber
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.
Invision Power Board © 2001-2014 Invision Power Services, Inc.