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;