Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: cdump, bdump, udump

RE: cdump, bdump, udump

From: Rao, Maheswara <Maheswara.Rao_at_Sungardp3.com>
Date: Tue, 15 May 2001 07:16:22 -0700
Message-ID: <F001.003039AA.20010515071046@fatcity.com>

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 mm

>>> 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 ?
>
>
>Thank you for your time
>
>Sinardy
>
>
>
>--------
>Think you know someone who can answer the above question? Forward it to
>them!
>to unsubscribe, send a blank email to oracledba-unsubscribe_at_LAZYDBA.com
>to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com
>Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
>Tell yer mates about http://www.farAwayJobs.com
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Sinardy Xing
> INET: sinardyxing_at_bcsis.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).



Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
  INET: carmichr_at_hotmail.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: Ron Rogers
  INET: RROGERS_at_galottery.org

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).
Received on Tue May 15 2001 - 09:16:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US