Question about export/inport

[David E. Filip]

Greetings,

Although this is probably a simple question, I'm not sure start and am looking
for pointers.

Although my experience is mostly with Oracle, I am working at a client who
has an Informix database (7.3). I am helping them add redundancy and
fail-over. The database is small (<50 MB) and reasonably static (some changes
every day, although through administrative changes, not user initiated).

What I want to do is periodically (perhaps nightly, or maybe several times
during the day) export the contents of the "master" database, and restore
that database on a "backup" database. The intent is that if the master
database ever crashes, we can easily point the application to use the
backup database.

My question is how do I export / import on Informix 7.3 IDS?

Would I use some syntax of the onbar, which looks like it wants to
write to tape? Or is there some other utility that I should be looking at?

Sorry for the newbie question, but I haven't had much experience with
Informix, and am looking for the right place to start. With Oracle, I
have written scripts that export / FTP / import automatically, when faced
with similar environments.

Thanks,

Dave.

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
= David E. Filip | Email: dfi...@colornet.com =
= ColorNet Information Systems | WWW : http://www.colornet.com =
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

[mos...@wellsfargo.com]

That is exactly what High-availability Data Replication (HDR) was made for!!
RTFineM about it, in the System Admin Guide. HDR works great for this, with
very little admin effort. If you don't have a hard-copy of the manual,
check out http://www.informix.com/answers. If you have questions after you
read up on it, let me know and I'll try to help out...

HTH,
Paul Mosser

[chris]

hi,
are "master" and "backup" on the same maschine?
if not, easiest way is to do an "ontape" to a file, ftp to the "backup" maschine
and overwrite its database with ontape
that's only ONE possiblity (dbexport/import, datareplication... )
chris

[Sally Woolrich]

On Fri, 1 Sep 2000 06:19:36 +0100 , chris <cw...@mayn.de> wrote:

>hi,
>are "master" and "backup" on the same maschine?
>if not, easiest way is to do an "ontape" to a file, ftp to the "backup" maschine
>and overwrite its database with ontape
>that's only ONE possiblity (dbexport/import, datareplication... )
>chris

However you will have to set up the db on the second machine so that
all the symbolic names of the dbspaces & chunks are identical and they
are at least as large as on the source machine.

[Robert Stuart]

If it's really that small, and there's negligible user input ...
can you not mirror the databases?

I remember doing that about three/four years ago between London and Leeds
using online - but have no access to the appropriate manuals now, so can not
give you the syntax. * Art or Jonathan, help here *

You still need tape backups for security

"Sally Woolrich" <sally.w...@comino.com> wrote in message
news:39af7298.235070303@comino-leeds...

[Tony Flaherty]

Sally's right, as you say your database is only 50Mb then I'd opt for
dbimport.

So Sally, still at Excelsis?

Tony Flaherty,
Snr A/P, DBA, Unix Admin, GDB
Misys Financial Systems

Sally Woolrich wrote in message <39af7298.235070303@comino-leeds>...

[alan...@planmatics.com]

In article <8oml66$j8j$1...@hudson.dti.net>,

You might want to look at HDR (High Availability Data Replication).
Chapters 25-26 (??) in the Informix Administrators Guide. Much better
than similar replication (or "standy") setups in Oracle.

A.J.Andrews

Sent via Deja.com http://www.deja.com/
Before you buy.