Oracle - redo log group eklem

SELECT * FROM V$LOG;
select GROUP#,MEMBER,TYPE from v$logfile order by 1 ;

ALTER DATABASE ADD LOGFILE GROUP 5 ('/oracle/sid/origlogA/log_g15m1.dbf','/oracle/sid/origlogA/log_g15m2.dbf') size 100M;

alter database drop logfile group 5;
--------------------veya;
ALTER DATABASE ADD LOGFILE GROUP 5 ('/oracle/sid/origlogA/log_g15m1.dbf') size 100M;

alter database add logfile member '/oracle/sid/origlogA/log_g15m2.dbf' to group 5 ;

alter database drop logfile member '/oracle/sid/origlogA/log_g15m2.dbf'
-----------------------
ALTER DATABASE CLEAR LOGFILE GROUP 5;

If the corrupt redo log file has not been archived, use the UNARCHIVED keyword in the statement.

ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;

http://www.filibeto.org/sun/lib/nonsun/oracle/11.1.0.6.0/B28359_01/server.111/b28310/onlineredo003.htm