Q
Manage Learn to apply best practices and optimize your operations.

Backup strategy for 1TB database

I work for a small firm with less than 400GB of data which is backed up on a daily basis. What is the best backup strategy if the firm expands its database to 1TB?

The most difficult moment in an interview is when I am asked about the backup strategy. I work for a small firm with less than 400GB of data which will be backed up on a daily basis. What do you think the best backup strategy should be if the firm expands its database to 1TB? Please advise.

To me, deciding the backup strategy before understanding your recovery requirements is doing things backwards, and I would say that during an interview. One requirement I can glean from your problem description is that you have to be able to recover a 1TB database. But what are the other requirements? It is your recovery requirements that define your backup strategy, not the other way around.

Recovering (and backing up) in a timely manner can be helped by using RMAN and running the operations in parallel. Incremental backups can help too. Oracle 10g's new Incrementally Updated Backup not only makes backups run quicker, but also recovery. For more advanced concepts, please read the Oracle 10g Backup and Recovery Advanced User's Guide.

Dig Deeper on Oracle database backup and recovery

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close