Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "RAC how to expand the size of online log group". In the operation process of actual cases, many people will encounter such difficulties. Next, let Xiaobian lead you to learn how to deal with these situations! I hope you can read carefully and learn something!

1. View current default log groups

SQL> select GROUP#,THREAD#,SEQUENCE#,BYTES,MEMBERS,ARCHIVED,STATUS from v$log;

GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS

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

1 1 821 52428800 1 YES INACTIVE

2 1 822 52428800 1 NO CURRENT

3 2 241 52428800 1 YES INACTIVE

4 2 242 52428800 1 NO CURRENT

2. Add log groups and members

node 1

alter database add logfile thread 1 group 11 ('+DATA/funddb/onlinelog/redo11a.log','+DATA/funddb/onlinelog/redo11b.log') size 500M;

alter database add logfile thread 1 group 12 ('+DATA/funddb/onlinelog/redo12a.log','+DATA/funddb/onlinelog/redo12b.log') size 500M;

alter database add logfile thread 1 group 13 ('+DATA/funddb/onlinelog/redo13a.log','+DATA/funddb/onlinelog/redo13b.log') size 500M;

node 2

alter database add logfile thread 2 group 14 ('+DATA/funddb/onlinelog/redo14a.log','+DATA/funddb/onlinelog/redo14b.log') size 500M;

alter database add logfile thread 2 group 15 ('+DATA/funddb/onlinelog/redo15a.log','+DATA/funddb/onlinelog/redo15b.log') size 500M;

alter database add logfile thread 2 group 16 ('+DATA/funddb/onlinelog/redo16a.log','+DATA/funddb/onlinelog/redo16b.log') size 500M;

3. switch log

node 1

SQL> alter system switch logfile;

System altered.

node 2

SQL> alter system switch logfile;

System altered.

4. query and wait

SQL> select GROUP#,THREAD#,SEQUENCE#,BYTES,MEMBERS,ARCHIVED,STATUS from v$log;

GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS

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

1 1 821 52428800 1 YES INACTIVE

2 1 822 52428800 1 YES ACTIVE

3 2 241 52428800 1 YES INACTIVE

4 2 242 52428800 1 YES ACTIVE

11 1 823 524288000 2 NO CURRENT

12 1 0 524288000 2 YES UNUSED

13 1 0 524288000 2 YES UNUSED

14 2 243 524288000 2 NO CURRENT

15 2 0 524288000 2 YES UNUSED

16 2 0 524288000 2 YES UNUSED

10 rows selected.

Wait...

SQL> select GROUP#,THREAD#,SEQUENCE#,BYTES,MEMBERS,ARCHIVED,STATUS from v$log;

GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS

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

1 1 821 52428800 1 YES INACTIVE

2 1 822 52428800 1 YES INACTIVE

3 2 241 52428800 1 YES INACTIVE

4 2 242 52428800 1 YES INACTIVE

11 1 823 524288000 2 NO CURRENT

12 1 0 524288000 2 YES UNUSED

13 1 0 524288000 2 YES UNUSED

14 2 243 524288000 2 NO CURRENT

15 2 0 524288000 2 YES UNUSED

16 2 0 524288000 2 YES UNUSED

10 rows selected.

5. Delete old log groups

SQL> alter database drop logfile group 1;

Database altered.

SQL> alter database drop logfile group 2;

Database altered.

SQL> alter database drop logfile group 3;

Database altered.

SQL> alter database drop logfile group 4;

Database altered.

6. Confirm completion of expansion of log group

SQL> select GROUP#,THREAD#,SEQUENCE#,BYTES,MEMBERS,ARCHIVED,STATUS from v$log;

GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS

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

11 1 823 524288000 2 NO CURRENT

12 1 0 524288000 2 YES UNUSED

13 1 0 524288000 2 YES UNUSED

14 2 243 524288000 2 NO CURRENT

15 2 0 524288000 2 YES UNUSED

16 2 0 524288000 2 YES UNUSED

"RAC how to expand the online log group size" content is introduced here, thank you for reading. If you want to know more about industry-related knowledge, you can pay attention to the website. Xiaobian will output more high-quality practical articles for everyone!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.