We are developing a airline reservation system which should be a high availability system and should handle terabytes of data. We are using Oracle 9i as the database. Could you please suggest what the best strategy would be for data backup (hot backup and cold backup). Also what strategy should be adopted to move these backup files to storage devices?
Since a "cold" backup requires the database to be shutdown, it is not an option for a 24x7 database. "Hot" backups give you the ability to backup while the database is still up and functional. You can either put the tablespaces into backup mode and back them up using some OS utility (ocopy, copy, cp, tar, gzip, etc) or you can use RMAN (Recovery Manager). Either way you get a good backup from which a full recovery can be made without sacrificing downtime.
As far as a strategy for moving backup files to storage devices, everybody has a different opinion. I tend to prefer to backup to disk as a first step (usually the fastest disk I have available) and then later move it off to a tape device or other storage media. Your decisions have to be made based on your environment and the limitations you have there. Everybody's "best method" is somewhat different from everybody else's. Look at your resources and make your decision accordingly.
For More Information
- Dozens more answers to tough Oracle questions from Karen Morton are available.
- The Best Oracle Web Links: tips, tutorials, scripts, and more.
- Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical Oracle and SQL questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.
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.