由 macro 发布于: 2001-03-02 22:04

eg.

ALTER DATABASE DROP LOGFILE GROUP 3;

Restrictions:

1.An instance requires at least two groups of online redo log files.

2.An active or current group cannot be dropped.

3.If the database is running the ARCHIVELOG mode and the log file group is not archived,then the group cannot be dropped.

4.Wehn an online redo log group is dropped , the operating system files are not deleted.

由 macro 发布于: 2001-03-02 22:11

You may want to drop an online redo log member because it has a status of INVALID.

eg.

ALTER DATABASE DROP LOGFILE MEMBER '/DISK4/log2b.dbf';


Restrictions:

1. If the member you want to drop is the last valid member of the group , you cannot drop the member.

2.If the group is current,you must force a log file switch before you can drop the member.

3.If the database is running in ARCHIVELOG mode and the log file group to which the member belones is not archived,then the member cannot be dropped.

4.When an online redo log member is dropped , the operating system files are not deleted.