Problem solve Get help with specific problems with your technologies, process and projects.

How many types of backups are there?

How many types of backups are there in Oracle? Also, how to take a backup from the Oracle database if I want to format the system?

How many types of backups are there in Oracle? Also, how to take a backup from the Oracle database if I want to format the system?

There are many different types of Oracle backups. First, you have logical and physical backups. Logical backups...

are taken with Oracle's export utilities. Physical backups are performed either hot or cold. With cold backups, you shut down the database and then you use OS copy commands to copy the database datafiles to your backup destination. Hot backups are best performed by using RMAN (which can also do cold backups). RMAN offers different types of backups as well. With RMAN, you can back up the entire database, back up certain tablespaces, and perform incremental backups as well. If this sounds like there is a lot of things to consider with backing up your Oracle database, that's because there is! Oracle has provided many different backup and recovery methodologies to handle a great many different situations. The only way to understand which method is best for you is to figure out how they all work. This document is Oracle's start at teaching you backup and recovery from an Oracle perspective.

Additionally, you may want to pick up any of the fine books from Oracle Press concerning Oracle backups. These are great books which can enhance your library and your skill set. You can pick up Oracle Press books on Amazon, or your local Barnes & Noble or Borders, here in the United States. I'm sure other countries have similar outlets.

This was last published in January 2006

Dig Deeper on Oracle database backup and recovery



Find more PRO+ content and other member only offers, here.

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.