Re: Exp/imp in archivelog mode question

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Fri, 07 Jan 2005 09:41:04 +0100
Message-ID: <crlhv0$9d$2@news.BelWue.DE>

ana wrote:
> "NetComrade" <netcomradeNSPAM_at_bookexchange.net> wrote in message
> news:41dc719e.4159896304_at_localhost...
>

>>Nothing is done about archived logs.. and imp will just create more.
>>Archived logs are for other types of recovery (e.g. from a cold/hot
>>backup, plus applying archived logs on top)

>
>
> Archived redo logfiles can only be applied to a COLD backup
> if you really force the situation. It can be done, but you have to
> know what you are doing to succeeed to "roll forward".

Bollocks. The temperature of your backup has nothing to do with it.

>
> FWIW - IMO exp/imp is NOT a backup strategy.
> It is a mechanism to facilitate restoration when a small number of tables
> get clobbered.
>
>

That one you've got right.

Cheers,

Holger Received on Fri Jan 07 2005 - 02:41:04 CST