oracle在线增加redo日志组成员

文档课题：oracle在线增加redo日志组成员.

数据库：oracle11.2.0.4

操作过程

SYS@orcl>select group#,bytes/1024/1024 "size(M)",status,archived from v$log;

GROUP# size(M) STATUS ARC

-------------------- ---------------- ---

1 50 INACTIVE YES

2 50 INACTIVE YES

3 50 CURRENT NO

SYS@orcl>select member from v$logfile;

MEMBER

--------------------------------------------------------------------------------

/u01/app/oracle/oradata/orcl/redo03.log

/u01/app/oracle/oradata/orcl/redo02.log

/u01/app/oracle/oradata/orcl/redo01.log

SYS@orcl>alter database add logfile member'/u01/app/oracle/fast_recovery_area/ORCL/onlinelog/redo01b.log' to group 1;

Databasealtered.

SYS@orcl>select group#,members,bytes/1024/1024 "size(M)",status,archived fromv$log;

GROUP# MEMBERS size(M) STATUS ARC

-------------------- ---------- ---------------- ---

1 2 50 INACTIVE YES

2 1 50 INACTIVE YES

3 1 50 CURRENT NO

SYS@orcl>alter database add logfile member'/u01/app/oracle/fast_recovery_area/ORCL/onlinelog/redo02b.log' to group 2;

Databasealtered.

SYS@orcl>select group#,members,bytes/1024/1024 "size(M)",status,archived fromv$log;

GROUP# MEMBERS size(M) STATUS ARC

-------------------- ---------- ---------------- ---

1 2 50 INACTIVE YES

2 2 50 INACTIVE YES

3 1 50 CURRENT NO

SYS@orcl>alter system switch logfile

2 ;

Systemaltered.

SYS@orcl>alter system checkpoint;

Systemaltered.

SYS@orcl>select group#,members,bytes/1024/1024 "size(M)",status,archived fromv$log;

GROUP# MEMBERS size(M) STATUS ARC

-------------------- ---------- ---------------- ---

1 2 50 CURRENT NO

2 2 50 INACTIVE YES

3 1 50 INACTIVE YES

SYS@orcl>alter database add logfile member '/u01/app/oracle/fast_recovery_area/ORCL/onlinelog/redo03b.log'to group 3;

Databasealtered.

SYS@orcl>select group#,members,bytes/1024/1024 "size(M)",status,archived fromv$log;

GROUP# MEMBERS size(M) STATUS ARC

-------------------- ---------- ---------------- ---

1 2 50 CURRENT NO

2 2 50 INACTIVE YES

3 2 50 INACTIVE YES

SYS@orcl>select member from v$logfile;

MEMBER

--------------------------------------------------------------------------------

/u01/app/oracle/oradata/orcl/redo03.log

/u01/app/oracle/oradata/orcl/redo02.log

/u01/app/oracle/oradata/orcl/redo01.log

/u01/app/oracle/fast_recovery_area/ORCL/onlinelog/redo01b.log

/u01/app/oracle/fast_recovery_area/ORCL/onlinelog/redo02b.log

/u01/app/oracle/fast_recovery_area/ORCL/onlinelog/redo03b.log

6rows selected.

说明：如上所示，成功添加日志组成员.