Hot Backup
1)usage 1@@@@hot mean online.@@@the hot backup meaning you could copy your datafile to other directory @@@for save. but one thing, if you want to recovery using these files. @@@you must use cold recovery operation. @@@Note: if outage when you are running the hot backup, you must end it first @@@before you recover instance. ####begin#################################################### [oracle@station3 ~]$ cat hot_backup.sql #!/bin/sh sqlplus /nolog << ! conn /as sysdba alter tablespace system begin backup; quit ! cp /u01/app/oracle/oradata/orcl/system01.dbf /home/oracle/system01.dbf sqlplus /nolog << EOF conn /as sysdba alter tablespace system end backup; quit EOF ######end##################################################