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:
ADD LOGFILE GROUP 4('/oracle/dbs/log1c.rdo')
My Oracle is 220.127.116.11.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????