Redo log in general
Managing the Online Redo Log Creating Online Redo Log Groups and Members Creating Online Redo Log Groups The following statement adds a new group of redo logs to the database: SQL>ALTER DATABASE ADD LOGFILE (‘/oracle/dbs/log1c.rdo’, ‘/oracle/dbs/log2c.rdo’) SIZE 500M; You can also specify the number that identifies the group using the GROUP option: SQL>ALTER DATABASE ADD LOGFILE GROUP 3 ‘/ORACLE/ORADATA/FRAME/REDO03.LOG’ […]