Create Redolog Group and its Members

How to create Redo Log Groups and Members on filesystem and ASM Diskgroup

Create Redo Log member with a specific group number

on Filesystem

ALTER DATABASE ADD LOGFILE GROUP 1('/d01/oradata/orasbt1/redo1a.log', '/d02/oradata/orasbt1/redo1b.log') SIZE 100M;

on ASM Diskgroup

ALTER DATABASE ADD LOGFILE GROUP 1('+REDO', '+REDO') SIZE 100M; -- 2 members will be created on REDO disk group

Create new Redo Log members for an existing group

on Filesystem

ALTER DATABASE ADD LOGFILE MEMBER '/d03/oradata/orasbt1/redo1c.log' TO GROUP 1;

on ASM Diskgroup

ALTER DATABASE ADD LOGFILE MEMBER '+REDO' TO GROUP 1;

 

 

Examples

 

ALTER DATABASE ADD LOGFILE GROUP 1('/redoa/oragen1d/redo01a.log', '/redob/oragen1d/redo01b.log') SIZE 100M;
ALTER DATABASE ADD LOGFILE GROUP 2('/redoa/oragen1d/redo02a.log', '/redob/oragen1d/redo02b.log') SIZE 100M;
ALTER DATABASE ADD LOGFILE GROUP 3('/redoa/oragen1d/redo03a.log', '/redob/oragen1d/redo03b.log') SIZE 100M;
ALTER DATABASE ADD LOGFILE GROUP 4('/redoa/oragen1d/redo04a.log', '/redob/oragen1d/redo04b.log') SIZE 100M;
ALTER DATABASE ADD LOGFILE GROUP 5('/redoa/oragen1d/redo05a.log', '/redob/oragen1d/redo05b.log') SIZE 100M;