Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031)

Multiplexing and Maintaining Online Redo Log Files

It is often desirable to add redo log file groups to the database to make sure that the first group is ready to be overwritten before the last group is full. This can often happen if a great deal of activity occurs on the database, and the database is in ARCHIVELOG mode.

To add a group to a database that has two redo log file groups, you would issue an ALTER DATABASE command as follows:

					ALTER DATABASE ADD LOGFILE GROUP 3
					('/mydatabases/mydb1/log3a.dbf', '/mydatabases2/mybd1/log3b.dbf')
					SIZE 1M;
				

Or in Windows

					ALTER DATABASE ADD LOGFILE GROUP 3
					('c:\mydatabases\mydb1\log3a.dbf', 'd:\mydatabases2\mybd1\log3b.dbf')
					SIZE 1M;
				

The generic format of the command is as follows:

ALTER DATABASE [database ...