UNIX ADMINISTRATION

http://dbawiki.wordpress.com/


Oracle logs clearing on Linux hosts
06Aug

Every two weeks on Linux hosts with Oracle RAC runs this script (/home/oracle/log_backup.sh). It deletes logs older 14 days from /u01/app/ folder. Archives big current log files (alert.log, listener.log) to folder /u01/app/oracle/log_backup/ and nullifies them.
It runs every second and fourth friday of every month at 1:15 am through crontab. The script’s logs are in u01/app/oracle/log_backup/.

cd /u01/app/oracle
mkdir log_backup
chmod 700 /home/oracle/log_backup.sh
chmod 700 /home/oracle/mv_log_backup.sh
#Runs every second and fourth friday of every month at 1:15 am.
crontab -l
crontab -e
15 1 8-14,22-28 * Fri /home/oracle/log_backup.sh >> /u01/app/oracle/log_backup/log_backup.log 2>&1
15 3 8-14,22-28 * Fri /home/oracle/mv_log_backup.sh
#log_backup.sh
#Deletes logs older 14 days from /u01/app/ folder. Archives big current log files.
export timestamp=$( date +%d.%m.%y_%H.%M.%S )
echo "------------------------------< Start Running at $timestamp >------------------------------"


#Find out what are the biggest logs
#du -BM /u01/app | sort -nr | grep 'log\|diag' | more
#find /u01/app -type f -mtime +14 | xargs ls -Slh | more
#find /u01/app -type f | grep 'log\|diag' | xargs ls -Slh | more
#find /u01/app -size +512M | xargs ls -Slh
#Drop log backups older then 14 days
#find /u01/app/oracle/log_backup/ -type f -mtime +14 | xargs ls -Slh | more
find /u01/app/oracle/log_backup/ -type f -mtime +14 | xargs /bin/rm -f



#Drop all logs older then 14 days


 #find /u01/app/oracle/diag -type f -mtime +14 | xargs ls -Slh | more
#find /u01/app/11.2.0/grid112020/cdata -type f -mtime +14 | xargs ls -Slh
find /u01/app/oracle/diag -type f -mtime +14 | xargs /bin/rm -f
find /u01/app/oracle/*diag/diag -type f -mtime +14 | xargs /bin/rm -f
find /u01/app/oracle/product/11.2.0/*/log/diag/tnslsnr/*/listener/alert -type f -mtime +14 | xargs /bin/rm -f
find /u01/app/oracle/product/11.2.0/*/rdbms/log -type f -mtime +14 | xargs /bin/rm -f
find /u01/app/11.2.0/grid112020/log -type f -mtime +14 | xargs /bin/rm -f
find /u01/app/oracle/OracleHomes*/agent10g/*/sysman/log -type f -mtime +14 | xargs /bin/rm -f
find /u01/app/11.2.0/grid*/cv/log -type f -mtime +14 | xargs /bin/rm -f

#Clear alert.logs in /u01/app/oracle/diag/ folder


 #find /u01/app/oracle/diag/ -type f -name 'alert*.log' | xargs ls -lh
