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