redo log的管理
redo log的管理
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';