for item in $(find /u01/app/oracle/diag/ -type f -name 'alert*.log') ;do
zip -9 -r /u01/app/oracle/log_backup/log_backup.zip $item
cat /dev/null > $item ;done
#Clear listener.logs in /u01/app/oracle/diag/ folder
#find /u01/app/oracle/diag/ -type f -name 'listener*.log' | xargs ls -lh
for item in $(find /u01/app/oracle/diag/ -type f -name 'listener*.log') ;do
zip -9 -r /u01/app/oracle/log_backup/log_backup.zip $item
cat /dev/null > $item ;done
#Clear listener log.xmls in /u01/app/oracle/diag/ folder
#find /u01/app/oracle/diag/ -type f -name 'log*.xml' | xargs ls -lh
for item in $(find /u01/app/oracle/diag/ -type f -name 'log*.xml') ;do
zip -9 -r /u01/app/oracle/log_backup/log_backup.zip $item
cat /dev/null > $item ;done
#Clear listener.logs in /u01/app/11.2.0/grid112020/log folder
#find /u01/app/11.2.0/grid112020/log -type f -name 'listener*.log' | xargs ls -Slh
for item in $(find /u01/app/11.2.0/grid112020/log -type f -name 'listener*.log') ;do
zip -9 -r /u01/app/oracle/log_backup/log_backup.zip $item
cat /dev/null > $item ;done
#Clear logs in /u01/app/11.2.0/grid112020/opmn/logs folder
#find /u01/app/11.2.0/grid112020/opmn/logs -type f -name '*.log.*'| xargs ls -Slh
for item in $(find /u01/app/11.2.0/grid112020/opmn/logs -type f -name '*.log.*') ;do
zip -9 -r /u01/app/oracle/log_backup/log_backup.zip $item
cat /dev/null > $item ;done
#Clear listener.logs in /u01/app/oracle/product/11.2.0/*/log/ folder
#find /u01/app/oracle/product/11.2.0/*/log/ -type f -name 'listener*.log' | xargs ls -lh
for item in $(find /u01/app/oracle/product/11.2.0/*/log/ -type f -name 'listener*.log') ;do
zip -9 -r /u01/app/oracle/log_backup/log_backup.zip $item
cat /dev/null > $item ;done
mv /u01/app/oracle/log_backup/log_backup.zip /u01/app/oracle/log_backup/log_backup_"$timestamp".zip
echo "------------------------------< End Running at $timestamp >------------------------------"
#mv_log_backup.sh
#Renames the log file to include date and time
export timestamp=$( date +%d.%m.%y_%H.%M.%S )
mv /u01/app/oracle/log_backup/log_backup.log /u01/app/oracle/log_backup/log_backup_"$timestamp".log

Comments

  1. Adithya e-LearningApril 16, 2019 at 11:16 PM

    I really love it and amazing information in this blog. it's really good and great information well done. UNIX and Linux Administration.

    ReplyDelete

Post a Comment

Popular posts from this blog

QUERY DATAGUARD AND STANDBY STATUS

-- Find which logs were applied in the last day  SELECT SEQUENCE#, to_char(FIRST_TIME,'hh24:mi:ss dd/mm/yyyy'), to_char(NEXT_TIME,'hh24:mi:ss dd/mm/yyyy'),APPLIED FROM V$ARCHIVED_LOG where next_time>sysdate-1 ORDER BY SEQUENCE# ; -- Find last applied log   select to_char(max(FIRST_TIME),'hh24:mi:ss dd/mm/yyyy') FROM V$ARCHIVED_LOG where applied='YES';   -- What are the managed standby processes doing?   SELECT PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS FROM V$MANAGED_STANDBY;   -- Are we on production or standby?  SELECT DATABASE_ROLE, DB_UNIQUE_NAME INSTANCE, OPEN_MODE, PROTECTION_MODE, PROTECTION_LEVEL, SWITCHOVER_STATUS FROM V$DATABASE;   -- Check for errors  SELECT MESSAGE FROM V$DATAGUARD_STATUS;   -- Check that the DB was openned correctly   SELECT RECOVERY_MODE FROM V$ARCHIVE_DEST_STATUS; -- important lag statistics  select * from v$dataguard_stats;  -- co...
Read more

Blocking session on RAC database

Blocking session on RAC database Blocking session of the databases Generate the report for Blocking session The SQL will provide Blocking sessions with SID, node information SELECT DISTINCT S1.USERNAME || '@' || S1.MACHINE || ' ( INST=' || S1.INST_ID || ' SID=' || S1.SID || ' ) IS BLOCKING ' || S2.USERNAME || '@' || S2.MACHINE || ' ( INST=' || S1.INST_ID || ' SID=' || S2.SID || ' ) ' AS BLOCKING_STATUS FROM GV$LOCK L1, GV$SESSION S1, GV$LOCK L2, GV$SESSION S2 WHERE S1.SID=L1.SID AND S2.SID=L2.SID AND S1.INST_ID=L1.INST_ID AND S2.INST_ID=L2.INST_ID AND L1.BLOCK > 0 AND L2.REQUEST > 0 AND L1.ID1 = L2.ID1 AND L1.ID2 = L2.ID2; Blockers information select s1.username || '@' || s1.machine  || ' ( SID=' || s1.sid || ' ) is blocking '  || s2.username || '@' || s2.machine || ' ( SID=' || s2.sid || ' ) ' AS blocking_status from gv$lock l1, gv$session s...
Read more

Finding object size in Oracle database

Ref: http://www.runningoracle.com/product_info.php?cPath=2_44&products_id=153 Finding object size in Oracle database is very important and common. Is it very useful to know the exact size occupied by the object at the tablespace. The object size in the following scripts is in Mbytes. The scripts have been formatted to work very easily with TOAD SQL Editor. For example you can filter with tablespace_name, or owner, or size (for example more than 1GByte)  SELECT owner, segment_name, segment_type, partition_name, ROUND(bytes/(1024*1024),2) SIZE_MB, tablespace_name  FROM DBA_SEGMENTS  WHERE SEGMENT_TYPE IN ('TABLE', 'TABLE PARTITION', 'TABLE SUBPARTITION',  'INDEX', 'INDEX PARTITION', 'INDEX SUBPARTITION', 'TEMPORARY')  --AND TABLESPACE_NAME LIKE 'COSTE%'  --AND SEGMENT_NAME LIKE 'P2010201%'  --AND partition_name LIKE 'P20100201%' --AND segment_type = 'TABLE' --AND OWNER = 'TARG...
Read more