How to change the size of the current online log file
-------------------------------------------------- ------------------------------
System environment: 1. Operating system: Windows 2000 2, Database: Oracle 8i (8.1.7) for NT Enterprise 3. Installation Path: D: / Oracle
Implementation: Method: Add new large log files, then delete old small log files
Suppose there is existing log group, there is a member in each group, each member is 1MB, now I want to change the membership size of these three log groups to 10MB
1. Create 2 new log groups ALTER DATABASE ADD Logfile Group 4 ('D: /oracle/oradata/oradb/redo04_1.log') Size 1024k; Alter Database Add Logfile Group 5 ('D: / ORACLE / ORADATA / ORADB /REDO05_1.log ') size 1024k;
2. Switch the current log to the 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 the file in the original log group 1, 2, and 3 under the operating system
5. Rebuild a log group 1, 2, 3 Alter Database Add logfile group 1 ('d: /oracle/oradata/oradb/redo01_1.log') size 10m; Alter Database Add logfile group 2 ('D: / Oracle / ORADATA / ORADB / Redo02_1.log ') Size 10m; Alter Database Add logfile group 3 (' d: /oracle/oradata/oradb/redo03_1.log ') size 10m;
6. Switch the log group ALTER SESTEM SWITCH LOGFILE; ALTER SYSTEM SWITCH LOGFILE; ALTER SYSTEM SWITCH LOGFILE
7. Delete the log group of the intermediate transition 4, 5 Alter Database Drop logfile group 4; ALTER DATABASE DROP LOGFILE GROUP 5;
8. Delete the files in the original log group 4, 5 under the operating system
