Re: archivelog v/s nonarchivelog

From: Ed Stevens <nospam_at_noway.nohow>
Date: Wed, 06 Aug 2003 10:45:33 -0500
Message-ID: <af82jv41u5r1es19jrp8f0egf51n2r1n47@4ax.com>

On 6 Aug 2003 07:50:19 -0700, hari_om_at_hotmail.com (Hari Om) wrote:

>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 NOARCHIVELOG you can only restore to your last cold backup. What kind of backup did you take at 9:00 am?

In ARCHIVELOG mode, assuming you have protected your archive redologs, you have near complete recoverability. Received on Wed Aug 06 2003 - 10:45:33 CDT