-
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?
-
Archivelog mode
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
-
Originally posted by shenru
I guess this information is stored in one of the files. But which one?
In a control file.
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|