Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Exp/imp in archivelog mode question
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 DBAReceived on Wed Jan 05 2005 - 14:06:22 CST