如何增加日志组成员到既有日志组?

2019独角兽企业重金招聘Python工程师标准>>>

比如:

我们目前系统中有以下日志组:

SQL> select group#,sequence#,members ,status ,archived from v$log;

GROUP# SEQUENCE# MEMBERS STATUS ARC

---

1 28 1 CURRENT NO

2 26 1 INACTIVE YES

3 27 1 INACTIVE YES

发现每组都只有一个成员,我们想手工增加一个文件到既有组上去:

1* select group#,member from v$logfile

GROUP# MEMBER

 

3 /oracle/app/oracle/oradata/sztech1/redo03.log

2 /oracle/app/oracle/oradata/sztech1/redo02.log

1 /oracle/app/oracle/oradata/sztech1/redo01.log

我们给组一增加一个镜像成员,方法如下:

alter database add logfile member '/oracle/app/oracle/oradata/sztech1/redo01b.log' to group 1;

之后,我们再查询,文件应该增加上去:

1* select group#,member from v$logfile

GROUP# MEMBER

 

3 /oracle/app/oracle/oradata/sztech1/redo03.log

2 /oracle/app/oracle/oradata/sztech1/redo02.log

1 /oracle/app/oracle/oradata/sztech1/redo01.log

1 /oracle/app/oracle/oradata/sztech1/redo01b.log

SQL> select group#,sequence#,members ,status ,archived from v$log;

GROUP# SEQUENCE# MEMBERS STATUS ARC

---

1 28

2 CURRENT NO

2 26 1 INACTIVE YES

3 27 1 INACTIVE YES

至此,日志组成员增加上去了.

转载于:https://my.oschina.net/u/3635497/blog/3041919