Re: Help! Backup & Recovery in Oracle8 enterprise edition

Sorry but I need to understand this better.

For simple backup purposes, wouldn't an export be a good idea. We do not require the database to go back to say 1:35 am last wednesday. Our requirement is simply to restore the database back to what it was on Thursday morning. Our system is not usually used at night so we can safely shut it down.

Wouldn't an export be better in this case.

Why would we need to apply redologs, if we have a full export ? I thought that the main purpose of an archive redologs is to bring the dbf's up to date. But in the case of an export we do not have this problem.

BTW, what is a "read-consistency failure".

I would really appreciate an answer.

Jeremiah Wilton <jeremiah_at_wolfenet.com> wrote in message news:38553C4D.9E3B72B7_at_wolfenet.com...
> TAD wrote:
> >
> > Personally, I prefer to use a full export. We export the complete
database
> > everynight, just to be on the safe side. If your database is not huge,
and
> > you can afford the backup media, then IMHO this is the best approach
>
> An export is probably the worst backup/recovery method. With exports as
> your only backup:
>
> - You cannot reover to an arbitrary point in time by applying recovery.
> - You cannot apply media recovery (archived redologs) at all.
> - Exports take longer than backups and are more resource intensive.
> - Exports are prone to read-consistency failures.
> - Imports take longer than restores and are more resource intensive.
>
> From the Oracle8 Backup and Recovery Guide, Release 8.0, A58396-01:
>
> "Database exports are not a substitute for physical backups and cannot
> provide the same complete recovery advantages that the built-in
> functionality of Oracle offers."
Received on Mon Dec 13 1999 - 19:12:43 CST