Logfiles in RAC database

From: Manmohan Jalsingh <mjalsingh_at_gmail.com>
Date: Tue, 8 May 2007 11:46:27 -0700
Message-ID: <7c4806e20705081146r5451f6aeob3d9429e8d94961@mail.gmail.com>

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 Received on Tue May 08 2007 - 13:46:27 CDT