topic Re: make export script in Operating System - HP-UX

make export script

tareq_2 — Sat, 21 Jun 2008 07:48:23 GMT

hi all
I have rp7420 server with hp-ux 11iv1 And Oracle 10g installed, i want to backup the database to tape drive "Ultrium 215 Removable tape drive" i want to make export script
thanks

Re: make export script

tareq_2 — Sat, 21 Jun 2008 09:22:54 GMT

i have read some forums and i found this:
exp $d_system file=/dev/ntape/tape1c volsize=0 \
buffer=100000 \
constraints=y \
grants=y \
indexes=y \
rows=y \
compress=n \
statistics=none \
full=y \
log=$LOGS/$ORACLE_SID/$LOG_DATE.log < $TOOLS/exp.input_file
sleep 120
#mt -f /dev/ntape/tape1c offline
echo " 1st export Completed. "
#
exp $q_system file=/dev/ntape/tape1c volsize=0 \
buffer=100000 \
constraints=y \
grants=y \
indexes=y \
rows=y \
compress=n \
statistics=none \
full=y \
log=$LOGS/$ORACLE_SID/$LOG_DATE.log < $TOOLS/exp.input_file
sleep 120
#mt -f /dev/ntape/tape1c offline
echo " 2nd export Completed. "
exit
is this script work in my case
please i need help
i need how to make export script????
thanks

Re: make export script

Kenan Erdey — Sat, 21 Jun 2008 17:28:52 GMT

Hi,

if you want to do a cold backup, shutdown oracle. and backup your directories where reside your datafiles and archive logs by using command below. by fbackup command you can schedule your backps setting it to cron.

fbackup -f /dev/rmt/0m -i /

if you want to do it in proffesional way, you can use RMAN

Kenan.

Re: make export script

tareq_2 — Sun, 22 Jun 2008 04:32:01 GMT

hi Kenan.
i want to make script for my customers to make backup for database
i ask not the way to use the tape but about export command and make it as script and in this script i will but the command of the tape.
thanks

Re: make export script

Aashique — Sun, 22 Jun 2008 06:06:56 GMT

Hi,
Please check the attached script.

Thanks & Regards

Re: make export script

tareq_2 — Sun, 22 Jun 2008 06:48:19 GMT

hi Aashique
thank you for support
this is your script:

export ORACLE_HOME=/appl/oracle/product/10.2
export PATH=$ORACLE_HOME/bin:/usr/contrib/bin:/usr/bin:.
. /appl/oracle/.profile

export org_dir=/exp_bkup
export logdir=/exp_bkup/log
mkfifo $org_dir/exp_fifo_file

gzip > $org_dir/DB_full_`date "+%y%m%d"`.dmp < $org_dir/exp_fifo_file &
sleep 5

exp file=$org_dir/exp_fifo_file log=$logdir/DB_full_`date "+%y%m%d"`.log statistics=none direct=y full=y <>
my question if could help me what is the change i will made in this script to be compatiple with my oracle directory
becuase i dont know what this lines mean:-
=========>>
export org_dir=/exp_bkup
export logdir=/exp_bkup/log
mkfifo $org_dir/exp_fifo_file
=======<<
is this a Directories must i make it(org_dir),(=/exp_bkup),(/exp_bkup/log)
and thanks again

Re: make export script

Aashique — Sun, 22 Jun 2008 07:58:25 GMT

Hi,
No you can create directory in your own way.
you can change the /exp_bkup directory anywhere you want.
And database username/password@dbname need to change.Other all are ok.

Thanks & Regards

Re: make export script

tareq_2 — Sun, 22 Jun 2008 08:11:36 GMT

hi Aashique
big thanks for you
i have just one question
can i write another line to the script to but the backup to the tape drive and what is the command.
regards

Re: make export script

Aashique — Sun, 22 Jun 2008 08:32:37 GMT

Hi,
tar cvf /dev/rmt/0mn /exp_bkup

Thanks & Regards

Re: make export script

tareq_2 — Sun, 22 Jun 2008 08:36:50 GMT

the script what is attached is helpful
thanks for you Aashique
best regards