Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Location
    Brazil
    Posts
    59

    Unanswered: Add log file group

    Hi,

    I have seen in my alert log file this message frequently "checkpoint not complete".
    So I decided to add a redo log file group using this command:

    ALTER DATABASE
    ADD LOGFILE GROUP 4('/oracle/dbs/log1c.rdo')
    SIZE 500K;

    My Oracle is 8.1.7.0.1 on Linux Red Heat.
    My doubt is: can I run this command while my database is online??? Do I need to take any care????
    In oracle 8i this command has effect automatically, or should I need to restart the instance????


    Thank you all,
    Nadia

  2. #2
    Join Date
    Apr 2004
    Posts
    35

    you can

    you can add it online no need to bounce the database.

    after adding see for view v$logfile and v$log

    skg

Posting Permissions

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