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

How to change backup strategy to decrease downtime

I am taking cold backups of my database which is in noarchive mode on a daily basis; now I am planning to change my backup strategy to decrease the downtime.

I am taking cold backups of my database which is in noarchive mode on a daily basis; now I am planning to change my backup strategy to decrease the downtime and for performing a complete recovery if media fails. I am having a few doubts about how to do this. 1.) Can I go with the cold backups with archiving enabled and delete the archivelogs after the backup? 2.) Can I implement RMAN and perform incremental 0 on Monday, incremental 1 on weekdays and a cold backup on Sunday? 3.) My database size is 95 GB. Please suggest what to do and how.

You have lots of options here. First and foremost, place the database in ARCHIVELOG mode. After that, you can still...

perform cold backups if you want. But I would recommend implementing RMAN and letting it do hot backups. You can even do incremental backups with RMAN if you want, but you are not required to do so.

Whenever someone asks me to suggest a good backup strategy for them, my answer is always the same ... what are your recovery requirements? Your recovery requirements dictate your backup strategy, not the other way around. Read the RMAN guide to learn all of its features. Then decide which features are recovery requirements for you. Once you know that, your backup strategy will be obvious.

This was last published in July 2007

Dig Deeper on Oracle database backup and recovery

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close