1-Shutdown the SAP R/3 and the database
2- Startup mount
3- Add the new redolog groups and members:
ALTER DATABASE ADD LOGFILE GROUP 15
('/oracle/SID/origlogA/log_g15m1.dbf',
'/oracle/SID/mirrlogA/log_g15m2.dbf') SIZE 50M REUSE;
4- Ater system switch logfile; Use that statement several times till you see the new redologs are "Current" or "Inactive"
5- Select * from v$logfile; See if the files are added correctly.
6- Alter database open;
7- Shutdown normal
8- Startup
9- Startup SAP R/3
Shutting down the database is not neccessary.
SAP standard redolog architecture consists of minimum two redolog groups and mirrors. Each group and each mirror has its own seperate file system
FILESYSTEM /oracle/SID/origlogA /oracle/SID/mirrlogA /oracle/SID/origlogB /oracle/SID/mirrlogB
FILES log_g11m1.dbf log_g11m2.dbf log_g12m1.dbf log_g12m2.dbf
FILES log_g13m1.dbf log_g13m2.dbf log_g14m1.dbf log_g14m2.dbf
FILES log_g15m1.dbf log_g15m2.dbf log_g16m1.dbf log_g16m2.dbf
FILES log_g17m1.dbf log_g17m2.dbf log_g18m1.dbf log_g18m2.dbf