Re: archivelog v/s nonarchivelog

From: michael ngong <mngong_at_yahoo.com>
Date: 6 Aug 2003 12:14:08 -0700
Message-ID: <ecf365d5.0308061114.28ecb6d5@posting.google.com>

hari_om_at_hotmail.com (Hari Om) wrote in message news:<d1d5ebe4.0308060650.82a74af_at_posting.google.com>...
> 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

In simplistic terms

Noarchivelog mode
The database can be restored only to the last time you backed up. Archivelog mode
Database can be restored to a point in time There is a possibility to backup the database without bringing it down(hot backups)
Michael Tubuo Ngong Received on Wed Aug 06 2003 - 14:14:08 CDT