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@xxxxxxxxx> 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@xxxxxxxxxxxx> > >> 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 >> -- >> //www.freelists.org/webpage/oracle-l >> >> >> > > > -- > Niall Litchfield > Oracle DBA > http://www.orawin.info >