RE: cdump, bdump, udump

I also monitored the processes and found that alert.log file is constantly accessed at least by one Oracle process during a period of one hour continuous monitoring.

Hence, my conclusions:

1. By removing alert.log, the space would not be reclaimed by the disk on Unix machines immediately until you bounce the db.
2. Perhaps, on rare occasions, the space is reclaimed by the disk without bouncing the db. But this, in my opinion, is a rarity.

Thanks,

Rao

Maheswara.Rao_at_sungardp3.com

-----Original Message-----
Sent: Tuesday, May 15, 2001 7:46 PM
To: Multiple recipients of list ORACLE-L

I tried the 'alien' weapon - fuser - against the alert.log file. There are 18 oracle processes accessing it. A simple rm will delete the file handle but apparently not actually release the space without bouncing the database.

Lesson learned. And, that's my limit for today.

Pete Barnett
Oracle Database Administrator
Regence BlueCross BlueShield
pnbarne_at_regence.com

On Tue, 15 May 2001, Rajaram wrote:

> Look like this message did not get thru.. sending again. Pl. Ignore if
> repeat....
>
>
> 1. Space occupied by alert.log is freed once you delete the file.
>
> 2. You may not see an immediate reclamation of free space. Try to do sync
(
> In solaris) and notice the free space. Also, try more than one method of
> free space checking - Using du, bdf, sam or sysadmin tools.
>
>
>
> -----Original Message-----
> From: Rao, Maheswara [SMTP:Maheswara.Rao_at_Sungardp3.com]
> Sent: Tuesday, May 15, 2001 2:50 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: cdump, bdump, udump
>
> Terry,
>
> I tested this again now. I removed alert.log and then checked disk usage.
> It did not release the disk space. Then I bounced the db. Now, the disk
> space is released.
>
> Environment: Solaris 7, 64 bit. Oracle 817.
>
> Rao
>
> Maheswara.Rao_at_sungardp3.com
>
> -----Original Message-----
> Sent: Tuesday, May 15, 2001 12:36 PM
> To: Multiple recipients of list ORACLE-L
>
> On Solaris 2.5, 2.6 and 2.7, as well as AIX we have removed the alert.log
> and
> space has immediately become free. (Not true with the listener.log
> however).
>
> Terry
>
> "Rao, Maheswara" wrote:
>
> > Ron,
> >
> > You would not be able free the disk space even if alert.log is deleted.
> For
> > example, if alert.log file size is 500 MB size and then you delete the
> > alert.log, still you would not be able to get a disk free space of 500
> MB.
> > This space would be released once you bounce the database.
> >
> > The above scenario is similar even if you copy alert.log to a different
> > location and then delete the rows.
> >
> > The above scenario applies to Solaris environment. I do not know what
> > happens in NT environment.
> >
> > Rao
> >
> > Maheswara.Rao_at_sungardp3.com
> >
> > -----Original Message-----
> > Sent: Wednesday, April 25, 2001 10:39 AM
> > To: Multiple recipients of list ORACLE-L
> >
> > Team,
> > Correct me if I am wrong, please.. If you delete the alert.log file with
> the
> > database up and running, the oracle still thinks the file exists and
> writes
> > to a non existant file that you can't "see". The proper method of
> reducing
> > the file size is to copy the file to a backup location, and edit the
> > original and delete rows from the file. OR if you do not need to keep
the
> > original log for analysis you could copu /dev/null > alert.log.
> > Just a house keeping note.
> > ROR ma?am
> >
> > >>> carmichr_at_hotmail.com 04/24/01 09:21AM >>>
> > Sinardy,
> >
> > First, I suggest you find some time and sit down and READ the Oracle
> > documentation. Otherwise you are going to get a large number of "RTFM"
> > emails, and some flaming as well.
> >
> > Now.. the alert log is created (if it does not already exist) or written
> to
> > every time Oracle wants to record an event that has happened in the
> > database/instance. So log switches will be in there, database shutdown
> and
> > startup messages, errors dealing with the infrastructure of the database
> > (failure to extend a rollback segment, failure to get space in the temp
> > segment, disasterous database errors etc) There are other messages as
> well,
> > I'm not going to list every one.
> >
> > Bdump contains trace files that relate to the Oracle background process
> --
> > anything generated by smon, pmon, etc
> >
> > Udump contains trace files that relate to specific user Oracle processes
> >
> > Cdump contains core dumps, associated with one or another trace files in
> the
> > bdump directory.
> >
> > Rachel
> >
> > >From: "Sinardy Xing" <sinardyxing_at_bcsis.com>
> > >Reply-To: ORACLE-L_at_fatcity.com
> > >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > >Subject: RE: cdump, bdump, udump
> > >Date: Tue, 24 Apr 2001 03:40:27 -0800
> > >
> > >Hi all,
> > >
> > >When those logs will created ?
> > >
> > >Thank you
> > >
> > >Sinardy
> > >
> > >
> > >-----Original Message-----
> > >Sent: Tuesday, 24 April 2001 9:41 AM
> > >To: LazyDBA mailing list
> > >
> > >
> > >Hi DBAs and SAs,
> > >
> > >I had a task to do housekeep ...\bdump\alertSID.log
> > >What logs usually Oracle system need to housekeep, and what are these
> > >directory
> > > cdump,
> > > bdump and
> > > udump
> > >for ?
> > >
>
>
> NetZero Platinum
> No Banner Ads and Unlimited Access
> Sign Up Today - Only $9.95 per month!
> http://www.netzero.net
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rajaram
> INET: rajaram_k_at_netzero.net
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Peter Barnett
  INET: pnbarne_at_bcbso.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rao, Maheswara
  INET: Maheswara.Rao_at_Sungardp3.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).