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 :
rman target /
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.
2 thoughts on “Basic Backup Techniques”
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
if i understand you well you can enable auditing