RE: 11g Archive Logs?

From: Robert Freeman <robertgfreeman_at_yahoo.com>
Date: Sat, 18 Aug 2007 20:50:24 -0600
Message-ID: <KEEDIPJOJLCHPPAIDPDOAEJIEEAA.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.

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_at_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_at_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

Received on Sat Aug 18 2007 - 21:50:24 CDT