switch log

手动切换oracle日志

1.Alter System Switch Logfile

  Forcing a Log Switch:

   Example You might want to force a log switch to drop or rename the current redo log file group or one of its members, because you cannot drop or rename a file while Oracle Database is writing to it. The forced log switch affects only the redo log thread of your instance. The following statement forces a log switch:

2.Alter SystemArchive Log All

   会归档除了CURRENT组外的所有未归档的日志

   Specify ALL to manually archive all online redo log file groups from the specified thread that are full but have not been archived. If you omit theTHREAD parameter, then Oracle Database archives all full unarchived redo log file groups from all enabled threads.

3. Alter System Archive Log Current

   对数据库中的所有实例执行日志切换(只归档当前日志)。

   Specify CURRENT to manually archive the current redo log file group of the specified thread, forcing a log switch. If you omit the THREAD parameter, then Oracle archives all redo log file groups from all enabled threads, including logs previous to current logs. You can specify CURRENT only when the database is open.