NOTE: Can be used only when DB is running in archivelog mode PUT DB IN BEGIN BACKUP MODE ---------------------------- Alter database begin backup; COPY ALL FILES TO BACKUP LOCATION --------------------------------- - Create a location on OS where you can copy backup files. Eg /u02/db_backup/hot_bkp_12_jan/ - Get the location of datafiles, controlfiles, redolog files select name from v$datafile; select name from v$controlfile; select member from v$logfile; - Copy above files using Linx cp command to backup location PUT DB IN END BACKUP MODE ---------------------------- Alter database end backup; TAKE MANUAL CONTROLFILE BACKUP ------------------------------ Alter database backup controlfile to '/u02/db_backup/hot_bkp/ctrolfile_DB_level_bkp.ctl'; Alter database backup controlfile to trace as '/u02/db_backup/hot_bkp/ctrolfile_trace_bkp.ctl'; BACKUP ARCHIVELOGS GENERATED DUTING THE BEGIN BACKUP AND END BACKUP MODE ------------------------------------------------------------------------ SELECT THREAD#,SEQUENCE#,NAME FROM V$ARCHIVED_LOG;