Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Retrieve Oracle export to tape Post 2724 by alwayslearningunix on Thursday 31st of May 2001 11:21:11 AM
Old 05-31-2001
Depends how large the Oracle export file is.

You could always restore the file into a filesystem on box3 and then use NFS to mount that drive on to a filesystem on box2.

NFS is simple enough to use, depending on your flavour of UNIX there will be a nfsconf file with all the the network files, in HP-UX it is in /etc/rc.config.d/. The entries in here are self explanatory - box3 will need to be a server and client. Create an exports file on this box to detail what directory you want to export, and then simply use the exportfs command to export.

Modfiy the nfsconf file on box2 to make it a client. Start the nfs sub-system on box3 by locating the start script, which will be with all the other networking start scripts, in HP-UX this is /sbin/init.d/ - if you're unsure where it is all these scripts are linked to the run level scripts in rc1.d/rc2.d/rc3/d etc.

Then start nfs on box2. Make sure you do it in this order - the server needs to be started before the client or else the client will hang while it looks for the nfs server.

The syntax on box2 then, to mount the exported filesystem is a logical extension of the normal mount syntax:

mount [nfsserver]:[exported_directory] [local_directory]

Having said all this, attention must be made to network impact, if the export is very large, exporting the directory will put a consequent strain on the network and you may become very unpopular very fast.

If this isnt an issue run man pages on nfs and exportfs to get a better picture if you're stuck at any point.

Hope this helps.

Regards.
alwayslearningunix
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

export table from oracle database

i would like to export a particular table in my oracle database installed in a hpux box. i would like to determine the filesize of the output before performing these action so i can assess if my harddisk can still handle it. thanks as usuall :rolleyes: (1 Reply)
Discussion started by: inquirer
1 Replies

2. Solaris

export oracle schemas

Hi, How do i export selected Oracle database schemas from HpUnix? Is it possible to export it to a windows shared drive? If so how do i do it? Pls advice. Thanks in advance. (4 Replies)
Discussion started by: nicky88
4 Replies

3. UNIX for Advanced & Expert Users

full export oracle on aix

Hi I have an oracle 7.3.4 running on an aix 4.3, I need to make a full export of the db and I haven't space on disk. Can I export directly to a tape drive? Has anybody a script to do so or something that can help me to? thank you very much (1 Reply)
Discussion started by: andwhat
1 Replies

4. AIX

how to use tar to retrieve all tape content

Hi, I use tar to backup the following programs: tar -cvf /dev/rmt0.1 u04/devdb/log/arch tar -cvf /dev/rmt0.1 u01/app/oracle/product/10.2.0.2/dbs tar -cvf /dev/rmt0 u01/app/oracle/product/10.2.0.2/network/admin when I want to retrieve the tape content list with: tar -tvf /dev/rmt0 it... (1 Reply)
Discussion started by: victorcheung
1 Replies

5. UNIX for Advanced & Expert Users

Failing to write retrieve script for tape to disk conversion

I have the below script which has been written to retrieve files from tape drive i.e. TSM server. Now i have to write the script using UNIX commands for retrieve operation but I am not able to proceed. The script is: #!/usr/local/bin/expect -f set timeout 1800 set file spawn $env(SHELL)... (0 Replies)
Discussion started by: hrsaurav
0 Replies

6. Shell Programming and Scripting

Oracle export

Hi Experts , Does anybody know the sheel scripts , which exports oracle tables into xls files . Thanks for your feedback. Regards Pranav (1 Reply)
Discussion started by: Heisonline
1 Replies

7. Shell Programming and Scripting

How to do Parallel Export in Oracle DB

I intend to do parallel export of my Oracle db (i.e all the schema in my db). Currently I'm using the below exp command in my script: exp $uid/$pwd@$ORACLE_SID FILE=./DUMP/$today$username.dmp STATISTICS=NONE LOG=./LOG/$today$username.log For parallel export what should I use? Please... (1 Reply)
Discussion started by: priya001
1 Replies

8. Shell Programming and Scripting

Parallel export of all oracle DB schema.

