Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Changing Instance Name ( No DB_NAME) Oracle
  • move_arch_files.ksh Linux/Unix
  • SQLPLUS COPY command Precautions. Oracle
  • How to Use DBMS_STATS to Move Statistics to a Different Database Oracle
  • Rman Notes -1 Oracle
  • SCRIPT TO LIST RECURSIVE DEPENDENCY BETWEEN OBJECTS UTLDTREE.sql Oracle
  • Trace a SQL session from another session using ORADEBUG Oracle
  • Logic to chech # of parameters command line parameters Linux/Unix
  • Composite Index creation tip from Vivek Oracle
  • Privileges Required to Create Procedures and Functions that uses objects from other schema. Oracle
  • DBMS_STATS Metalinks Notes Oracle
  • SQL Tracker by SID sqltrackerbysid.sql Oracle
  • handling filenname with space Linux/Unix
  • normal maintenance for exp-imp and renaming table Oracle
  • In Addition to previous note, following grants needed on PERFSTAT user. 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

  • default permission on ~/.ssh/authorized_keys2 or authorized_keys Linux/Unix
  • Sending email with file attachment. Linux/Unix
  • Sort with ASCII order and Numeric Order Linux/Unix
  • prepfiles.sh for step by step generating pending statistics files Oracle
  • Logic to chech # of parameters command line parameters Linux/Unix
  • Space padding in korn shell 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 (149)
  • MYSQL (5)
  • Oracle (403)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (1)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (18)
  • rman-dataguard (26)
  • shell (150)
  • SQL scripts (350)
  • 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.sql23-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
  • Query to Generate aggregate on every 30 mins. Oracle
  • V$transaction notes for finding XID composition. Oracle
  • refre.sql for multitenant Oracle
  • Nice Article about semaphores and init.ora Processes parameter relations Linux/Unix
  • How to change hostname in Linux Linux/Unix
  • Display the top 5 salaries for each department using single SQL Oracle
  • currwait.sql Oracle
  • UNderstand and eliminate Latch contention. Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme