Re: v$archived_log ==> applied=no

  • From: Carel-Jan Engel <cjpengel.dbalert@xxxxxxxxx>
  • To: stellr@xxxxxxxxxx
  • Date: Sat, 04 Feb 2006 22:42:30 +0100

That's not a synonym.

Standby redo log files can be created and act similar like the online
redo log files if a database is in standby mode.
The RFS process (which resides on the standby) is then able to write the
received redo stream in the standby redo log files. This will reduce the
you need to create this type of redo log files.
I always create them on the primary, as a part of the preparation
process for the creation of a standby. The standby redo log files are
available on the primary as well then, as soon as it needs to become a
One might think why the ordinary online redo log files aren't used for
this purpose. A reason I can think of is the Logical Standby phenomenon.
This type of database is open for read/write. It will therefor need its
online redo log files, and they are not available for use by the RFS
process. If I'd written this software I wouldn't have created two
different RFS code branches, just because it will save the space of a
couple of logfiles on disk. 

Bottom line:

Try to reread the concept manual, and find the differences between
online, standby and archived redo log files! They all have their own

Best regards,

Carel-Jan Engel

If you think education is expensive, try ignorance. (Derek Bok)

On Sat, 2006-02-04 at 09:45 -0500, Ray Stell wrote:

> On Fri, Feb 03, 2006 at 04:35:34PM -0800, GovindanK wrote:
> > 434341;  I wonder what could have caused the primary controlfile to
> > think these two log files are not applied.  I checked v$log_history ,
> It is interesting that the data guard concepts guide refer to 
> archive redo logs alternately as "standby redo log files."
> --

Other related posts: