Adjust the redo log file size in Oracle RAC

Adjust the redo log file size in Oracle RAC

Adjust the size of the redo log file in Oracle RAC.

(1) view the current log information:

Select * from v $ logfile;

(The path in step 2 can be seen in the MEMBER column here. The redo file name is named by yourself, for example, redo07.log)

(Note: The log group is now in 6 groups)

(2) Add log files for each node: (add three groups of logs for each node)
1. Node 1
Alter database add logfile thread 1 group 7' + data/... (Path in single quotes) 'size 2048 m;
Alter database add logfile thread 1 group 8' + data/... (Path in single quotation marks) 'size 2048;
Alter database add logfile thread 1 group 9' + data/... (Path in single quotation marks) 'size 2048;

2. Node 2
Alter database add logfile thread 2 group 10' + data/... (Path in single quotes) 'size 2048 m;
Alter database add logfile thread 2 group 11' + data/... (Path in single quotes) 'size 2048 m;
Alter database add logfile thread 2 group 12' + data/... (Path in single quotes) 'size 2048 m;

(3) manually switch logs and delete the previous logs: (this step is executed repeatedly until all group, are deleted)

View the log file STATUS column (STATUS ):

SELECT * from v $ LOG;

Only the STATUS column is inactive 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; (switching logs can change the status of the status column before deleting)

If the status cannot be changed, use this: alter system archive log current;

Last: Delete the previous redo log file (delete at the operating system level)

Oracle 11g installation manual on RedHat Linux 5.8 _ x64 Platform

Installing Oracle 12C in Linux-6-64

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian