DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=Received:X-YMail-OSG:From:To:Cc:Subject:Date:Message-ID:MIME-Version:Content-Type:Content-Transfer-Encoding:X-Priority:X-MSMail-Priority:X-Mailer:X-MimeOLE:Importance:In-Reply-To;
  b=CUOqqzhCfFY77rp8bejevzcIedhkUK4SvrQjxxMlbVKMDRaJ6geVmhFMrTqf8sfLbpszI5L+4T4K6D0pPOiPdWyI62OA5JWQ2Pp+6BYFJVC4VtGhRzZ/a2FNC5F/MaLHS7OGiPZYVBcqcffAk9g9MuA84SrehHiYiBd8QHpVzjw=  ;
From: "Robert Freeman" <robertgfreeman@yahoo.com>
To: "Roby Sherman" <rxsherm@interealm.com>
Cc: "oracle-l" <oracle-l@freelists.org>
Subject: RE: 11g Archive Logs?
Date: Sat, 18 Aug 2007 20:50:24 -0600
Message-ID: <KEEDIPJOJLCHPPAIDPDOAEJIEEAA.robertgfreeman@yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
In-Reply-To: <3B908785-071A-41D9-8F96-41BF29457445@interealm.com>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: robertgfreeman@yahoo.com

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@interealm.com]
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@interealm.com]
> 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
>>>
>>> --
>>> http://www.freelists.org/webpage/oracle-l
>>>
>>>
>>
>

--
http://www.freelists.org/webpage/oracle-l