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
Technology Geek 