Oracle RAC添加删除日志文件

Oracle RAC添加删除redo log日志文件

一、查看当前在线日志

set linesize 500 pagesize 500
col member for a50
select * from v$logfile;
 

    GROUP# STATUS  TYPE    MEMBER					      IS_
---------- ------- ------- -------------------------------------------------- ---
	 2	   ONLINE  +DATA/yfdb/onlinelog/group_2.262.948713917	      NO
	 2	   ONLINE  +FRA/yfdb/onlinelog/group_2.258.948713917	      YES
	 1	   ONLINE  +DATA/yfdb/onlinelog/group_1.261.948713915	      NO
	 1	   ONLINE  +FRA/yfdb/onlinelog/group_1.257.948713915	      YES
	 3	   ONLINE  +DATA/yfdb/onlinelog/group_3.265.948714085	      NO
	 3	   ONLINE  +FRA/yfdb/onlinelog/group_3.259.948714085	      YES
	 4	   ONLINE  +DATA/yfdb/onlinelog/group_4.266.948714087	      NO
	 4	   ONLINE  +FRA/yfdb/onlinelog/group_4.260.948714087	      YES
	 5	   ONLINE  +DATA/yfdb/onlinelog/group_5.355.1063363569	      NO
	 5	   ONLINE  +FRA/yfdb/onlinelog/group_5.1446.1063363571	      NO
	 6	   ONLINE  +DATA/yfdb/onlinelog/group_6.354.1063363581	      NO
	 6	   ONLINE  +FRA/yfdb/onlinelog/group_6.2582.1063363581	      NO

12 rows selected.

SQL> select  thread#,group#,archived,status from v$log;

   THREAD#     GROUP# ARC STATUS
---------- ---------- --- ----------------
	 1	    1 YES INACTIVE
	 1	    2 YES INACTIVE
	 2	    3 NO  CURRENT
	 2	    4 YES INACTIVE
	 1	    5 NO  CURRENT
	 2	    6 YES INACTIVE

6 rows selected.

二、删除日志组

---删除在线日志
alter database drop logfile group 1; 
alter database drop logfile group 2; 

alter database drop logfile group 3; 
alter database drop logfile group 4; 

alter database drop logfile group 6; 

---删除日志成员(可选):
alter database drop logfile member '+FRA/yfdb/onlinelog/group_5.1446.1063363571';       
alter database drop logfile member '+FRA/yfdb/onlinelog/group_6.2582.1063363581';    

三、添加日志

---添加在线日志:
alter database add logfile thread 1 group 1 '+DATA' size 500M;
alter database add logfile thread 1 group 2 '+DATA' size 500M;

alter database add logfile thread 2 group 3 '+DATA' size 500M;
alter database add logfile thread 2 group 4 '+DATA' size 500M;

alter database add logfile thread 1 group 5 '+DATA' size 500M;
alter database add logfile thread 1 group 6 '+DATA' size 500M;

alter database add logfile thread 2 group 7 '+DATA' size 500M;
alter database add logfile thread 2 group 8 '+DATA' size 500M;

---添加日志成员(可选)
alter database add logfile member '+FRA' to group 4;