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?