Re: changing archivelog mode in 10g
Date: Tue, 12 Aug 2008 13:30:32 -0700 (PDT)
Bradd--you are not mistaken. I think that log_archive_start was deprecated because there are very very few instances where you'd want it set to false when the database is in archivelog mode, so they just did it for you. I believe it is still there as an underscore parameter for those few environments/occasions where it might need to be = false.
> Maybe I'm missing something. I thought all 'alter system archive log stop'
> did was stop the archiver processes. This didn't turn off archiving for
> database. That has to be done in MOUNT mode. I believe the reason it isn't
> used anymore, is that log_archive_start has been deprecated (the archiver
> processes are automatically stopped/started when needed). My assumption
> that they did this since log_archive_start had a tendency of being missed
> dba's when enabling archivelog mode.
> I could be mistaken.
> Bradd Piontek
> Oracle Blog: http://piontekdd.blogspot.com
> Linked In: http://www.linkedin.com/in/piontekdd