Oracle backup methods

Published on
9,711 Points
Last Modified:
One of the most important jobs / responsibilities of an Oracle database administrator, is to protect and safeguard all databases so that there is no data loss or corruption at any case.
Even at extreme conditions (physical disaster, deletion) an administrator is responsible for taking all measures and precautions in order to recover and restore the databases to a fully functional and operational state.

Oracle offers the following ways to backup / restore databases
1) Backup by putting the database in ARCHIVELOG mode.
2) By using the "RMAN"  with offline or on-line databases.
3) Backup all data and logs, by shutting down the database first, also known as cold / offline backups.
4) Export / Import ( imp / exp commands) by which tables and their structure is extracted and stored or  
    imported back to the database. In this case under normal circumstances one should use the same user for
    both tasks.
All the above methods are useful and meaningful to use depending on what kind of protection you might need.

In productive environments a combination of all the above is often used, since different features / alternatives are offered by each one of them.

Incremental or Full Backup?
Using the incremental or full backup method, depends totally on the strategy and specific needs of each system.
One should use incremental backups to save time and storage space on the backup media or when there is a limited bandwidth network.
Full backup has the advantage that all the data is backed up and restored once.
When using incremental backup methods, first you need to do a restore using a full backup set and then all the incremental backup sets taken after that one by one.

When in ARCHIVELOG mode incremental backups can be made while the database is open, otherwise first you have to shutdown the database.

Disaster recovery should be the very next step considered, in order to safe-guard the data and ensure fast and reliable recovery at any case.
Author:George K.
LVL 13

Author Comment

by:George K.
My article is an overview of possible Oracle backup methods.
Not just RMAN (first link) nor does it go through the detail of the backup process (second link).
It is an approach more closely to the whole picture.
I would recommend a user first reading my article before any other.

LVL 39

Expert Comment

by:Geert G
5) create table copy as select * from source;
6) save to external tables / SQL*Loader

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Join & Write a Comment

This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month