Re: curious: v$database.log_type

  • From: Harel Safra <harel.safra@xxxxxxxxx>
  • To: vit.spinka@xxxxxxxxxxxx
  • Date: Tue, 19 Apr 2011 23:21:57 +0300

You can specify that you don't want oracle to automatically archive redo
logs with the archiver process and instead do it manually:
"You can configure an instance to archive filled redo log files
automatically, or you can archive manually."
More here:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/archredo.htm#i1006246

Harel Safra

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

Other related posts: