Oracle 日志文件多路复用
多路复用 PRODCDB 数据库的所有日志组中的 redo log 文件,存放目录: /u01/app/oracle/oradata/MREDO
1.创建目录
mkdir -p /u01/app/oracle/oradata/MREDO
2.查看日志文件路径
select group#,member from v$logfile;
3.增加日志组文件
alter database add logfile member '/u01/app/oracle/oradata/MREDO/redo01.log'
to group 1;
alter database add logfile member '/u01/app/oracle/oradata/MREDO/redo02.log'
to group 2;
alter database add logfile member '/u01/app/oracle/oradata/MREDO/redo03.log'
to group 3;
4.查看日志文件
select group#,member from v$logfile;
原文地址:https://blog.csdn.net/dnuiking/article/details/142657741
免责声明:本站文章内容转载自网络资源,如本站内容侵犯了原著者的合法权益,可联系本站删除。更多内容请关注自学内容网(zxcms.com)!