- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Oracle 7.3.3 to 8i - exporting info
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
тАО04-08-2002 11:32 AM
тАО04-08-2002 11:32 AM
Some background: I'm looking for some info for our DBAs. We are currently running Oracle 7.3.3 on HP-UX 10.20. We are looking to move to Oracle 8i on HP-UX 11i (on a different server). The current Oracle database is about 30 Gb. I personally know very little about Oracle, but I'm told that you can perform a full export in 7.3.3 and use that to import into 8i to move the database. However, the DBAs said that with the 2 GB file size limitation in HP-UX 10.20, this is not an option.
Basically, I'm looking for a way to move a 30 GB Oracle 7.3.3 database running on an HP-UX 10.20 K class to Oracle 8i runing on an HP-UX 11i rp7400.
I don't really need specifics just yet, just some 10,000 foot ideas on how to best go about doing this that I can run by the DBAs.
Thanks in advance!
Tim
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-08-2002 11:43 AM
тАО04-08-2002 11:43 AM
Re: Oracle 7.3.3 to 8i - exporting info
e.g. cat < /tmp/mypipe > /u01/myfile.exp
You then direct the Oracle export to /tmp/mypipe and your are done.
The 8i import can normally handle large files but if not, you can do the inverse operation for the import as well.
Regards, Clay
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-08-2002 11:53 AM
тАО04-08-2002 11:53 AM
Re: Oracle 7.3.3 to 8i - exporting info
You can have filess up to 128GB on 10.20 if you are running JFS version 3:
http://docs.hp.com/hpux/onlinedocs/5971-2383/5971-2383.html
However, if that is an issue for you, you can export into a pipe (see man 'mknod' or man 'mkfifo') and using 'split' divide your Oracle export into multiple files.
Regards!
...JRF...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-08-2002 12:03 PM
тАО04-08-2002 12:03 PM
Re: Oracle 7.3.3 to 8i - exporting info
I thought I'd remembered an earlier post describing the actual implementation of the export using a pipe with 'split'. Here it is:
http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0xcc4668c57f64d4118fee0090279cd0f9,00.html
Regards!
...JRF...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-08-2002 01:01 PM
тАО04-08-2002 01:01 PM
Re: Oracle 7.3.3 to 8i - exporting info
To save additinal space, you can compress the export on the flt with:
/etc/mknod /tmp/tmp_pipe p
nohup compress < /tmp/tmp_pipe >export_file_name.dmp.Z &
Food for thought ...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-08-2002 01:02 PM
тАО04-08-2002 01:02 PM
Re: Oracle 7.3.3 to 8i - exporting info
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-09-2002 01:02 AM
тАО04-09-2002 01:02 AM
Re: Oracle 7.3.3 to 8i - exporting info
Or you can avoid export and create a data base link and use several ' create as select'... ( you dba will understand).
But, of course, 10.20 can manage files greater than 2GB, if you create a filesystem with largefiles option.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-09-2002 02:46 AM
тАО04-09-2002 02:46 AM
Solutionjust sharing something my guru (tom kyte) explained a few months back. Hope this helps.
Best Regards
Yogeeraj
PS. Get your DBAs to buy his last book: One-on-One Expert Oracle.
---------------------------------------------
You would export to a device that does not support seeking such
as a tape (not recommended, really slow) or a pipe.
Why not using compression? it'll considerably cut down on the
size?
I myself use both compression AND split to make my export be in
many managable sized file (500meg is my chosen size). You could
just use split and not compress if you want.
Basically, you would create a pipe in the OS via:
$ mknod somefilename p
and then export to that pipe. you would set up another process
in the background that 'eats' the contents of this pipe and puts
it somewhere. I use split, you could use 'cat' to just put it
into another file (if cat supports files >2 gig -- thats the
problem here, most utilities do not, you need to use a special
file io api to 2 gig file support).
Here is a script you can use as a template. Yes, it uses
compression but you can take that out. Its here to show you one
method of doing this.
------------------------------
#!/bin/csh -vx
setenv UID /
setenv FN exp.`date +%j_%Y`.dmp
setenv PIPE /tmp/exp_tmp_ora8i.dmp
setenv MAXSIZE 500m
setenv EXPORT_WHAT "full=y COMPRESS=n"
echo $FN
cd /nfs/atc-netapp1/expbkup_ora8i
ls -l
rm expbkup.log export.test exp.*.dmp* $PIPE
mknod $PIPE p
date > expbkup.log
( gzip < $PIPE ) | split -b $MAXSIZE - $FN. &
# uncomment this to just SPLIT the file, not compress and split
#split -b $MAXSIZE $PIPE $FN. &
exp userid=$UID buffer=20000000 file=$PIPE $EXPORT_WHAT >>&
expbkup.log
date >> expbkup.log
date > export.test
cat `echo $FN.* | sort` | gunzip > $PIPE &
# uncomment this to just SPLIT the file, not compress and split
#cat `echo $FN.* | sort` > $PIPE &
imp userid=sys/o8isgr8 file=$PIPE show=y full=y >>& export.test
date >> export.test
tail expbkup.log
tail export.test
ls -l
rm -f $PIPE
--------------------------------------------------
This also always does an 'integrity' check of the export right
after it is done with an import show=y, that shows how to use
these split files with import.
--------------------------------------------------
!!!
cat `echo $FN.* | sort` | gunzip > $PIPE &
sorts the filenames, sends them to cat, which give them to gunzip in the right
order.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-09-2002 08:02 AM
тАО04-09-2002 08:02 AM
Re: Oracle 7.3.3 to 8i - exporting info
Thanks for all the responses! I got what I wanted, and that is the general consensus is that we should export using named pipes in some form or another.
I can't tell you how much I appreciate all the help! Thanks again!
Tim