archive log mode

[shenru]

I have one question regarding oracle archive log mode. When we create a database, we can specify it's archive log or noarchive log in the script.

Once the database is created, where is this parameter stored? I know in the initial file we can specify auto start archive or not. But it's not the mode setting.

We did an experimentation: we create a dummy instance in a server and copy initial file, redo log files, control files and data files from another archive log database. Then we find the newly created database is also archive log. So I guess this information is stored in one of the files. But which one?

[tycho]

Hi,

If you have a test database do:

select * from v$database;

Then shutdown this database.
startup mount this database.

do

alter database noarchivelog;

alter database open;

Do again

select * from v$database;

HTH

Tycho

[ales]

Originally posted by shenru
I guess this information is stored in one of the files. But which one?

In a control file.

[shenru]

Thank you very much!