oracle在线增加redo日志组成员
| 阿里云国内75折 回扣 微信号：monov8 |
| 阿里云国际，腾讯云国际，低至75折。AWS 93折 免费开户实名账号 代冲值 优惠多多 微信号：monov8 飞机：@monov6 |
文档课题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.
说明如上所示成功添加日志组成员.
