Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • USE_NL and INDEX hints example Oracle
  • Oracle Recommended Patches — Oracle Database ID 756671.1 Oracle
  • Oracle Data Direct to TAPE Oracle
  • find_longsql.sql Oracle
  • Check SQL Server edition SQL Server
  • moving lob object to other tablespace lob_mvmt.sql Oracle
  • chk_space_SID.ksh Linux/Unix
  • Find execution plan from dba_hist_sql_plan for a specific SQL_ID and PLAN_HASH_VALUE fplan.sql Oracle
  • perf_today.sql Oracle
  • Histogram information Oracle
  • Finding Oracle Patches with opatch Oracle
  • Privileges Required to Create Procedures and Functions that uses objects from other schema. Oracle
  • sess1.sql Oracle
  • Export With Query Another Example. Oracle
  • segment_wise_space.sql segspace.sql Segment wise space usage (allocated and used) Oracle

Follwoing korn shell is used to move files from source folder to destination folder and gzip it in destination folder. mv_iotto.ksh

Posted on 20-Jun-2006 By Admin No Comments on Follwoing korn shell is used to move files from source folder to destination folder and gzip it in destination folder. mv_iotto.ksh

#!/usr/bin/ksh

a=`ps -ef|grep “mv_iotto.ksh”|grep -v grep|wc -l`

if [ $a -gt 2 ]

then

echo “Exiting because of more than 1 Moving archive log script is running ”

exit

fi

for fname in `ls -rlt /tmpdb2/oradata/UOCIOTTO_ARCH/*.arc | awk ‘{print $9}’ | sed ‘$d’ | sed ‘$d’`

do

print “”;

print “File Name : $fname “;

dest_file=`echo $fname| cut -c31-80`;

print “dest_file = $dest_file”;

dest_file_with_path=”/tmpdb4/oradata/UOCIOTTO_ARCH/$dest_file”;

print “dest file with path = $dest_file_with_path”;

print “Processing mv $fname $dest_file_with_path…..”;

mv $fname $dest_file_with_path;

print “Processing gzip $dest_file_with_path…..”;

gzip $dest_file_with_path;

done

Linux/Unix, shell

Post navigation

Previous Post: sess_server.sql
Next Post: How to stop OCSSD Daemon

Related Posts

  • Session_info.ksh Linux/Unix
  • Unix split command to split files Linux/Unix
  • Some useful Unix Commands Linux/Unix
  • cold backup scripts to copy locally Linux/Unix
  • good linux notes Linux/Unix
  • age_alert.ksh aging out alert.log Linux/Unix

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

  • Ansible (0)
  • AWS (2)
  • Azure (1)
  • Django (0)
  • GIT (1)
  • Linux/Unix (150)
  • MYSQL (5)
  • Oracle (403)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (1)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (18)
  • rman-dataguard (26)
  • shell (151)
  • SQL scripts (349)
  • SQL Server (6)
  • Uncategorized (5)
  • Videos (0)

Recent Posts

  • Key Management in Oracle: The Core Issue: Missing Master Key12-May-2026
  • SAT Mathematics 10 questions and answer at the end.30-Apr-2026
  • top 10 AI news today30-Apr-2026
  • runon_allpdbs_show_conname.sh23-Apr-2026
  • runon_allcdbs_find_pdbs.sh23-Apr-2026
  • Running PDB on single node in RAC09-Apr-2026
  • find_arc.sql09-Apr-2026
  • pvm_pre_change.sql08-Apr-2026
  • find_encr_wallet.sql08-Apr-2026
  • find_pdbs.sql08-Apr-2026

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • DBMS_UTILITY.ANALYZE_SCHEMA Oracle
  • pvm_metric.sql for gathering report from vmstat tables Oracle
  • Rollback force for distributed transactions Oracle
  • Trace a SQL session from another session using ORADEBUG Oracle
  • JSON/XML Types in Oracle Oracle
  • Oracle 10g for solaris 10 Oracle
  • cif crons Linux/Unix
  • remove archfiles only when it is applied to DR rm_archfiles.sh Linux/Unix

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme