Re: HOT BACKUP

In article <6j977q$ddg$1_at_o.online.no>,
  "Torkild Hagen" <torkild.hagen_at_naviaav.no> 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

A footnote to all this - you need to be running in archivelog mode to restore the datafiles - if you aren't going to replace all the datafiles at once then the archivelogs are need to bring them back into sync.

Julian Wiffen

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu May 14 1998 - 08:54:14 CDT