Re: Multiplexed Log Files

From: Mathias Magnusson <mathias.magnusson_at_gmail.com>
Date: Fri, 19 Jun 2009 09:09:31 +0200
Message-ID: <8580d4110906190009s41510609g47c5cd8992cf1f64_at_mail.gmail.com>

Why not also list the size of the files as the DB and as the operating system knows it?
Maybe also a "find /u02" and "find /u3" to verify that all you have there is logfiles?

Mathias

On Fri, Jun 19, 2009 at 8:26 AM, Amir Gheibi <gheibia_at_gmail.com> wrote:

> 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 - 02:09:31 CDT