Re: curious: v$database.log_type

From: Harel Safra <harel.safra_at_gmail.com>
Date: Tue, 19 Apr 2011 23:31:45 +0300
Message-ID: <BANLkTikOz1bQJd6sB7ZZ=Th+dC2jd_9+2w_at_mail.gmail.com>

They probably added it as a database property as part of the deprecating log_archive_start.
The MANUAL part of "ALTER DATABASE ARCHIVELOG MANUAL;" needed to set this isn't found in 8i:
http://download.oracle.com/docs/cd/A87860_01/doc/server.817/a85397/stateme3.htm#2048938

Harel Safra

On Tue, Apr 19, 2011 at 11:21 PM, Niall Litchfield < niall.litchfield_at_gmail.com> wrote:

> hmm, I'd have expected it the other way around, prior to 10g you had to
> explicitly start automatic archival (via log_archive_start). In those days
> if you enabled archiving but didn't set log_archive_start true then you had
> to manually archive. I don't have an 8/9 to experiment on to show this
> though.
>
> 2011/4/19 Vit Spinka <vit.spinka_at_vitspinka.cz>
>
>> Hi all,
>>
>> I just came across something I never heard about so far: Reference manual
>> states that v$database.log_type can be NOARCHIVELOG, ARCHIVELOG or MANUAL.
>> The question is: what does "MANUAL" mean?
>>
>> For sake of completeness:
>> It's mentioned in docs for 10.1, 10.2, 11.1 and 11.2.
>> 9.2 does not list the possible values at all.
>> 8.1.7 lists NOARCHIVELOG, ARCHIVELOG.
>> [That's all versions I found on tahiti.oracle.com]
>> Metalink also did not help in shedding any light.
>>
>> Any clues?
>> Vit
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>
>
>
> --
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info
>

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

Received on Tue Apr 19 2011 - 15:31:45 CDT