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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Manmohan Jalsingh
Sent: Tuesday, May 08, 2007 2:46 PM
To: oracle-l@xxxxxxxxxxxxx
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@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


Other related posts: