move_physical.sh.txt

管理online的shell程序

#!/usr/bin/ksh
###############################################################################
#
#       Module:         move_physical.sh
#       Author:         Peter R. Schmidt
#       Description:    Move the physical log and change it's size
#
#       Change Log
#
#         Date    Name               Description.................
#       06/21/00  Peter R. Schmidt   Start Program
#
###############################################################################

echo
echo "What size do you want for the new physical log ? (in kbytes)"
echo "Note: it must be slightly smaller then the size of the dbspace"
echo "that it will reside in)."
read NEW_SIZE

echo
echo "What DBSPACE will the physical log reside in ?"
read NEW_DBSPACE

echo 
echo "New size:    $NEW_SIZE kbytes"
echo "New DBSPACE: $NEW_DBSPACE"
echo
echo "Press <Enter> to continue <INTERRUPT> to quit"
read answer

###############################################################################

onmode -uy

sleep 5

onparams -p -s $NEW_SIZE -d $NEW_DBSPACE -y

sleep 5

onmode -m