Home » RDBMS Server » Enterprise Manager » Enterprsie manager showing Dump area size % 57 when i have delete all of trace file (Oracle 10g 10.2.0.1 on linux 32 bit)
Enterprsie manager showing Dump area size % 57 when i have delete all of trace file [message #316765] Mon, 28 April 2008 04:43 Go to next message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
Hi,

I am working on oracle 10g 10.2.0.1 on Linux 32 bit, In Enterprise manager it is showing Dump Area used (%) 60%, when i removed all of my trace file from bdump,cdump,dpdump,adump. My archive log files are also in this dump area, so i removed most of archice and from rman delete expired archivelog too.

But it is still showing 57%

When i look at parameter MAX_DUMP_FILE_SIZE=unlimited

Then why there is a full % IN Enterprise Manager
Re: Enterprsie manager showing Dump area size % 57 when i have delete all of trace file [message #316775 is a reply to message #316765] Mon, 28 April 2008 05:15 Go to previous messageGo to next message
msmallya
Messages: 66
Registered: March 2008
Location: AHMEDABAD, GUJARAT
Member
Hi,

Though you have removed all files (deleted), unless and untill you to issue "crosscheck" backup or copy and issue "delete obsolete", it will not reclaim space.

Also it is advisable not to keep archive log files in this directory.

Regards,

MSMallya
Re: Enterprsie manager showing Dump area size % 57 when i have delete all of trace file [message #316785 is a reply to message #316775] Mon, 28 April 2008 05:39 Go to previous messageGo to next message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
Yes, in RMAN i use crosscheck archivelog all; then
delete expired archivelog all;
But no difference in used %
Re: Enterprsie manager showing Dump area size % 57 when i have delete all of trace file [message #316789 is a reply to message #316785] Mon, 28 April 2008 06:12 Go to previous messageGo to next message
msmallya
Messages: 66
Registered: March 2008
Location: AHMEDABAD, GUJARAT
Member
Try

rman>delete obsolete

Regards,

MSMallya
Re: Enterprsie manager showing Dump area size % 57 when i have delete all of trace file [message #316793 is a reply to message #316789] Mon, 28 April 2008 06:34 Go to previous messageGo to next message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
It tried following is the out put

Recovery Manager: Release 10.2.0.1.0 - Production on Mon Apr 28 12:33:01 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: TEST4 (DBID=823818760)
using target database control file instead of recovery catalog

RMAN> delete obsolete
2> ;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=107 devtype=DISK
no obsolete backups found
Re: Enterprsie manager showing Dump area size % 57 when i have delete all of trace file [message #316965 is a reply to message #316793] Tue, 29 April 2008 00:30 Go to previous messageGo to next message
msmallya
Messages: 66
Registered: March 2008
Location: AHMEDABAD, GUJARAT
Member
Can you post
sql>archive log list
output? (connect as sysdba using sqlplus)

Will show archive destination (check your self if archive logs are deleted from here).

Regards,

MSMallya

[Updated on: Tue, 29 April 2008 00:30]

Report message to a moderator

Re: Enterprsie manager showing Dump area size % 57 when i have delete all of trace file [message #317015 is a reply to message #316965] Tue, 29 April 2008 03:34 Go to previous messageGo to next message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
Following is the output

Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/app/oracle/admin/test4/archive
Oldest online log sequence 472
Next log sequence to archive 474
Current log sequence 474

only 3 archive are present at this time of 46MB each.

i also create export dump in bin folder /u01/app/oracle/product/10.2.0/db_4/bin

when i delete dump files from this folder now dump area size is 33%



[Updated on: Tue, 29 April 2008 04:52]

Report message to a moderator

Re: Enterprsie manager showing Dump area size % 57 when i have delete all of trace file [message #317215 is a reply to message #317015] Wed, 30 April 2008 01:05 Go to previous messageGo to next message
msmallya
Messages: 66
Registered: March 2008
Location: AHMEDABAD, GUJARAT
Member
Quote:
Archive destination /u01/app/oracle/admin/test4/archive



This means archivelog files automatically created in this directory.

Quote:
removed all of my trace file from bdump,cdump,dpdump,adump. My archive log files are also in this dump area


contrary to above archive destination. or you have manually moved to that directory and removed.

And as per commands issued by you (rman) there are no obsolete/expired files/backup. So no question of space reclamation!!

Regards,

MSMallya
Re: Enterprsie manager showing Dump area size % 57 when i have delete all of trace file [message #317251 is a reply to message #317215] Wed, 30 April 2008 04:44 Go to previous message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
Thank you for your help, now i understand that Dump area use% is showing area used by whole database, because the dump file lies in the same mounting point
Previous Topic: How to get notification with ORA- Error code
Next Topic: Datagaurd Configuration using Enterprise Manager Grid Control
Goto Forum:
  


Current Time: Thu Mar 28 14:54:29 CDT 2024