Home » RDBMS Server » Backup & Recovery » Best backup Strategy
Best backup Strategy [message #185654] Wed, 02 August 2006 21:40 Go to next message
abs_amit
Messages: 59
Registered: January 2006
Location: delhi
Member
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
HP- UX

Thanks........
Re: Best backup Strategy [message #185727 is a reply to message #185654] Thu, 03 August 2006 05:32 Go to previous message
ebrian
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: Fri May 03 00:16:44 CDT 2024