Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

redo log group and member

ANNECFeb 12 2020 — edited Feb 13 2020

I am reading oracle online document below

11.3.1 Creating Redo Log Groups

To create a new group of redo log files, use the SQL statement ALTER DATABASE with the ADD LOGFILE clause.

  • Run the SQL statement ALTER DATABASE with the ADD LOGFILE clause.

For example, the following statement adds a new group of redo logs to the database:

ALTER DATABASE ADD LOGFILE ('/oracle/dbs/log1c.rdo', '/oracle/dbs/log2c.rdo') SIZE 100M;

My question is for above alter statement, I don't see the group name, then what group it added to...?

Also for the Size 100M in above statement, does it mean the two files in the parentheses each one is 100M, or both files addes together is 100M?

Thanks.

This post has been answered by JohnWatson2 on Feb 13 2020
Jump to Answer
Comments
Post Details
Added on Feb 12 2020
11 comments
1,898 views