Redo log file size under RAC adjustment
(1) View current log information:
SELECT * from V$logfile;
(Step 2 Get the path can be seen here Member column, redo file name itself, such as, Redo07.log)
(Note: The log group is now 6 groups)
(2) Add log files for each node: (add three groups of logs per node)
1. Node 1
ALTER DATABASE ADD LOGFILE THREAD 1 Group 7 ' +data/.... (single quotation mark inside is path) ′size 2048m;
ALTER DATABASE ADD LOGFILE THREAD 1 group 8 ' +data/.... (single quotation mark inside is path) ′size 2048;
ALTER DATABASE ADD LOGFILE THREAD 1 Group 9 ' +data/.... (single quotation mark inside is path) ′size 2048;
2. Node 2
ALTER DATABASE ADD LOGFILE THREAD 2 Group ' +data/.... (single quotation mark inside is path) ′size 2048m;
ALTER DATABASE ADD LOGFILE THREAD 2 Group One ' +data/.... (single quotation mark inside is path) ′size 2048m;
ALTER DATABASE ADD LOGFILE THREAD 2 group +data/.... (single quotation mark inside is path) ′size 2048m;
(3) Manually switch the log and delete the previous log: (This step is repeated until all group 1,2,3,4,5,6 are removed)
To view the log File Status column (status):
SELECT * from V$log;
Only status listed as inactive state can be deleted:
ALTER DATABASE drop logfile Group 1;
ALTER DATABASE drop logfile Group 2;
ALTER DATABASE drop logfile Group 3;
ALTER DATABASE drop logfile Group 4;
ALTER DATABASE drop logfile Group 5;
ALTER DATABASE drop logfile Group 6;
alter system switch logfile; (Toggle log to change Status column, then delete)
If you cannot change the state use this: Alter system archive log current;
Last: Delete the previous redo log file (OS level delete)
Tuning redo log file size under Oracle RAC