In my Oracle db there are 4 schemas. All the username & passwords are stored in a text file. I am using a while loop to export all the schemas. It read the first line and doing the export. For all users it export one by one. But I need all the schemas will exported simultaneously. i.e. all the... (1 Reply)
Discussion started by: priya001
1 Replies

9. Shell Programming and Scripting

Unable to retrieve data from shell when connected to Oracle

I am trying to get the data from oracle table to a variable I have tried the below code #/usr/bin/sh echo " I am in correct loop" SPOOL_FILE=/app/scripts/alt.lst sqlplus /nolog <<END_SQL connect bindu/bindu@gis whenever sqlerror exit failure rollback;... (4 Replies)
Discussion started by: Kiransagar
4 Replies

10. Homework & Coursework Questions

DB2 Export and Import Oracle

Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted! 1. The problem statement, all variables and given/known data: is this enough to make the data perfect export into delimited file? there are some posted that i read, they... (9 Replies)
Discussion started by: Sonny_103024
9 Replies
mt(1)							      General Commands Manual							     mt(1)

Name
       mt - magnetic tape manipulating program

Syntax
       mt [-f tapename] command [count]

Description
       The command permits the operation of a magnetic tape drive.

Options
       The  -f	flag  option  uses  the specified tape device (next argument) in place of either that tape device defined by your TAPE environment
       variable (.login or .profile) or /dev/nrmt0h.

       Some operations may be performed multiple times by specifying count.  By default, performs the requested operation once.

       The command argument defines the operation to be performed.  Only as many characters as are required to uniquely identify a command need be
       specified.

       The following is a list of commands:

       bsf		   Backspace count files.

       bsr		   Backspace count records.

       cache		   Allows to use the cache buffer on a tape drive that has the cache buffer feature.

       clhrdsf		   Clear  hardware/software problem.  Works with tape drives which use the TMSCP tape controller interface This command is
			   restricted to root access only.

       clserex		   Clear serious exception.  Works with tape drives which use the TMSCP tape controller interface

       clsub		   Clear subsystem.  Works with tape drives which use the TMSCP tape controller interface This command	is  restricted	to
			   root access only.

       eof, weof	   Write count end-of-file marks at the current position on the tape.

       eotdis		   Disable  end-of-tape  detection.   When the end of tape is reached, the tape will run off the reel.	Only the superuser
			   can issue this command.  The command remains in effect for the device until end-of-tape detection is enabled  with  the
			   eoten command.

       eoten		   Enable  end-of-tape	detection.   When the end-of-tape markers are reached, the tape is halted on the reel, between the
			   two end-of-tape markers.  Only the superuser can issue this command.  The command remains  in  effect  for  the  device
			   until end-of-tape detection is disabled with the eotdis command.  This is the default mode after a system boot.

       fsf		   Forward-space count files.

       fsr		   Forward-space count records.

       nocache		   Disables the use of the cache buffer for any tape drive that has the cache buffer feature.

       offline, rewoffl    Rewind the tape and place the tape unit off-line.

       retension	   Retensions the tape.  Retension means moving the tape one complete pass between EOT and BOT.

       rewind		   Rewind the tape.

       status		   Print status information about the tape unit.

Examples
       This example shows how to rewind the tape
       mt -f /dev/rmt0l rewind
       This example shows how to backspace the tape nmt1h three files:
       mt -f /dev/nrmt1h bsf 3
       This example shows how to write two end-of-file marks at the current position on tape nmt6h:
       mt -f /dev/nrmt6h eof 2

Return Values
       In  shell  scripts, returns a 0 exit status when the operation(s) were successful, 1 if the command was unrecognized, and 2 if an operation
       failed.

Files
       /dev/rmt?h or /dev/rmt?l
		 Raw magnetic tape interface with rewind when closed

       /dev/nmt?h or /dev/nmt?l
		 Raw magnetic tape interface with no rewind when closed

See Also
       dd(1), tar(1), ioctl(2), mtio(4), tms(4), environ(7)

																	     mt(1)
All times are GMT -4. The time now is 12:56 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy