- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: make export script
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-21-2008 12:48 AM
тАО06-21-2008 12:48 AM
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-21-2008 02:22 AM
тАО06-21-2008 02:22 AM
Re: make export script
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-21-2008 10:28 AM
тАО06-21-2008 10:28 AM
Re: make export script
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-21-2008 09:32 PM
тАО06-21-2008 09:32 PM
Re: make export script
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-21-2008 11:06 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-21-2008 11:48 PM
тАО06-21-2008 11:48 PM
Re: make export script
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-22-2008 12:58 AM
тАО06-22-2008 12:58 AM
Re: make export script
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-22-2008 01:11 AM
тАО06-22-2008 01:11 AM
Re: make export script
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-22-2008 01:32 AM
тАО06-22-2008 01:32 AM
Re: make export script
tar cvf /dev/rmt/0mn /exp_bkup
Thanks & Regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-22-2008 01:36 AM
тАО06-22-2008 01:36 AM
Re: make export script
thanks for you Aashique
best regards