Link to home
Start Free TrialLog in
Avatar of Triple Jay
Triple JayFlag for United States of America

asked on

Mount a share from another server

===================
SOURCE SERVER (9i)
===================
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda9             494M  365M  103M  78% /
/dev/sda1              99M   15M   78M  16% /boot
/dev/sda3             3.9G  3.7G  102M  98% /db01
/dev/sda8             3.5G  3.2G  191M  95% /home
/dev/sda5             3.4G  2.5G  727M  78% /opt
none                  503M     0  503M   0% /dev/shm
/dev/sda6             3.0G  2.6G  293M  90% /tmp
/dev/sda7             7.7G  7.1G  242M  97% /usr
/dev/sda10           1004M  898M   55M  95% /var



===================
TARGET SERVER (10g)
===================
Filesystem            Size  Used Avail Use% Mounted on
/dev/cciss/c0d0p2      62G  7.1G   52G  13% /
/dev/cciss/c0d0p1      97M   15M   77M  16% /boot
none                  2.0G     0  2.0G   0% /dev/shm
======================================================


Platform is Linux 8.
I need to take backup of oracle 9i using rman or exp/imp but the problem is:
i.   9i (source server has hardly got any space for backup)
ii.  I want to mount a share from the 10g server onto 9i (using nfs or watever) and try to store the dmp file or rman files ont the 10 share.
iii. Is there any other alternate to backup the 9i database onto 10g share?
iv. any instructions availabe?
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

The easiest way would be as you already mentioned, mount an NFS on the 9i box.  I'm not on UNIX anymore but there should be tons of information on how to set up an NFS share.
ASKER CERTIFIED SOLUTION
Avatar of abuckheit
abuckheit

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Triple Jay

ASKER

Hi abu,
Your reply is interesting, what kinda client are you talking about ?
what i understood for now is that you want me to remotely export the 9i database while i am logged onto the 10g server.
what will the exp command look like?
i just actually did something similar.

exp.exe user/password@database FILE=c:\dump.dmp LOG=c:\dump.log FULL=Y

that will put the dump.dmp file and the dump.log file on the local c: drive from wherever it is executed from.

your on linux..
so, get on your 10G server where you want the dump file

goto the oracle bin directory where the exp util is located

execute:
exp user/password@database FILE=/path/dump.dmp LOG=/path/dump.log FULL=Y

database = connect string to the 9 db.  usually the tns name.

that will place the dump file on the 10G server in the dir you specify.


i am out of office for now. what you say makes sense but I am talking about two different physical hosts.
Lets see wat happens.
gonna try that tomorrow.
will keep you posted.
Ok, good luck with it.

The import and export utilities always access/create files on the client (connecting) side.
ie,
exports will create the dump on the client side,
imports will read from a dump on the client side.

Also on a side note, you should rearrange your partitions or get more disk space.  No file system can perform well with such a high % of usage.  Because of the added work needed by the disk heads, It is degrading the performance of your DB and potentially shortening the life of the drive(s).
Hi again abu,
the side note; actually thatz the very reason I am backing up 9i on 10g, to stay on the safe side. After that I am going to migrate from 9i to 10g server and hence 10g will be the production server.
btw i am not even sure whether my network is going to handle such a big load of exporting giga bytes of data on to a different server. And I am not sure how long its gonna take.
I wanted to back up the 9i database and then go for the big full export. but what you are suggesting might help in doing both tasks; by doing a full export i get a kinda backup as well, rite? and the dmp can be imported in 10g too.
any tips on that?
if both servers are on a LAN you will be fine.  If you can keep people from accessing the 9 db and running huge select statements and such then expect it to take a couple hours.  But 4GB (and it should be less than the actual db files size) over 2 hours = 1GB/hour =    
17MB/min = (aprox) 300KB/s which shouldnt drain your network resources at all.  Im sure there is some overhead i didnt account for, but im sure its not much.  If you are that concerned i can run a test tommrow but the test alone will take a couple hours.

i wouldnt be concerned about that unless your network is already pegged constantly or if its over a WAN.

hi buddy,
I tried, getting the following:
[oracle@server oracle]$ exp user/pass@munroe.xyz.abc.com
Export: Release 10.1.0.2.0 - Production on Wed Feb 28 11:22:23 2007
Copyright (c) 1982, 2004, Oracle.  All rights reserved.
EXP-00056: ORACLE error 12514 encountered
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
EXP-00000: Export terminated unsuccessfully
[oracle@server oracle]$
ok, are you familiar with the tnsnames system?  Also how are these servers connected.


if EZConnect is enabled you could do this:

user/pass@//munroe.xyz.abc.com/SIDorSERVICENAME

otherwise you would have to add a tns names entry.  
in which tnsnames.ora  i have to add the entry?
on remote server 10g
or host  9i?
the client where you are running the EXP from
guess what abu.
i'll have to install the 9i client on the 10g server inorder to export from 10g.
your right, im sorry.  I actually just started a 9 export 5min ago and came to the same realization, sorry about that.

Also another thing on huge exports that I ran into, sometimes after some time (hour+) the exp will lose focus or something and just sit there, if you hit enter or something it will get going again.  Its wierd and i dont know why it does it (it doesnt do it often but im letting you know just in case) but i started a large export last night and this morning it had only  exported about 3GB worth, so i went to the window and hit enter and it started going again.
I stand by my original comment:
The easiest way would be as you already mentioned, mount an NFS on the 9i box.

This would also allow you to use RMAN or any other backup method.
that is not even as close to as easy as 2 commands...one export command, and one import command.  you'd have to set up an nfs, and if he hasn't set one up before he'd have to learn how to do that, then learn how to mount an nfs.  Then he would have to export and import it anyway.  Or use RMAN, but tthat again adds complexity.  

That method adds multiple layers of difficulty that are unnecessary.

If there is trouble connecting from one server to another he'd still have trouble with that method, and he would have to resolve it with Oracle as well as NFS .

judejames, were you able to get the export going, or are you still having trouble connecting?
Using an NFS mount would not require the installation of the 9i client on the 10g server.  Same 2 commands w/o another Oracle_home.  To me, that is simpler.

The only reason I mentioned RMAN is the asker did in the original question.