增加redo log

1. /ORAIMAGE4/orcl/datafile

ALTER DATABASE ADD LOGFILE GROUP 4 ('/ora01/app/oracle/oradata/orcl/redo04a.log','/ora01/app/oracle/oradata/orcl/redo04b.log') SIZE 100M;
ALTER DATABASE ADD LOGFILE GROUP 5 ('/ora01/app/oracle/oradata/orcl/redo05a.log','/ora01/app/oracle/oradata/orcl/redo05b.log') SIZE 100M;
ALTER DATABASE ADD LOGFILE GROUP 6 ('/ora01/app/oracle/oradata/orcl/redo06a.log','/ora01/app/oracle/oradata/orcl/redo06b.log') SIZE 100M;

----115 新增redo log
ALTER DATABASE ADD LOGFILE GROUP 1 ('/ORAIMAGE4/orcl/datafile/redo01a.log','/ORAIMAGE7/orcl/datafile/redo01b.log') SIZE 1024M;
ALTER DATABASE ADD LOGFILE GROUP 2 ('/ORAIMAGE4/orcl/datafile/redo02a.log','/ORAIMAGE7/orcl/datafile/redo02b.log') SIZE 1024M;
ALTER DATABASE ADD LOGFILE GROUP 3 ('/ORAIMAGE7/orcl/datafile/redo03a.log','/ORAIMAGE4/orcl/datafile/redo03b.log') SIZE 1024M;
ALTER DATABASE ADD LOGFILE GROUP 4 ('/ORAIMAGE7/orcl/datafile/redo04a.log','/ORAIMAGE4/orcl/datafile/redo04b.log') SIZE 1024M;

ALTER SYSTEM SWITCH LOGFILE;
ALTER SYSTEM SWITCH LOGFILE;
ALTER SYSTEM SWITCH LOGFILE;

---GROUP 17,18,19 三组日志状态变成了INACTIVE了，这时候可以删除它们。删除状态为inactive的日志 ,115 / 目录空间不足
select group#,status from v$log;
select * from v$logfile;



ALTER DATABASE DROP LOGFILE GROUP 17;
ALTER DATABASE DROP LOGFILE GROUP 18;
ALTER DATABASE DROP LOGFILE GROUP 19;
ALTER DATABASE DROP LOGFILE GROUP 20;

---------------下次
ALTER DATABASE ADD LOGFILE GROUP 7 ('/ora01/app/oracle/oradata/orcl/redo07a.log','/ora01/app/oracle/oradata/orcl/redo07b.log') SIZE 200M;
ALTER DATABASE ADD LOGFILE GROUP 8 ('/ora01/app/oracle/oradata/orcl/redo08a.log','/ora01/app/oracle/oradata/orcl/redo08b.log') SIZE 200M;
ALTER DATABASE ADD LOGFILE GROUP 9 ('/ora01/app/oracle/oradata/orcl/redo09a.log','/ora01/app/oracle/oradata/orcl/redo09b.log') SIZE 200M;


2.

ALTER SYSTEM SWITCH LOGFILE;
ALTER SYSTEM CHECKPOINT;

3.
GROUP1、2、3三组日志状态变成了INACTIVE了，这时候可以删除它们。删除状态为inactive的日志

ALTER DATABASE DROP LOGFILE GROUP 1;
ALTER DATABASE DROP LOGFILE GROUP 2;
ALTER DATABASE DROP LOGFILE GROUP 3;

ALTER DATABASE DROP LOGFILE GROUP 17;
ALTER DATABASE DROP LOGFILE GROUP 18;
ALTER DATABASE DROP LOGFILE GROUP 19;
ALTER DATABASE DROP LOGFILE GROUP 20;

-----下次
ALTER DATABASE DROP LOGFILE GROUP 4;
ALTER DATABASE DROP LOGFILE GROUP 5;
ALTER DATABASE DROP LOGFILE GROUP 6;
-----------
ALTER DATABASE ADD LOGFILE GROUP 1 ('/ora01/app/oracle/oradata/orcl/redo01a.log','/ora01/app/oracle/oradata/orcl/redo01b.log') SIZE 200M;
ALTER DATABASE ADD LOGFILE GROUP 2 ('/ora01/app/oracle/oradata/orcl/redo02a.log','/ora01/app/oracle/oradata/orcl/redo02b.log') SIZE 200M;
ALTER DATABASE ADD LOGFILE GROUP 3 ('/ora01/app/oracle/oradata/orcl/redo03a.log','/ora01/app/oracle/oradata/orcl/redo03b.log') SIZE 200M;

4.
ALTER SYSTEM SWITCH LOGFILE;
ALTER SYSTEM SWITCH LOGFILE;
ALTER SYSTEM SWITCH LOGFILE;


==================================================================add-asm-redolog============================================================================

1. 备份控制文件
create pfile='/home/oracle/pfile_20201012_before_add_redolog.ora' from spfile;
alter database backup controlfile to '/home/oracle/control_20201012_before_add_redolog.ora';

