Trace file maintainance in 9i and 10g


Hello,

Trace file maintenance is a part of DBA activity, to accomplish this script is given below.

I have created a script to delete the trace file automatically, you can schedule this in your crontab and trace file maintenance will be taken care.

Note:- You may customize this according to your need.

Here is the Script code.
--------------------------------

#!/bin/ksh

. /home/oracle/.profile

DATETIME=`date +%Y%m%d`
DBA_MAIL_GRP="ghufranahmedkhan@gmail.com"

#track script start time
echo "" > /u01/app/oracle/admin/scripts_shop/trace_file_deletion_$DATETIME.log 2>&1
echo "$0: Script Start Time: `date`" >> /u01/app/oracle/admin/scripts_shop/trace_file_deletion_$DATETIME.log 2>&1
echo "" >> /u01/app/oracle/admin/scripts_shop/trace_file_deletion_$DATETIME.log 2>&1

#Deleting Trace Files on Production server older than 30 days
echo "\nDeleting Trace Files on Production server older than 30 days.." >> /u01/app/oracle/admin/scripts_shop/trace_file_deletion_$DATETIME.log
find /u01/app/oracle/admin/orcl/bdump/*.trc -mtime +30 -exec ls -ltr {} \; >> /u01/app/oracle/admin/scripts_shop/trace_file_deletion_$DATETIME.log 2>&1
find /u01/app/oracle/admin/orcl/bdump/*.trc -mtime +30 -exec rm {} \; >> /u01/app/oracle/admin/scripts_shop/trace_file_deletion_$DATETIME.log 2>&1

mailx -s "Following Trace file deleleted on Production server: `hostname` ." $DBA_MAIL_GRP < /u01/app/oracle/admin/scripts_shop/trace_file_deletion_$DATETIME.log



From 11g onward this is taken care automatically by the utility called adrci( automatic dignostic recovery command interface)



Thankyou











Comments

Post a Comment

Welcome to the Oracle DBA Blog.

Stay Hungry Stay Foolish

Popular posts from this blog

Oracle Tablespace Size

Hi, Below Script will help you find Oracle Table Size, free and Used percentage. clear breaks clear computes clear columns set pagesize 50 set linesize 120 set heading on column tablespace_name heading 'Tablespace' justify left format a20 truncated column tbsize heading 'Size|(Mb) ' justify left format 9,999,999.99 column tbused heading 'Used|(Mb) ' justify right format 9,999,999.99 column tbfree heading 'Free|(Mb) ' justify right format 9,999,999.99 column tbusedpct heading 'Used % ' justify left format a8 column tbfreepct heading 'Free % ' justify left format a8 break on report compute sum label 'Totals:' of tbsize tbused tbfree on report select t.tablespace_name, round(a.bytes,2) tbsize, nvl(round(c.bytes,2),'0') tbfree, nvl(round(b.bytes,2),'0') tbused, to_char(round(100 * (nvl(b.bytes,0)/nvl(a.bytes,1)),2)) || '%' tbusedpct, to_char(round(100 * (nvl(c.bytes,0)/nvl(a.bytes,1)),2)) || '%' tbfr...
Read more

Oracle Dba Jobs Interview Question and Answers. PART-2

Continued from: http://ghufranahmedkhan.blogspot.com/2015/06/oracle-dba-jobs-interview-question-and.html 1. How many memory layers are in the shared pool? Ans:  The shared pool portion of the SGA contains three major areas: library cache(contains parsed sql statements,cursor information,execution plans), dictionary cache (contains cache -user account information,privileges information,data file,segment and extent information), buffers for parallel execution messages, and control structure. 2. How do you find out from the RMAN catalog if a particular archive log has been backed-up? Ans:  list archivelog all; 3. How can you tell how much space is left on a given file system and how much space each of the file system’s subdirectories take-up? Ans: df -kh and du-sh 4. Define the SGA and: i)  How you would configure SGA for a mid-sized OLTP environment? ii) What is involved in tuning the SGA? Ans: SGA: The System Global Area (SGA) is a grou...
Read more

Oracle Dba Jobs Interview Question and Answers. PART-1

Salam, These are the Oracle DBA Interview Questions, these are compiled together at one place so that at the last movement you can have a look and go for the Interview. 1.  Basic  Level 1.1          Q- Which are the default passwords of SYSTEM/SYS?               ANS- MANAGER / CHANGE_ON_INSTALL 1.2          Q- How can you execute a script file in SQLPLUS?               ANS - To execute a script file in SQLPlus, type @ and then the file name. 1.3          Q- Where can you find official Oracle documentation?              ANS - tahiti.oracle.com 1.4          Q- What is the address of the Official Oracle Suppo...
Read more