redo log的管理

最新推荐文章于 2024-06-27 14:41:53 发布

原创最新推荐文章于 2024-06-27 14:41:53 发布 · 1.5k 阅读

0 ·

CC 4.0 BY-SA版权

ORACLE 专栏收录该内容

42 篇文章

订阅专栏

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';