Re: HOT BACKUP

Torkild Hagen wrote:

> You can do as folows
>
> 1. Place a specific tablespace in backup mode with the following command:
>
> SVRMGR> ALTER TABLESPACE <tablespace_name> BEGIN BACKUP;
>
> 2. Make backup of the tablespace's datafile(s) any which way you like:
> UNIX; tar, cpio, dd, fbackup etc...
> PC; any which way.
>
> 3. Last step is to take the tablespace out of backup mode;
>
> SVRMGR> ALTER TABLESPACE <tablespace_name> END BACKUP;
>
> This is what is known as a hot backup of the Oracle database, as opposed
> to a cold backup where the database is shut down first.
>
> Hope this is of any help.
>
> Torkild Hagen
>
> -------------------------------------------
> Torkild Hagen
> Software Engineer / Database Administrator
> Navia Aviation AS
> Email: torkild.hagen_at_naviaav.no
> -------------------------------------------
>
> Norhayati Hassalli wrote in message <35580D5D.306A59A0_at_mimos.my>...
> >Other than the export command, what other ways of doing a hot backup ?
> >

 You also MUST be in ARCHIVELOG mode.

By the way, export is not a true backup -- there is no way to recover updates past the time of the export. Received on Tue May 12 1998 - 16:46:55 CDT