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: DA Morgan <damorgan_at_x.washington.edu>
Date: Wed, 05 Jan 2005 15:49:00 -0800
Message-ID: <41dc7bbb$1_3@127.0.0.1>


Roberto 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

You don't have a backup and you can not perform recovery. Exports and imports do not constitute a backup and you will most likely find that what you have is toast: burnt toast.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Wed Jan 05 2005 - 17:49:00 CST

Original text of this message

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