Popular White Paper On This Topic

Connect with system user and run the query:
select log_mode from v$database;

if return: "ARCHIVELOG" you can do a HOT BACKUP

if return: "NOARCHIVELOG" you can not do a Hot Bakcup because the database not generate archive logs to protect datafiles integrit(it is more complex).

But you can modify your database from noarchivelog to archivelog, but archivelog mode will be generate LOG FILES to every data changes on database... then you need to manage space on disk to prevent "full disk" and include on backup this "archive files".

In others Words, to make a HOT bakcup you need to know better your Oracle Database.

Is not Complicated, but need to read manuals(docs), if you like Oracle, you will like to read the manuals(docs).
:-)

Hi Hemal,
A hot backup is an online backup meaning that you are doing a
backup when your system is still active and a cold back up means that you
are taking a backup when your system is not running(offline).

it means import/export is hot-backup,
physicaly copy datafile is cold-backup

this is right , if not please explan what type of backup is hot & cold
backup
thanks for you help

bye
hemal

> NEW! ITtoolbox Oracle Code Exchange -
http://www.ittoolbox.com/i/af.asp>
> Hemal,
> To my understanding a cold backup is when the database is not
running - i.e
> users
> are not logged on - hence no activity going on and easier to backup.
This is
> also known as an offline backup.
>
> In contrast, a hot backup would have to be taken if your database is
mission
> critical i.e it has to run 24 hrs a day - 7 days a week. In this
case you
> will have perform
> an online or a hot backup.
>
> Hope this is o.k.
>
> Regards,
> Rupinder
>

physical copy of database files(datafiles+controlfiles+redlog files)
itself can be
divided into cold and hot backups.

Copying physical files during the database is up is called hot back up
and this
is achieved by putting the tablespace in backup mode(available for users)
and then copy
all the datafile using the ocopy commands and then bring back to normal
state.

Hemal
=09hot backup is that u run your backup when the database is open. while cold backup is that the database is shutdown when u backup it.
=09While logical backup is equal to exp. Physical backup contains online backup and cold backup.U may refer to oracle backup and recover guide for more information.
=09good luck

=D4=DA 2002-03-16 09:45:00 =C4=FA=D0=B4=B5=C0=A3=BA
>NEW! ITtoolbox Oracle Code Exchange - http://www.ittoolbox.com/i/af.asp>
>Rupinder
>
>Thank for reply
>
>it means import/export is hot-backup,
>physicaly copy datafile is cold-backup
>
>this is right , if not please explan what type of backup is hot & cold
>backup
>thanks for you help
>
>bye
>hemal
>
>
>
>
>> NEW! ITtoolbox Oracle Code Exchange -
>http://www.ittoolbox.com/i/af.asp>>
>> Hemal,
>> To my understanding a cold backup is when the database is not
>running - i.e
>> users
>> are not logged on - hence no activity going on and easier to backup.
>This is
>> also known as an offline backup.
>>
>> In contrast, a hot backup would have to be taken if your database is
>mission
>> critical i.e it has to run 24 hrs a day - 7 days a week. In this
>case you
>> will have perform
>> an online or a hot backup.
>>
>> Hope this is o.k.
>>
>> Regards,
>> Rupinder
>>

Cold backup is basically a backup of the database when the db is shut and database could be in Noarchive log mode. its simple just copy the control.redol log or data file and paste it in to backup location.
Hot backup is the backup of the database when its up and avaialable for the users.it colud be in Archive log mode.