

Hi,
cold backup - official name is 'offline backup' - is a backup taken of all files after the database has been shutdown normal/immediate. The files copied includes ALL tablespace files, the redo log files and the control file. All these files must be backed up at the same time, before the database is restarted.
hot backup - official name is 'online backup' - is a backup taken of each tablespace while the database is running and is being accessed by the users. To backup a tablespace, the dba tells the database that he is doing so by issuing an 'alert tablespace begin backup'. The redo log files are not backed up, archiving is mandatory, and all the tablespaces DO NOT have to be backed up at the same time.
Thanks.

Hi,
cold backup - official name is 'offline backup' - is a backup taken of all files after the database has been shutdown normal/immediate. The files copied includes ALL tablespace files, the redo log files and the controlfile. All these files must be backed up at the same time, before the database is restarted.
hot backup - official name is 'online backup' - is a backup taken of each tablespace while the database is running and is being accessed by the users.To backup a tablespace, the dba tells the database that he is doing so by issuing an 'alert tablespace begin backup'. The redo log files are not backed up, archiving is manditory, and all the tablespaces DO NOT have to be backed up at the same time.
Thanks.