Thursday, February 14, 2013

Basic Backup Techniques

Oracle Provide you with More than Way to Backup Let's talk about them shortly :

1- Hot Backup

performed on data even though it is actively accessible to users and may currently be in a state of being updated.

- Connect / as sysdba
- alter database begin backup;
- copy all data files using OS command / not necessary to copy temp datafile.
- alter database end backup;
- alter system switch log;
- alter database backup control files to ‘’;

 2- Cold backup

Here all you have to do is shutdown database Copy Files ( Controlfile , Datafiles , Redolog .... ) using OS Command.

3- Backup Using RMAN

RMAN is most powerful utility for Backup in Oracle gives you lot of options, the simple script is below :

set/export ORACLE_SID=
rman target /
run {
backup database;
backup archivelog all;
4- Export/import Commands

The Export utility provides a simple way for you to transfer data objects between Oracle databases, even if they reside on platforms with different hardware and software configurations.

Check Oracle documentation and example here.

Thank you
Osama Mustafa


  1. sir could u tell me how can we can store the all detail information regarding the work done by a unknown user u may call him or her as unauthorized user sir plzs help me

    1. if i understand you well you can enable auditing