Re: [NO]ARCHIVELOG

On Fri, 06 Jan 2006 16:02:46 +0100, Joachim Hofmann <speicher_at_freenet.de> wrote:

>OK, i set the databases in archivelog mode:
>
>ALTER DATABASE ARCHIVELOG;
>
>But what happens when the DB starts up next? will it still run in Archivelog
>mode? (Info: DB has no spfile, as SHOW PARAMETERS told me).
>
>Joachim

Yes it will. [NO]Archivelog is a property of the database. Note: you have manual archiving and automatic archiveing. For automatic archiving init.ora |sp<sid>.ora log_archive_start should be set to true.

You can also just
create spfile from pfile

to get a spfile.

--
Sybrand Bakker, Senior Oracle DBA