Oracle modifies log size and increases log member ____oracle

a good memory is better than a bad pen, it is easy to read. log file can be resize, directly enlarge the size of the log file. 10g is not possible. the general method on the web is to create a new two temporary log group (Oracle requires at least two log groups), switch to the two temporary log groups, delete the rebuild expansion or zoom out, and then add the log group members. In the middle of the process, use alter system checkpoint to turn log state active to inactive and switch the log group with alter system switch logfile.
1. Increase the size of the log file, I was created by the new large log group and then switched to implement, in the original log group to create a new log group ALTER DATABASE Add logfile Group 4 ('/u01/oracle/product/10.0.2/oradata/orcl/redo41.log ') size 100m; ALTER DATABASE Add logfile Group 5 ('/u01/oracle/product/10.0.2/oradata/orcl/redo51.log ') size 100m; ALTER DATABASE Add logfile Group 6 ('/u01/oracle/product/10.0.2/oradata/orcl/redo61.log ') size 100m; 2. Switch logs to a newly created log group alter system switch logfile; 3. View Log Status select * from V$log; Note: The log group can be deleted only if the status is inactive and archived is yes (this means that the redo log has been archived, otherwise it will be reported to the ora-01624) 4. Delete log Group ALTER DATABASE drop logfile Group 1; 5. Operating system level Delete data file (my system is REDHAT5) RM-RF Redo01.log 6. Increase log members (preferably put members on different disks to do more work, to avoid a group of log files all corrupted database downtime) ALTER DATABASE Add logfile member '/u01/oracle/product/10.0.2/oradata/orcl/redo42.log ' to group 4; ALTER DATABASE Add logfile member '/u01/oracle/product/10.0.2/oradata/orcl/redo52.log ' to group 5; ALTER DATABASE Add logfile member '/u01/oracle/product/10.0.2/oradata/orcl/redo42.log ' to group 3; 7. Delete log Group member ALTER DATABASE drop logfile member '/u01/oracle/product/10.0.2/oradata/orcl/redo42.log '; Here are some guidelines for logging: principle: You must adhere to the following principles before deleting, each instance must have at least two log groups, and cannot be deleted when a group is in active or current state; Delete a log group only make changes to the database, the operating system's files have not been deleted, and the drop is applied when deleting When the group N statement is LOGFILE, all members within group N are deleted. ALTER DATABASE drop logfile group N; the principle of deleting log Members: When you delete one of the last members of the group, you cannot delete this member, and when the group's turntable is in current state, it cannot be deleted; In archive mode, it must be archived before it can be deleted; Delete log group members only make changes to the database. The operating system's files have not been deleted ALTER DATABASE drop logfile member '/location_dust/redo0n_n.log ';This article originates from http://blog.csdn.net/warden2010/article/details/6300660