给一个oracle账号密码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/reoracle账号do01.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';

 

此条目发表在oracle metalink账号分类目录,贴了标签。将固定链接加入收藏夹。