Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to add redundant files and log groups to the Oracle log group. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.

Thread needs to be specified in rac

Add log group RAC:

Alter database add logfile thread 1 group 1 ('+ DATA/irac/redo01_1.log','+DATA/irac/redo01_2.log') size 1024m

Alter database add logfile thread 1 group 2 ('+ DATA/irac/redo02_1.log','+DATA/irac/redo02_2.log') size 1024m

Single instance:

Alter database add logfile group 1 ('+ DATA/irac/redo01_1.log','+DATA/irac/redo01_2.log') size 1024m

To add log files, you do not need to set the size size:

Alter database add logfile member'/ u01 to group to group 1

Alter database add logfile member'/ u01 to group to group 2

Alter database add logfile member'/ u01 to group to group 3

This is the end of the article on "how to add redundant files and log groups in Oracle log groups". I hope the above content can be helpful to you so that you can learn more knowledge. if you think the article is good, please share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.