Re: Multiplexed Log Files

From: Amir Gheibi <gheibia_at_gmail.com>
Date: Sun, 21 Jun 2009 01:52:24 +0800
Message-ID: <c906cd460906201052k2513062cua24e1d584fcf1744_at_mail.gmail.com>



Now that's a simple but useful tip.I found some other files when I searched the entire disk using root... Can't believe I didn't think about it myself... Case closed!

Thanks a lot Harel.

On Sun, Jun 21, 2009 at 1:47 AM, Harel Safra <harel.safra_at_gmail.com> wrote:

> I was talking about /u03.
>
>
> Are you absolutely sure there are no other files on /u02? Perhaps hidden
> files (start with a dot)? Files not owned by the oracle user?
>
>
> Could you run:
>
> find /u02
>
>
> and:
>
> find /u02 -name ".*"
>
>
> both as root and see if there are any stray files?
>
>
> Harel Safra
>
>
> Amir Gheibi wrote:
>
> Thanks Harel. But 4048992 / 204027056 = 0.019845.. which is rounded to 2%
> as dbf suggest.
> So I'm not sure if u have answered my question at all..
>
>
> On Sat, Jun 20, 2009 at 7:34 PM, Harel Safra <harel.safra_at_gmail.com>wrote:
>
>> it's simply a matter of rounding.
>>
>> *629888/**209682432 = 0.0030040094155336771370526644788248*
>>
>> which is rounded down to 0%.
>>
>>
>> both sets of files contain the same data.
>>
>>
>> Harel Safra.
>>
>> *
>> *
>>
>>
>> **
>>
>> Amir Gheibi wrote:
>>
>> Here is what I got from the OS:
>>>
>>> >>cd /u02/oradata/LMSUAT
>>> [/u02/oradata/LMSUAT][oracle]
>>> >>ls -l
>>> total 1242384
>>> -rw-r----- 1 oracle oinstall 6930432 Jun 20 19:14 control02.ctl
>>> -rw-r----- 1 oracle oinstall 209716224 Jun 17 12:17 log1.log
>>> -rw-r----- 1 oracle oinstall 209716224 Jun 19 03:00 log2.log
>>> -rw-r----- 1 oracle oinstall 209716224 Jun 20 19:12 log3.log
>>> [/u02/oradata/LMSUAT][oracle]
>>> >>
>>> >>
>>> >>
>>> >>cd /u03/oradata/LMSUAT
>>> [/u03/oradata/LMSUAT][oracle]
>>> >>ls -l
>>> total 1242384
>>> -rw-r----- 1 oracle oinstall 6930432 Jun 20 19:14 control03.ctl
>>> -rw-r----- 1 oracle oinstall 209716224 Jun 17 12:17 log1.log
>>> -rw-r----- 1 oracle oinstall 209716224 Jun 19 03:00 log2.log
>>> -rw-r----- 1 oracle oinstall 209716224 Jun 20 19:14 log3.log
>>> [/u03/oradata/LMSUAT][oracle]
>>> >>
>>>
>>> And still the "bdf" command's output suggests that the /u02 is 3% full
>>> and /u03 is 0% full.
>>>
>>> Could those files under /u03 be sparse files? But then how the
>>> multiplexation of log files mitigate the risk of data loss in case of media
>>> failure?
>>>
>>> Thanks.
>>> ~ Amir Gheibi
>>>
>>> On Fri, Jun 19, 2009 at 3:09 PM, Mathias Magnusson <
>>> mathias.magnusson_at_gmail.com <mailto:mathias.magnusson_at_gmail.com>> wrote:
>>>
>>> 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
>>> <mailto: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 Sat Jun 20 2009 - 12:52:24 CDT

Original text of this message