Re: HOT BACKUP

From: Torkild Hagen <torkild.hagen_at_naviaav.no>
Date: Tue, 12 May 1998 12:08:52 +0200
Message-ID: <6j977q$ddg$1@o.online.no>

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 ?
>
Received on Tue May 12 1998 - 05:08:52 CDT