2. 新增日志文件组
ALTER DATABASE ADD LOGFILE THREAD 1 GROUP 21 ('+ORADATA/','+ORAFLASH/') SIZE 500M ;

ALTER DATABASE ADD LOGFILE THREAD 2 GROUP 22 ('+ORADATA/','+ORAFLASH/') SIZE 500M ;

ALTER DATABASE ADD LOGFILE THREAD 1 GROUP 23 ('+ORADATA/','+ORAIMAGE2/') SIZE 1024M ;

ALTER DATABASE ADD LOGFILE THREAD 2 GROUP 24 ('+ORADATA/','+ORAIMAGE2/') SIZE 1024M ;
---------------
ALTER DATABASE ADD LOGFILE THREAD 1 GROUP 25 ('+ORADATA/','+ORAIMAGE2/') SIZE 1024M ;

ALTER DATABASE ADD LOGFILE THREAD 2 GROUP 26 ('+ORADATA/','+ORAIMAGE2/') SIZE 1024M ;

ALTER DATABASE ADD LOGFILE THREAD 1 GROUP 27 ('+ORADATA/','+ORAIMAGE2/') SIZE 1024M ;

ALTER DATABASE ADD LOGFILE THREAD 2 GROUP 28 ('+ORADATA/','+ORAIMAGE2/') SIZE 1024M ;


3. 日志切换，视旧日志组切换为 INACTIVE

alter system switch logfile;
alter system switch logfile;
alter system checkpoint;

4. 删除 INACTIVE 日志组

alter database drop logfile group 5;
alter database drop logfile group 6;
alter database drop logfile group 9;
alter database drop logfile group 10;
alter database drop logfile group 12;
alter database drop logfile group 7;
alter database drop logfile group 8;

alter database drop logfile group 20;
alter database drop logfile group 18;
alter database drop logfile group 16;
alter database drop logfile group 14;
alter database drop logfile group 11;

alter database drop logfile group 13;
alter database drop logfile group 15;
alter database drop logfile group 17;
alter database drop logfile group 19;

--------下次
alter database drop logfile group 17;
alter database drop logfile group 18;
alter database drop logfile group 19;
alter database drop logfile group 20;


---也可以增加日志组成员
alter database add logfile member '+ORADATA/' to group 13;
alter database drop logfile member '+ORAFLASH/orcl/onlinelog/group_9.265.922550975';
alter database drop logfile member '+ORADATA/orcl/onlinelog/group_9.476.1053632991';

alter database add logfile member '+ORADATA/' to group 10 ;
alter database drop logfile member '+ORAFLASH/orcl/onlinelog/group_10.266.922551035';

alter database add logfile member '+ORADATA/' to group 11 ;
alter database drop logfile member '+ORAFLASH/orcl/onlinelog/group_11.267.922551123';

alter database add logfile member '+ORADATA/' to group 12 ;
alter database drop logfile member '+ORAFLASH/orcl/onlinelog/group_12.268.922551199';
====================================================================================================================
alter database drop logfile group 9;
alter database drop logfile group 10;
alter database drop logfile group 11;
alter database drop logfile group 12;

5. 查看RAC当前状态
crs_stat -t

分别在两个节点上查看alert日志，观察是否存在异常记录：
tail -f /home/u01/app/diag/rdbms/orcl/orcl1/trace/alert_orcl1.log
tail -f /home/u01/app/diag/rdbms/orcl/orcl2/trace/alert_orcl2.log

6.
asmcmd 下删除对应的文件
ASMCMD
cd +ORAFLASH/ORCL/ONLINELOG
rm -fr group_10.266.922551035
rm -fr group_11.267.922551123
rm -fr group_12.268.922551199
rm -fr group_5.261.922550561
rm -fr group_6.262.922550651
rm -fr group_7.263.922550739
rm -fr group_8.264.922550865
rm -fr group_9.265.922550975

=======================asm

oracleasm listdisks

oracleasm querydisk -v -p ASMFLASH01
oracleasm querydisk -v -p ASMDATA021
oracleasm querydisk -v -p ASMDATA022
oracleasm querydisk -v -p ASMDATA023
oracleasm querydisk -v -p ASMDATA024
oracleasm querydisk -v -p ASMDATA025

/etc/init.d/oracleasm createdisk ASMDATA028 /dev/dm-9

[root@node1 disks]# cat /etc/sysconfig/oracleasm

create diskgroup ORAIMAGE2 external redundancy disk '/dev/oracleasm/disks/ASMDATA026';
/etc/init.d/oracleasm createdisk ASMDATA026 /dev/dm-7
alter diskgroup ORAIMAGE1 add disk '/dev/oracleasm/disks/ASMDATA021' name ORAIMAGE1_0001 rebalance
alter diskgroup ORAIMAGE1 add disk '/dev/oracleasm/disks/ASMDATA025' name ORAIMAGE1_0004 rebalance power 8;
alter diskgroup ORAIMAGE2 add disk '/dev/oracleasm/disks/ASMDATA028' name ORAIMAGE2_0002 rebalance power 8;