1.添加日志组
alter database add logfile group 1 ('/u02/oradata/bolan/redo01.log') size 100m;
2.添加日志组成员
alter database add logfile member '/u02/oradata/bolan/redo01.log' to group 1;
3.删除日志组
alter database drop logfile group 1;
4.删除日志组成员
alter database drop logfile member '/u02/oradata/bolan/redo01.log';
1.添加镜像日志
alter database add standby logfile group 1 ('/u02/oradata/bolan/redo01.log') size 100m;
2.添加镜像日志组成员
alter database add standby logfile member '/u02/oradata/bolan/redo01.log' to group 1;
3.删除镜像日志
alter database drop standby logfile group 1;
4.添加镜像日志组成员
alter database drop standby logfile member '/u02/oradata/bolan/redo01.log';