当前位置:操作系统 > Unix/Linux >>

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

 


CopyRight © 2022 站长资源库 编程知识问答 zzzyk.com All Rights Reserved
部分文章来自网络,