Re: Hot backup, cold backup, Archive mode. Please tell me how they are performed.

Hi,

        The following explanation is quite simplistic. For a good treatment on backup and recovery either Kevin Loney's DBA Handbook or the Oracle Backup and Recovery Book (forgot the author's name) both in the Oracle Press series published by Osborne McGraw-Hill should be read.

        Cold backup - a backup run when the database is shutdown. Be careful to include ALL of the files belonging to the Oracle user when running a cold backup -- not just your own dataffiles.

        Hot backup - a backup run while the database is up and running. This involves backing up a tablespace at a time by altering the tablespace backing it up and then altering it back. Essentially you are backing up the data in the tablspace at the beginning of the backup plus any changes made during the backup process.

        Archive mode - This entails saving the log files so that, in the event of a failure, you can recover by restoring the last backup and then applying each of the log files in turn until the database is fully recovered.

regards

Jerry

giau45_at_yahoo.com wrote:
>
> Can you please describe hot backup, cold backup and archive mode.
>
> I'm trying to learn. Thanks,

-- 
Jerry Gitomer         	ICT Group
jgitomer_at_ictgroup.com	Langhorne PA
jgitomer_at_yahoo.com 	Opinions are mine not those of ICT Group