archive log mode
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: archive log mode

  1. #1
    Join Date
    May 2002
    Posts
    35
    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?

  2. #2
    Join Date
    Jul 2000
    Location
    Amsterdam
    Posts
    234

    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


  3. #3
    Join Date
    Apr 2001
    Location
    Czechia
    Posts
    712
    Originally posted by shenru
    I guess this information is stored in one of the files. But which one?
    In a control file.

  4. #4
    Join Date
    May 2002
    Posts
    35
    Thank you very much!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width