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.

Start the conversation

0 comments

Register

I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.

Please check the box if you want to proceed.

I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.