Adding online redo log groups and examples of adding online redo log groups to an existing oracle database
meda Changed status to publish 08/03/2022
We use the ADD LOGFILE GROUP SQL statement to add more log groups to our existing oracle database.
SQL > ALTER DATABASE ADD LOGFILE GROUP <number> (‘path of logfile1′,’path of logfile2’,’3’…) SIZE <>;
Example:
1 2 3 4 5 6 7 8 9 | SQL> conn sys/orcl@to_primary as sysdbaConnected.---- Create log group with two redo log membersSQL> alter database add logfile group 8 2 ('D:\app\Admin\virtual\oradata\orcl\redoa8.log', 3 'D:\app\Admin\virtual\oradata\orcl\redob8.log') SIZE 50M; Database altered. SQL> |
NOTE: It is recommended that the log files to be created should have the same size with the already created log files.
meda Edited answer 22/02/2022