RE: cdump, bdump, udump

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).