archivelog v/s nonarchivelog

From: Hari Om <hari_om_at_hotmail.com>
Date: 6 Aug 2003 07:49:54 -0700
Message-ID: <d1d5ebe4.0308060649.768c5b2d_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 Received on Wed Aug 06 2003 - 16:49:54 CEST

Original text of this message