RE: curious: v$database.log_type

I know that in pre 10 releases that you had the log_archive_start parameter, which indicates if full online redo logs had to be archived automatically or not. If this parameter was set to false, you had to manually archive the full online redo logs.

This parameter became deprecated in 10.1, but you can still see it when executing "archive log , list", which contains the line "Automatic archival"

http://download.oracle.com/docs/cd/B10501_01/server.920/a96536/ch198.htm#REFRN10092 http://download.oracle.com/docs/cd/B14117_01/server.101/b10763/changes.htm#i627214

regards,  

Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge_at_uptime.be
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Vit Spinka Sent: dinsdag 19 april 2011 22:05
To: oracle-l_at_freelists.org
Subject: curious: v$database.log_type

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

--

http://www.freelists.org/webpage/oracle-l Received on Tue Apr 19 2011 - 15:35:06 CDT