[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More


Oracle backup methods

Published on
9,751 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

Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

Join & Write a Comment

This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month