Thanks again:
"Richard C. Mills" <rmills@atl1.america.net>
"Win Htin" <winhtin@csfb.co.jp>
My final solution is:
1. on the local machine which has sybase to be dumped, mount /remotedump from a remote server which has a tape drive;
2. on the local machine, use crontab to do:
dump database db_name to "/remotedump/dump.dat"
dump tran db_name to "/remotedump/tran.dat"
3. on the remote machine. use crontab to do:
cd /remotedump; tar cvf tape_device *.dat
To do a load,
I need to un-tar those two .dat files before loading them.
-Judy H.
---------------------------
Thanks a lot to:
Development <devjrt@sonic.urich.edu>
mike@trdlnk.com (Michael Sullivan)
jrussell@gate.comdata.com (John Russell)
keith@oz.health.state.mn.us (Keith Willenson)
Marina.Daniels@ccd.tas.gov.au (Marina Daniels)
Bob Fulwiler <bobf@psa.pencom.com>
george@dbms.com (George L Roman)
scott@msi-uk.com (Scott McDonald)
"Marks, Evan R" <markser@aetna.com>
"Ing. Carlos Ramon Guevara" <cguevara@ns.sinfo.net>
skip@hisnj.com (Paul Seelaus)
The answer is:
1. On the remote host (which has a tape drive), export a file system, eg. /remotedump;
2. On the local host (which has sybase to be dumped), mount that /remotedump;
3. On the local host, make /remotedump/dump.dat as the "disk" type dumpdevice;
4. Do the dump to /remotedump/dump.dat on the local host;
5. On the remote host, use "tar" to copy /remotedump/dump.dat to a tape.
It works, but, If I want to do a LOAD, I have to un-tar that tape to a file, and then load that file using sybase's command.
I cann't load that tape directly from the tape drive since the blocksize of the tape image is not recognized by sybase.
I cann't find the blocksize of /remotedump/dump.dat when I copy it to the tape, so I use tar, if so, maybe I can use dd. Can you tell me how to find the blocksize of /remotedump/dump.dat?
And, if I use a tape drive attached to sybase locally, I can dump both database and tran to the same tape.
But, I cannot dump both database and tran to the same filename (eg. /remotedump/dump.dat). Is there a way to do so?
thanks a lot for you patient.
-Judy
-------------------
My question was:
I'am new to SYBASE admin. and I have a question. I've searched SYBOOK without help.
We have a SUNOS with SYBASE installed and our database is dumped everyday to it's local tape drive.
Is it possible to remote dump our database to a Solaris machine which is not running SYBASE?
If so, how?
I tried: dump database db_name to "/dev/rst1" at host_name
And I added "host_name" to sysservers table using "sp_addserver". Didn't work.
It seems that I have to install another SYBASE on my "host_name".
Thanks a lot!
-Judy
----- End Included Message -----
This archive was generated by hypermail 2.1.2 : Fri Sep 28 2001 - 23:11:06 CDT