Oracle多路复用重做日志

Question

我在同一磁盘上有5个重做日志文件，如下所示：

/disk1/oradata/redo01.log

/disk1/oradata/redo02.log

/disk1/oradata/redo03.log

/disk1/oradata/redo04.log

/disk1/oradata/redo05.log

但建议在另一个磁盘上进行多路复用。在这种情况下，我想在SQL中设置以下过程：

alter database add logfile member /disk2/oradata/redo01_b.log

alter database add logfile member /disk2/oradata/redo02_b.log

alter database add logfile member /disk2/oradata/redo03_b.log

alter database add logfile member /disk2/oradata/redo04_b.log

alter database add logfile member /disk2/oradata/redo05_b.log

alter system set log_archive_dest_2 = "LOCATION = /disk2/oradata/" SCOPE = BOTH;

但我不知道这是否值得，这是否是最好的方法，以及对我的数据库的影响。

提前谢谢你。

Answer 1

如果第二张盘是独立的设备，而不是第一张盘上的分区，则将记录复制到第二张盘是有意义的。将事务日志写入disk2会增加disk2负载。

ALTER DATABASE ADD LOGFILE MEMBER '/disk2/oradata/redo01_b.log' TO GROUP 1;
ALTER DATABASE ADD LOGFILE MEMBER '/disk2/oradata/redo02_b.log' TO GROUP 2;
ALTER DATABASE ADD LOGFILE MEMBER '/disk2/oradata/redo03_b.log' TO GROUP 3;
ALTER DATABASE ADD LOGFILE MEMBER '/disk2/oradata/redo04_b.log' TO GROUP 4;
ALTER DATABASE ADD LOGFILE MEMBER '/disk2/oradata/redo05_b.log' TO GROUP 5;