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@xxxxxxxxx> 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 >