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

Index rebuild online in Oracle - shell script

  [oracle@rac10p reorg]$ cat index_rebuild_EMP.sh #!/bin/ksh export ORACLE_HOME=/oracle/K12/19 export ORACLE_SID=K12 export PATH=$PATH:/$ORA...