REM
REM DBAToolZ NOTE:
REM	This script was obtained from DBAToolZ.com
REM	It's configured to work with SQL Directory (SQLDIR).
REM	SQLDIR is a utility that allows easy organization and
REM	execution of SQL*Plus scripts using user-friendly menu.
REM	Visit DBAToolZ.com for more details and free SQL scripts.
REM
REM 
REM File:
REM 	c_log_cr8.sql
REM
REM <SQLDIR_GRP>LOG</SQLDIR_GRP>
REM 
REM Author:
REM 	Vitaliy Mogilevskiy 
REM	VMOGILEV
REM	(www.dbatoolz.com)
REM 
REM Purpose:
REM	<SQLDIR_TXT>
REM	Creates Redo Log Group with two members
REM	</SQLDIR_TXT>
REM	
REM Usage:
REM	c_log_cr8.sql
REM 
REM Example:
REM	c_log_cr8.sql
REM
REM
REM History:
REM	08-01-2001	VMOGILEV	Created
REM
REM

accept 1 prompt "Enter Group Number: (Example: 1, 2, 3)"
accept 2 prompt "Enter Log Member#1: (Example: /ora0/oradata/dsswh/redo31.log)"
accept 3 prompt "Enter Log Member#2: (Example: /ora8/oradata/dsswh/redo32.log)"
accept 4 prompt "Enter Member Size: (Example: 5M)"

ALTER DATABASE 
    ADD LOGFILE GROUP &1 ('&2','&3') SIZE &4
/