Multiplexed Log Files

From: Amir Gheibi <gheibia_at_gmail.com>
Date: Fri, 19 Jun 2009 14:26:19 +0800
Message-ID: <c906cd460906182326i336f3d35yeb6892ecb4f570d1_at_mail.gmail.com>

Hi listers,
I have a HP-UX box with Oracle 10gR2 installed in it. I created a Database and enabled auto archive. The log files and control files are multiplexed and live in different disks.

*>>sqlplus / as sysdba*
*
*
*SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jun 19 14:07:15 2009*
*
*
*Copyright (c) 1982, 2005, Oracle. All rights reserved.*
*
*
*
*
*Connected to:*
*Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit
Production*
*With the Partitioning, OLAP and Data Mining options*
*
*
*SQL> COLUMN GROUP# FORMAT 9;*
*SQL> COLUMN MEMBER FORMAT a30;*
*SQL> COLUMN TYPE FORMAT a10;*
*SQL> SELECT GROUP#, MEMBER, TYPE, IS_RECOVERY_DEST_FILE FROM V$LOGFILE;*
*
*
*
*
*GROUP# MEMBER TYPE IS_*
*------ ------------------------------ ---------- ---*

• 1 /u02/oradata/LMSUAT/log1.log ONLINE NO*
• 1 /u03/oradata/LMSUAT/log1.log ONLINE NO*
• 2 /u02/oradata/LMSUAT/log2.log ONLINE NO*
• 2 /u03/oradata/LMSUAT/log2.log ONLINE NO*
• 3 /u02/oradata/LMSUAT/log3.log ONLINE NO*
• 3 /u03/oradata/LMSUAT/log3.log ONLINE NO*
  *
  *
  *6 rows selected.*
  *
  *
  *
  *
  What I don't understand is the usage of the disk in /u02 and /u03.

Here is a partial outcome of the "*bdf*" command:

*/dev/vg01/lvol1 209682432 4260600 203820416 2% /u01*
*/dev/vg02/lvol1 209682432 4048992 204027056 2% /u02*
*/dev/vg03/lvol1 209682432 629888 207419328 0% /u03*
*/dev/vg04/lvol1 209682432 7513480 200589552 4% /u04*
*
*

/u02 is filled 2% but not /u03.
Don't they contain the same copy of the log files?

By the way, there is nothing other than those log files in /u02 and /u03.

Thanks.

~ Amir Gheibi

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

Received on Fri Jun 19 2009 - 01:26:19 CDT