Re: archivelog v/s nonarchivelog

In a nutshell,

   having a database in archivelog mode allows you to recover your data up to the moment of the crash. In noarchivelog mode, the best you can do after a crash is recover the last backup. Note that only cold backups are possible while in noarchivelog mode (which means that some downtime is always required when doing backups). Also, some operations (such as tablespace point-in-time recovery, log mining of old changes, ...) are only possible in archivelog mode.

Daniel

> what is the major decision factor in deciding whether DB should be in
> Archivelog mode or NonArchivelog mode? What are tradeoffs for each of
> the above modes?
>
> Upto what point after (crash or media failure) can I recover my DB in
> either of the modes?
>
> Example: Your last backup was 09:00 am and then DB crashes at 06:00pm
> (same day). Taking this example into consideration, upto what point
> can I restore my DB?
>
> Any related information on this is appreciated
Received on Wed Aug 06 2003 - 19:19:47 CEST