Home > Database > Mysql Tutorial > 删除redo log group or member

删除redo log group or member

WBOY
Release: 2016-06-07 17:28:40
Original
1082 people have browsed it

一、在删除log groups 前需要确定3点:1.instance 至少要有2个groups,不考虑每个groups 的member数;2.只有当group 的状态为ina

一、在删除log groups 前需要确定3点:
 1.instance 至少要有2个groups,不考虑每个groups 的member数;
 2.只有当group 的状态为inactive时,才可以删除它。
 如果必须删除current 的group 需要先 alter system switch logfile;
 3.如果启用了归档,则必须要等到该group 归档后才可以干掉他。
 
SELECT GROUP#, ARCHIVED, STATUS FROM V$LOG;
    GROUP# ARC STATUS
 --------- --- ----------------
        1 YES ACTIVE
        2 NO  CURRENT
        3 YES INACTIVE
        4 YES INACTIVE
 
干掉某个group:
 alter database drop logfile group 3;
 

二、删除某个group的member
 ALTER DATABASE DROP LOGFILE MEMBER '/Oracle/dbs/log3c.rdo';
 --------当该redolog member 被删除时,其相应的os 文件未从磁盘上删除。
 
To drop a member of an active group, you must first force a log switch.    /* alter system switch logfile;*/

linux

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template