创建日志文件组语句

 CREATE LOGFILE GROUP

CREATE LOGFILE GROUP logfile_group
    ADD UNDOFILE 'undo_file'
    [INITIAL_SIZE [=] initial_size]
    [UNDO_BUFFER_SIZE [=] undo_buffer_size]
    [REDO_BUFFER_SIZE [=] redo_buffer_size]
    [NODEGROUP [=] nodegroup_id]
    [WAIT]
    [COMMENT [=] 'string']
    ENGINE [=] engine_name

 ALTER LOGFILE GROUP

ALTER LOGFILE GROUP logfile_group
    ADD UNDOFILE 'file_name'
    [INITIAL_SIZE [=] size]
    [WAIT]
    ENGINE [=] engine_name

 DROP LOGFILE GROUP

DROP LOGFILE GROUP logfile_group
    ENGINE [=] engine_name
原文地址:https://www.cnblogs.com/wonchaofan/p/13515464.html