RE: Logfiles in RAC database
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <mjalsingh@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 8 May 2007 15:33:58 -0400
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:
