Re: Archive redo log file

agarwalp_at_eeism.com wrote:
> In the Oracle Administrators guide it is mentioned that ArchiveLog mode
> protects the data in case of system/disk failure but NOARCHIVELOG mode
> does not.
> Now if the Archive log files are in the same system as redo log files,
> then in case of system failure if we are able to retain data from
> archive log then we should be able to retain from redo log file also.
>
> I hope my question is clear
>

Your question is not clear because you did not ask a question.

Your statement "if the Archive log files are in the same system as redo log files, then in case of system failure if we are able to retain data from archive log then we should be able to retain from redo log file also." is generally true.

Daniel wrote:
 > Archived log files are often
 > shipped real-time to a different location/server.

So far, so good.

 > That also ensures
 > that the archived log files don't fill up a server disk too quickly,
 > before you realized what happened.
 >

No, shipping archived redo logs off-server does not necessarily clear them off the primary.

 > Daniel
 >

Consider using Data Guard. Consider using RMAN. User-managed media recovery is possible for an ARCHIVELOG mode database, but it requires some practice and some understanding. Not to say that RMAN and DG don't also require the same, but they are much more automated, and tend to require less of it.

-Mark Bole Received on Wed Jun 29 2005 - 20:27:53 CDT