Archivelog mode
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Archivelog mode

  1. #1
    Join Date
    Aug 2001
    Posts
    16
    Hello DBAs,

    OS:Win NT4 (Production Database 8.1.5)

    Our database is running noarchivelog mode.
    Can anyone tell me how to change to archive log mode
    Should I change anything in parameter file.

    Please help me.

    Thanx

  2. #2
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    1. Shutdown database
    2. Set following parameters in init.ora

    for automatic archiving of redo logs,
    path for the archive redo logs..
    and format for the arch redo logs

    log_archive_start = true
    log_archive_dest = "location=D:\oracle\oradata\ORCL\arch"
    log_archive_format = ARCH_T%TS%S.ARC

    3. startup database and mount, don't OPEN
    svrmgr>STARTUP MOUNT;
    svrmgr>ALTER DATABASE ARCHIVELOG
    svrmgr>ALTER DATABASE OPEN;

    4.SELECT log_mode from v$database;

    should show u ARCHOVELOG


    HTH

    Sameer

  3. #3
    Join Date
    Aug 2001
    Posts
    16

    Thanx

    Thank u so much Mr.Sameer

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