Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Exp/imp in archivelog mode question

Re: Exp/imp in archivelog mode question

From: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Wed, 05 Jan 2005 21:06:22 +0100
Message-ID: <02iot0pl8meggen8h4atoh7vudr5d2kvbr@4ax.com>


On Wed, 05 Jan 2005 17:46:10 -0200, Roberto <none_at_nowhere.com> wrote:

>One (probably) silly question:
>
>Consider I've made a full backup of a DB with the exp command.
>
>If something happens, and I need to recover with the imp command, what
>is done about the archive logs? Does the imp command delete (or
>overwrite) them? Are they left untouched? Does it automatically apply
>a recover database command to update the DB with those archive logs?
>
>Thank you,
>
>Marcos Roberto

an export doesn't constitute a physical backup, it is a logical backup. It is basically nothing else than a series of INSERT statements.
Consequently, all those inserts are logged.

Recover database has nothing to do with imp.

--
Sybrand Bakker, Senior Oracle DBA
Received on Wed Jan 05 2005 - 14:06:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US