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

100 Oracle DBA Interview Questions and Answers

  Here are 100 tricky interview questions tailored for a Senior Oracle DBA role. These questions span a wide range of topics, including perf...