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.
