DEST_10 has the USE_DB_RECOVERY_FILE_DEST always set. That is the default setting when the FRA is set (db_recovery_file_dest). Dest_1 should not ever get set in this case. It's the DEST_1 that is always set to the default setting no mater what I do. I think it's thinking that DEST_10 is not set for some reason, and setting the default value. RF Robert G. Freeman Oracle Consultant/DBA/Author Principal Engineer/Team Manager The Church of Jesus Christ of Latter-Day Saints Father of Five, Husband of One, Author of various geeky computer titles from Osborne/McGraw Hill (Oracle Press) Oracle Database 11g New Features Now Available for Pre-sales on Amazon.com! BLOG: http://robertgfreeman.blogspot.com/ Sig V1.2 -----Original Message----- From: Roby Sherman [mailto:rxsherm@xxxxxxxxxxxxx] Sent: Saturday, August 18, 2007 8:44 PM To: Robert Freeman Cc: oracle-l Subject: Re: 11g Archive Logs? Right, but the difference is that I DO have log_archive_dest_10 set... The only problem is dest_1 is also getting set at the same time... If you restart and look in V$ARCHIVE_DEST, you don't show anything for dest_10? SQL> select dest_name, destination from v$archive_dest; DEST_NAME ------------------------------------------------------------------------ -------- DESTINATION ------------------------------------------------------------------------ -------- LOG_ARCHIVE_DEST_1 /opt/dbms/oracle/product/11.1.0/dbs/arch LOG_ARCHIVE_DEST_2 LOG_ARCHIVE_DEST_3 DEST_NAME ------------------------------------------------------------------------ -------- DESTINATION ------------------------------------------------------------------------ -------- LOG_ARCHIVE_DEST_4 LOG_ARCHIVE_DEST_5 LOG_ARCHIVE_DEST_6 DEST_NAME ------------------------------------------------------------------------ -------- DESTINATION ------------------------------------------------------------------------ -------- LOG_ARCHIVE_DEST_7 LOG_ARCHIVE_DEST_8 LOG_ARCHIVE_DEST_9 DEST_NAME ------------------------------------------------------------------------ -------- DESTINATION ------------------------------------------------------------------------ -------- LOG_ARCHIVE_DEST_10 USE_DB_RECOVERY_FILE_DEST On Aug 18, 2007, at 8:17 PM, Robert Freeman wrote: > I think so too, when you are using the db_recovery_file_dest > parameter, > log_archive_dest_10 is supposed to default to > USE_DB_RECOVERY_FILE_DEST, and > it's not. But db_recovery_file_dest is set. Since the default *_10 > parameter > is not set, it's ALSO sending the logfile to the default location. > > RF > > Robert G. Freeman > Oracle Consultant/DBA/Author > Principal Engineer/Team Manager > The Church of Jesus Christ of Latter-Day Saints > Father of Five, Husband of One, > Author of various geeky computer titles > from Osborne/McGraw Hill (Oracle Press) > Oracle Database 11g New Features Now Available for Pre-sales on > Amazon.com! > BLOG: http://robertgfreeman.blogspot.com/ > Sig V1.2 > > -----Original Message----- > From: Roby Sherman [mailto:rxsherm@xxxxxxxxxxxxx] > Sent: Saturday, August 18, 2007 7:42 PM > To: Robert Freeman > Cc: oracle-l > Subject: Re: 11g Archive Logs? > > > I think you got yourself a bug there... Here's what I found (Fedora > Linux 32-bit x86): > > 1> log_archive_dest_1 = 'location=/mypath' works as expected. > > 2> If I do ALTER SYSTEM ... SCOPE=both for: > ----log_archive_dest_1='' > ----db_recovery_file_dest='/mypath' > > then SELECT DEST_NAME, DESTINATION FROM V$ARCHIVE_DEST, I get: > > log_archive_dest_1 is empty > show parameter log_archive_dest_1 is empty > > 3> If I *RESTART* the instance and then SELECT DEST_NAME, DESTINATION > FROM V$ARCHIVE_DEST, I get: > > log_archive_dest_1 = $ORACLE_HOME/dbs/arch > show parameter log_archive_dest_1 is still empty > > > Geez, that's a pretty basic QA test. Doesn't Oracle test ANYTHING > anymore? :) > > > --Roby > > > On Aug 18, 2007, at 7:16 PM, Roby Sherman wrote: > >> Hmmmm... Not seeing that on linux... Although, standby_archive_dest >> seems to be defaulting to that location... interesting... Does your >> database think its somehow running Data Guard? >> >> What does v$archive_dest show? >> >> >> >> On Aug 18, 2007, at 5:29 PM, Robert Freeman wrote: >> >>> Any of you fine people install 11g yet and find that your new 11g >>> database >>> was creating archived redo logs in $ORACLE_HOME/dbs?? I've got a >>> database >>> that I created with the DBCA that is doing just that, and I'll be >>> darned if >>> I can figure out why. >>> >>> RF >>> >>> >>> Robert G. Freeman >>> Oracle Consultant/DBA/Author >>> Principal Engineer/Team Manager >>> The Church of Jesus Christ of Latter-Day Saints >>> Father of Five, Husband of One, >>> Author of various geeky computer titles >>> from Osborne/McGraw Hill (Oracle Press) >>> Oracle Database 11g New Features Now Available for Pre-sales on >>> Amazon.com! >>> BLOG: http://robertgfreeman.blogspot.com/ >>> Sig V1.2 >>> >>> -- >>> //www.freelists.org/webpage/oracle-l >>> >>> >> > -- //www.freelists.org/webpage/oracle-l