Disclaimer

Wednesday, 21 October 2020

How to move trace and trim files to particular location – Shell script?

 

How to move trace and trim files to particular location – Shell script?

In below shell script, we are moving .trc and .trm file in to /backup/oracle/db_share/test_logs location 

test_housekeeping1.sh

 

export ORACLE_SID=TEST

export ORACLE_BASE=/applications/oracle

export ORACLE_HOME=/applications/oracle/18.4.0.1

TS=`date +%d%m%y`s

export TS

cd /ORACLE/TEST/diag/rdbms/test/TEST/trace

find . -name "$ORACLE_SID*.trc" -exec mv {} /backup/oracle/db_share/test_logs \;

find . -name "$ORACLE_SID*.trm" -exec mv {} /backup/oracle/db_share/test_logs \;

No comments:

Post a Comment

Understanding SQL Plan Baselines in Oracle Database

  Understanding SQL Plan Baselines in Oracle Database SQL Plan Baseline is the feature in Oracle started from Database 11g that helps to pre...