RE: Logfiles in RAC database

Join to GV$INSTANCE on the INST_ID.  

-- 
Mark J. Bobak 
Senior Oracle Architect 
ProQuest/CSA 

"There are 10 types of people in the world:  Those who understand
binary, and those who don't." 

 

________________________________

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Manmohan Jalsingh
Sent: Tuesday, May 08, 2007 2:46 PM
To: oracle-l_at_freelists.org
Subject: Logfiles in RAC database


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_at_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



--
http://www.freelists.org/webpage/oracle-l