ALTER DATABASE
  ADD LOGFILE [GROUP group_number]
  ('filename','filename'...) SIZE integer [REUSE];

1. This is the opening screen that you will see after you start Storage Manager and connect to your database. Click the + sign next to the Database icon to expand the tree.
2. Click the Redo Log Groups folder to see the current list of redo log groups for the database.
3. Oracle will display a list of redo log groups currently in the database. In this case, there are currently five groups. To create a new group, begin by right-clicking on the Redo Log Groups folder.
4. Select Create from the fly-out menu.
5. Storage Manager will open the Create Redo Log Group window. Notice that Storage Manager has preselected both a size and a filename. You could edit those choices, but for this simulation, we will accept them. Go ahead and click the Create button to create the new group.
6. Storage Manager will display a dialog confirming that it has created the new redo log group.

To create a fifth log file group for the COIN database, assuming that you have four to start with, you could issue a command like this:

ALTER DATABASE
ADD LOGFILE GROUP 5

('D:\ORACLE\ORADATA\COIN\REDOCOIN05A',

'E:\ORACLE\ORADATA\COIN\REDOCOIN05B') SIZE 10m;

Oracle also allows you to add log file members to an existing group. To do that, use this form of theALTER DATABASE command:

ALTER DATABASE
ADD LOGFILE MEMBER
'new_filename' [REUSE] 'new_filename' [REUSE]...
TO GROUP group_number;
TO ('existing_filename','existing_filename'...);

A command script or syntax reference for modifying a database, specifically for altering the log file configuration in a database system.
Description of the Command

1. Command Structure: This is an SQL command intended to alter the log file settings of a database, which is crucial for data recovery and management purposes.
2. Command Keywords:
   • ALTER DATABASE: This is the main command used to make changes to the database structure.
   • ADD LOGFILE MEMBER: This clause is used to add new log file members to a log file group.
3. Parameters:
   • new_filename: Specifies the names of new log files to be added. The option [REUSE] indicates that the database should reuse an existing file if it already exists, rather than creating a new one.
   • group_number: Identifies the log file group to which the new members should be added.
   • existing_filename: Specifies existing log files to which the new log file members will be associated.

This command is typical in database systems that require precise control over log file management, such as Oracle or SQL Server, where log files play a critical role in data integrity and recovery mechanisms.

To add a member to group 5, the group that we just created, you could issue a command like this:

ALTER DATABASE
ADD LOGFILE MEMBER

'G:\ORACLE\ORADATA\COIN\REDOCOIN05C'
TO GROUP 5;

You do not need to specify a size when creating a new member. Oracle will create the file sized to match the existing group members. Note that in this example, the group was identified by number. That's the easiest approach to take. Identifying a group by listing all the member filenames is a very tedious and error-prone process.
Note: Your ability to create new members in a log file group is limited by the value that you specified forMAXLOGMEMBERS when you first created the database. Your ability to create new groups is limited by the value specified forMAXLOGFILES.

Simulation

You can use Enterprise Manager's Storage Manager application to create redo log groups. This following series of images shows you how:

1. This is the opening screen that you will see after you start Storage Manager and connect to your database. Click the + sign next to the Database icon to expand the tree.
2. Click the Redo Log Groups folder to see the current list of redo log groups for the database.
3. Oracle will display a list of redo log groups currently in the database. In this case, there are currently five groups. To create a new group, begin by right-clicking on the Redo Log Groups folder.
4. Select Create from the fly-out menu.
5. Storage Manager will open the Create Redo Log Group window. Notice that Storage Manager has preselected both a size and a filename. You could edit those choices, but for this simulation, we will accept them. Go ahead and click the Create button to create the new group.
6. Storage Manager will display a dialog confirming that it has created the new redo log group.

In the next lesson, you will learn how to drop redo log files.

For an exercise, try your hand at creating a new redo log file group for the COIN database.
Creating Redo Groups - Exercise