Hi, In RAC database, how to find out logfiles used by a instance. I queried gv$logfile view, but it is showing all logfiles and it is not clear which files are attached to which instance. Following is the output of gv$logfile for a 2 nodes RAC database with 2 logfiles created for each thread. Is alert.log is the only way for finding it out. system@t3kq>select * from gv$logfile 2 / INST_ID Group# Status Type Member IS_ ---------- ------ ------- ------- ---------------------------------------- --- 1 1 ONLINE /usr5/apl/ORACLE10R2/t3kq/redo_1_01.log NO 1 2 ONLINE /usr5/apl/ORACLE10R2/t3kq/redo_1_02.log NO 1 3 ONLINE /usr5/apl/ORACLE10R2/t3kq/redo_2_01.log NO 1 4 ONLINE /usr5/apl/ORACLE10R2/t3kq/redo_2_02.log NO 2 1 ONLINE /usr5/apl/ORACLE10R2/t3kq/redo_1_01.log NO 2 2 ONLINE /usr5/apl/ORACLE10R2/t3kq/redo_1_02.log NO 2 3 ONLINE /usr5/apl/ORACLE10R2/t3kq/redo_2_01.log NO 2 4 ONLINE /usr5/apl/ORACLE10R2/t3kq/redo_2_02.log NO 8 rows selected. Thanks Manmohan