Redo log management

Redo log management

1. add a log group alter database add logfile group 1 ('/u02/oradata/bolan/redo01.log') size 100 m; 2. add the log group member alter database add logfile member '/u02/oradata/bolan/redo01.log' to group 1; 3. delete the alter database drop logfile group 1; 4. delete the alter database drop logfile member '/u02/oradata/bolan/redo01.log'; 1. add the Image Log alter database add standby logfile group 1 ('/u02/oradata/bolan/redo01.log') size 100 m; 2. add the Image Log member alter database add standby logfile member '/u02/oradata/bolan/redo01.log' to group 1; 3. delete the Image Log alter database drop standby logfile group 1; 4. add the mirror log member alter database drop standby logfile member '/u02/oradata/bolan/redo01.log ';