Increase the SIZE of OracleREDOLOG

I accidentally saw how to increase the SIZE of the ORACLEREDOLOG on the Internet, so I was curious about the case where I needed to increase the value and asked my predecessors. He showed me v $ system _

I accidentally saw how to increase the SIZE of the oracle redo log on the Internet, so I was curious about how to increase this value and asked my predecessors. He showed me v $ system _

I accidentally saw how to increase the SIZE of the Oracle redo log on the Internet, so I was curious about how to increase this value and asked my predecessors. He asked me to check whether the checkpoint completed event exists in v $ system_event.

1. First check the current redo group and status:

Select * from v $ log;

GROUP # THREAD # SEQUENCE # BYTES MEMBERS ARC STATUS

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

FIRST_CHANGE # FIRST_TIME

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

1 1 5089 209715200 1 YES ACTIVE

212991051 month-1-10

2 1 5090 209715200 1 NO CURRENT

212991289 month-1-10

3 1 5087 209715200 1 YES INACTIVE

212991039 month-1-10

2. Delete the INACTIVE log group (redo log group 3 ):

Alter database drop logfile G: \ oracle \ oradata \ orcl \ redo03.log ';

If the status is INACTIVE, switch the log or force the checkpoint to change one of the log groups to INACTIVE status:

Alter system switch logfile;

Alter system checkpoint; -- note that the GLOBAL or LOCAL keyword must be added in the RAC environment.

After switching, check the log group status again:

Select * from v $ log;

3. Add the deleted log group back, but increase the SIZE (for example, the original SIZE of REDO03 is 50 M, and I will change it to 200 M now ):

Alter database add logfile group 3 ('G: \ oracle \ oradata \ orcl \ redo03.log') size 200 M reuse;

4. Repeat the preceding steps (delete one LOG and add it back one by one) until the redo log files of all LOG groups are increased.

5. Note: you cannot increase the SIZE of the redo file by adding members to the log group because the file size of all members in the same log group must be the same.