Re: DBA Question: What are all my backup options?

In article <MARY.95Jul11164243_at_gulper.mitra.com>, mary_at_mitra.com (Mary E. Hunt) wrote:

> I am trying to find out all the options of backing up an Oracle
> datbase. I have the ORACLE DBA Handbook by Kevin Loney which explains
> export/import, cold, hot and incremental backups.
>
> With running in archive log mode, we are generating a log of archived
> redo logs which are taking up a lot of space.
>
> Ideally, I would like to be able to do some sort of incremental backup
> that only records DML statements to a specific set of tables. The
> application we are running is doing a lot of database updates to
> tables that the application needs but are not REAL data.
>
> Are there any other methods for backing up my database? Maybe some
> third party software, or something? Any information would be appreciated.
>
> Thanks in advance.
>
> Mary Hunt

Mary,

If the amount of archive logs are a problem you can do additional full backups on the database. You only need the archives since the last full backup.

If you shutdown the database once a week and backup all the oracle datafiles, then you can delete previous archive files. Of course, this only works if you can shutdown the database.

Archive log is the best backup method! It will save you headaches as a DBA. You get the minimum data loss and the fastest recovery time. You can try export/import backup method. This allows you to backup only the tables or users you want to. However, depending on the size of your data, recovery can be long.

bdiehl_at_omni.voicenet.com
Brian Diehl
Database Administrator
Morrisville, PA Received on Sun Jul 16 1995 - 00:00:00 CEST