Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Problem
>Subject: Problem
>From: francis_at_mail.com (FL)
>Date: 2/17/01 7:31 AM GMT Standard Time
>Message-id: <3a8e28bb.4294605_at_news.i-cable.com>
>
>What is the difference of noarchivelog mode or archivelog mode?
>
Hi Francis,
Archivelog mode means that the Oracle online redo logs are archived to
separate files before the are re-used by the database. This means that if you
have a backup of the database and all archived logs generated since the backup
then you should be able to restore your database to the point of failure.
If you are running noarchivelog mode and any of your online redo logs have
been overwritten by the database - commonly called 'wrapped' - since the last
backup then you will only be able to recover to the time of the last backup.
Regards,
Rob
Received on Sat Feb 17 2001 - 04:15:45 CST