Re: backup versus export of db

From: Steve Butler <sbut-is_at_seatimes.com>
Date: 1995/11/22
Message-ID: <Pine.SUN.3.91.951122113006.27655A-100000_at_seatimes>#1/1

On Tue, 21 Nov 1995, Chuck Hamilton wrote:
> schaller_at_cui.unige.ch (Gerard Schaller) wrote:
> >It depends... When oracle is running you cannot be sure that all
> >files are synchronized (same header number) during the system
> >backup (it is checked at the startup) . Thus you will be sure to restore your entire database only if
>
> Is it safe to do an export when the database is being updated? If so,
> are there any precautions that should be taken during the update?
> Also, what about the control and redo log files? If you needed to
> recover the entire datbase, wouldn't you need these too? Does an
> export back these up?

The problem with an export is the inability to use it for a roll forward recovery with your archived redo logs. You will be unable to import your data and reliably apply the archived log files.

However, an export is a good thing to have around if all your other backup media breaks. At least you have something.

+----------------------------------------------------+
| Steve Butler          Voice:  206-464-2998         |
| The Seattle Times       Fax:  206-382-8898         |
| PO Box 70          Internet:  sbut-is_at_seatimes.com |
| Seattle, WA 98111    Packet:  KG7JE_at_N6EQZ.WA       |
+----------------------------------------------------+

All standard and non-standard disclaimers apply. All other sources are annonymous. Received on Wed Nov 22 1995 - 00:00:00 CET