Q

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 first published in January 2006
This Content Component encountered an error

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close