增加日志文件组

最新推荐文章于 2023-04-23 09:50:47 发布

cn00909332

最新推荐文章于 2023-04-23 09:50:47 发布

阅读量293

点赞数

文章标签：数据库

查询我的日志文件组
SYS@ENMOEDU> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_
---------- ------- ------- ------------------------- ---
3 ONLINE /u01/app/oracle/oradata/E NO
NMOEDU/redo03.log

1 ONLINE /u01/app/oracle/oradata/E NO
NMOEDU/redo01.log

添加日志文件组
SYS@ENMOEDU> alter database add logfile group 2 '/u01/app/oracle/oradata/ENMOEDU/redo02.log';

查询日志文件组
SYS@ENMOEDU> select * from v$logfile;

GROUP# STATUS TYPE MEMBER IS_
---------- ------- ------- ------------------------- ---
3 ONLINE /u01/app/oracle/oradata/E NO
NMOEDU/redo03.log

2 ONLINE /u01/app/oracle/oradata/E NO
NMOEDU/redo02.log

1 ONLINE /u01/app/oracle/oradata/E NO
NMOEDU/redo01.log

一般呢我们建议每组日志的成员为两个
所以呢我们现在添加我们的组成员
l SYS@ENMOEDU> alter database add logfile member '/u01/app/oracle/oradata/ENMOEDU/redo01a.log' to group 1;
Database altered.

查询日志文件组成员

SYS@ENMOEDU> select * from v$logfile;

GROUP# STATUS TYPE MEMBER IS_
---------- ------- ------- ------------------------- ---
3 ONLINE /u01/app/oracle/oradata/E NO
NMOEDU/redo03.log

2 ONLINE /u01/app/oracle/oradata/E NO
NMOEDU/redo02.log

1 ONLINE /u01/app/oracle/oradata/E NO
NMOEDU/redo01.log

1 INVALID ONLINE /u01/app/oracle/oradata/E NO
NMOEDU/redo01a.log

以上我们就是我们的日志文件组的添加！

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/30176559/viewspace-1668507/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/30176559/viewspace-1668507/