Home » RDBMS Server » Backup & Recovery » Best backup Strategy
Best backup Strategy [message #185654] Wed, 02 August 2006 21:40 Go to next message
Messages: 59
Registered: January 2006
Location: delhi
Hi all

I have a production database of size 1000 GB. It genrates aprox. 60 GB to 100 GB archive logs in a day. What should be the backup strategy to reduce recovery time.......

***once in a month cold backup is allowed by management***

Oracle 10.2

Re: Best backup Strategy [message #185727 is a reply to message #185654] Thu, 03 August 2006 05:32 Go to previous message
Messages: 2794
Registered: April 2006
Senior Member
You may want to consider Incrementally Updated backups. With this strategy, you'll minimize the amount of data you have to backup daily and you can configure it so that you'll never have more than one day of redo to apply. Look here for more information.
Previous Topic: cold backup in archivelog mode
Next Topic: Incomplete restore of datafile to external location
Goto Forum:

Current Time: Thu Oct 27 14:05:52 CDT 2016

Total time taken to generate the page: 0.11249 seconds