Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Retrieve Oracle export to tape Post 2714 by sdharmap on Thursday 31st of May 2001 10:09:30 AM
Old 05-31-2001
Question Retrieve Oracle export to tape

Hi!

We have an Oracle db export that was compressed and written to DLT tape directly!- This is from box1

The next step is to restore the contents of the tape into the database on box2. The problem is that there is no DLT tape drive attached to box2. There is a box3 that has the tape drive attached to it!

Box 2 and box3 are on the same network!

How can I use the tape drive on box3 to restore the data from the tape into the database on box2?

Thanks,

Suresh
 

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
tms(4)							     Kernel Interfaces Manual							    tms(4)

Name
       tms - TMSCP magnetic tape interface

Syntax
       For UNIBUS, Q-bus:
	  controller klesiu0 at uba0
	  controller uq0 at klesiu0 csr 0174500 vector uqintr
	  tape tms0 at uq0 drive 0

       For MSI Bus:
	  adapter msi0 at nexus?
	  controller dssc0 at msi0 msinode 0
	  tape tms0 at dssc0 drive 3

       For VAXBI:
	  controller klesib0 at vaxbi0 node 0
	  controller uq0 at klesib0 vector uqintr
	  tape tms0 at uq0 drive 0

	  controller aie0 at vaxbi? node?
	  controller bvpssp0 at aie0 vector bvpsspintr
	  tape tms0 at bvpssp0 drive 0

       For MSI Bus:
	  adapter msi0 at nexus?
	  controller dssc0 at msi0 msinode 0
	  tape tms0 at dssc0 drive 0

       For VAX CI/HSC:
	  adapter ci0 at nexus?
	  adapter ci0 at vaxbi? node?
	  controller hsc0 at ci0 cinode 6
	  tape tms0 at hsc0 drive 3

Description
       Prior to Version 2.0, this device was referenced by tmscp(4).

       The  TMSCP  driver  provides  a standard tape drive interface, as described in This is a driver for any controller that adheres to the Tape
       Mass Storage Control Protocol (TMSCP).  The TMSCP controllers communicate with the host through a packet-oriented protocol termed the  Tape
       Mass  Storage  Control Protocol.  This driver also supports n-buffered reads and writes to the raw tape interface (used with streaming tape
       drives).  See for further details.

Tape Support
       TK50, TK70, TF70, TU81, TU81e, TA78, TA79, TA81, RV20, TA90, TA90E, TA91

Diagnostics
       All diagnostic messages are sent to the error logger subsystem.

Files
See Also
       mtio(4), nbuf(4), MAKEDEV(8), uerf(8), tapex(8)
       Guide to the Error Logger

																	    tms(4)
All times are GMT -4. The time now is 07:36 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy