Oracle 19c数据库REDO日志更换
一、增加新日志组,并放在不同磁盘
SQL> alter database add logfile thread 1 group 10 ('+DATA','+OCR') size 50M;
Database altered.
SQL> alter database add logfile thread 1 group 11 ('+DATA','+OCR') size 50M;
Database altered.
SQL> alter database add logfile thread 1 group 12 ('+DATA','+OCR') size 50M;
Database altered.
SQL> alter database add logfile thread 2 group 20 ('+DATA','+OCR') size 50M;
Database altered.
SQL>alter database add logfile thread 2 group 21 ('+DATA','+OCR') size 50M;
Database altered.
SQL> alter database add logfile thread 2 group 22 ('+DATA','+OCR') size 50M;
Database altered.
添加错误,可使用如下命令删除:
ALTER DATABASE DROP LOGFILE GROUP 10;
ALTER DATABASE DROP LOGFILE GROUP 11;
ALTER DATABASE DROP LOGFILE GROUP 12;
ALTER DATABASE DROP LOGFILE GROUP 13;
ALTER DATABASE DROP LOGFILE GROUP 20;
ALTER DATABASE DROP LOGFILE GROUP 21;
ALTER DATABASE DROP LOGFILE GROUP 22;
二、查询
select group#,thread#,bytes/1024/1024 ,members ,STATUS from v$log;
select group#,member,type from v$logfile ;
三、节点1删除原有归档日志组
alter system switch logfile;
alter system checkpoint;
直到原有logfile为INACTIVE状态。
四、节点1删除原有的group组
ALTER DATABASE DROP LOGFILE GROUP 1;
ALTER DATABASE DROP LOGFILE GROUP 2;
ALTER DATABASE DROP LOGFILE GROUP 5;
ALTER DATABASE DROP LOGFILE GROUP 6;
ALTER DATABASE DROP LOGFILE GROUP 7;
五、节点2删除原有归档日志组
alter system switch logfile;
alter system checkpoint;
直到原有logfile为INACTIVE状态。
select group#,thread#,bytes/1024/1024 ,members ,STATUS from v$log;
六、节点2删除原有的group组
ALTER DATABASE DROP LOGFILE GROUP 3;
ALTER DATABASE DROP LOGFILE GROUP 4;
ALTER DATABASE DROP LOGFILE GROUP 8;
ALTER DATABASE DROP LOGFILE GROUP 9;