Assume that there are three log groups, each of which has one member and the size of each member is 1 MB. Now we want to change the size of all three log groups to 10 MB.
1. create two new log groups
Alter database add logfile group 4 ('d: \ Oracle \ ORADATA \ ORADB \ REDO04_1.LOG ') size 1024 k;
Alter database add logfile group 5 ('d: \ ORACLE \ ORADATA \ ORADB \ REDO05_1.LOG ') size 1024 k;
2. Switch the current log to a new log group.
Alter system switch logfile;
Alter system switch logfile;
3. Delete the old log Group
Alter database drop logfile group 1;
Alter database drop logfile group 2;
Alter database drop logfile group 3;
4. delete files in the original log group 1, 2, and 3 in the operating system
5. Rebuild log groups 1, 2, and 3
Alter database add logfile group 1 ('d: \ ORACLE \ ORADATA \ ORADB \ REDO01_1.LOG ') size 10 M;
Alter database add logfile group 2 ('d: \ ORACLE \ ORADATA \ ORADB \ REDO02_1.LOG ') size 10 M;
Alter database add logfile group 3 ('d: \ ORACLE \ ORADATA \ ORADB \ REDO03_1.LOG ') size 10 M;
6. Switch the log Group
Alter system switch logfile;
Alter system switch logfile;
Alter system switch logfile;
7. Delete the log groups for intermediate transition. 4 and 5
Alter database drop logfile group 4;
Alter database drop logfile group 5;
SQL> select * from v $ log;
SQL> alter system switch logfile;
8. delete files in log group 4 and 5 under the Operating System
9. Back up the latest Control File
SQL>; alter database backup controlfile to trace resetlogs
Note: For security consideration, you can add several more files to each group.
10. Add redo logs to an existing group
SQL> alter database add logfile member 'e: \ oracle \ product \ 10.2.0 \ redo03c. log' to group 3;
11. Delete redo logs of existing groups
SQL> alter database drop logfile member 'e: \ oracle \ product \ 10.2.0 \ redo03c. log ';
Note: This article describes how to rectify data on multiple webpages and perform operations in the production environment.