The following describes how to resizes Oracle log files online. If you have encountered similar problems in Oracle log files, take a look.
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;
8. delete files in log group 4 and 5 under the Operating System
9. Back up the latest Control File
SQL> connect/as sysdba
SQL> alter database backup controlfile to trace resetlogs
The preceding method resizes Oracle log files online.
Provides you with an in-depth understanding of the Oracle archiving mode.
Oracle mobile redo log file
Solution to Oracle Log File loss
Concepts of oracle users
How to modify the oracle user name