查询我的日志文件组
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
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
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.
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
以上我们就是我们的日志文件组的添加！
所以呢我们现在添加我们的组成员
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博客 ” ，链接：https://blog.itpub.net/30176559/viewspace-1668507/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
检验oracle 最少日志组为两组
下一篇：
手工备份表空间
请登录后发表评论
登录
全部评论
