Re: Oracle Database Backups

From: ashok kapur <akapur_at_thomtech.com>
Date: 1996/08/28
Message-ID: <32249E1A.3960_at_thomtech.com>#1/1


trazz_at_interaccess.com wrote:
>
> What methods are there to backup oracle databases? what backup
> software is available ? is it possible to do live hot backups of
> oracle databases and do incremental backups as well?
>
> Any help will be greatly appreciated.
>
> We run on SunOS/Solaris
>
> Thanks
> Trazz

There are many ways to backup Oracle database. For detailed info refer to Oracle Server Admin Guide. But here is a list of a few methods: 1. Export the database using exp. (Caution: this may take a while if you have a big database and are trying to do a full export.) 2. Shutdown the instance and use OS to backup all Oracle related files. 3. To do HOT backups, your database needs to running in ARCHIVELOG mode. In order to do HOT backups, you need to manually set each tablespace in "backup" mode, perform OS backup of tablespace data files and end the "backup" mode in Oracle for the tablespace.

Export allows to perform Incremental backups.

Please feel free to contact me if you need more info.

-- 
Ashok Kapur (akapur_at_thomtech.com)
Thomson Technology Consulting Group
1375 Piccard Drive, Suite 250
Rockville, MD 20850
Received on Wed Aug 28 1996 - 00:00:00 CEST

Original text of this message