Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What will the Oracle Server do if you issue the ALTER DATABASE ADD LOGFILE command without the GROUP option?

April 26, 2017Command database group ISSUE logfile option Oracle server

0

0 Posted

What will the Oracle Server do if you issue the ALTER DATABASE ADD LOGFILE command without the GROUP option?

1 Answer

0

0 Posted

The syntax to add a redo log group: ALTER DATABASE prod ADD LOGFILE GROUP 2 (‘/disk2/log2a.rdo’, ‘/disk3/log3b.rdo’) SIZE 1M; If you specify the GROUP option, you must use an integer value. If you do not use the GROUP option, the Oracle Server will automatically generate a value. Use the SIZE option if you are creating a new file. Use the REUSE option if the file already exists.