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

How to recovery PDB when PDB database is dropped in Oracle

  How to recovery PDB when PDB database is dropped :) [oracle@rac01 ~]$ sqlplus '/as sysdba' SQL*Plus: Release 21.0.0.0.0 - Product...