Monday, January 31, 2011

How to resize/add/drop redo log files in RAC database?

In my 2-nodes 11.2.0.2 Oracle RAC on OEL 5.5 platform, I need to resize/add/drop redo log files in order to increase redo log file size from 200M to 1G, here are the steps I took to achieve this purpose: 
1 Run commands below to check redo log info:


col member format a60
select * from v$log;
select bytes/1024/1024 from v$log;
select * from v$logfile;
SELECT a.group#, a.member, b.bytes/1024/1024 MB FROM v$logfile a, v$log b WHERE a.group# = b.group#;


2 Add new redo log groups to the database:




 alter database add logfile thread 1 group 5 ('/u09/oradata/rac/redo05.log','/u10/oradata/rac/redo05b') size 1g;
 alter database add logfile thread 1 group 6 ('/u09/oradata/rac/redo06.log','/u10/oradata/rac/redo06b') size 1g;
alter database add logfile thread 2 group 7 ('/u09/oradata/rac/redo07.log','/u10/oradata/rac/redo07b') size 1g;
 alter database add logfile thread 2 group 8 ('/u09/oradata/rac/redo08.log','/u10/oradata/rac/redo08b') size 1g;

3 Drop "Inactive" redo log groups:
select * from v$log;
alter database drop logfile group 1; (assuming group 1 is inactive)

Repeating the above command to drop all old redo log files with small file size. 

4 If the targeted redo log groups to be dropped are not inactive, issue following commands to change its status to "Inactive":
1) Running below command in all instances!!!
alter system switch logfile;

2) alter system checkpoint global;
Note: in non-RAC database, no need to specify "global" keyword. 


Related links:




Labels: ,

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home