Re: replace logical exp-imp with transportable tablespace

From: tomi wijanto <restomi_w_at_yahoo.com>
Date: Mon, 25 Oct 2004 10:03:14 -0700 (PDT)
Message-ID: <20041025170314.55241.qmail@web52006.mail.yahoo.com>

Hi Carel, thanks for your other insight solution.

we are on oracle 9i. Unfortunately, we use the 2nd db for batch process (after the exp-imp).

regards,
tomi

• Carel-Jan Engel <cjpengel.dbalert_at_xs4all.nl> wrote:

> Tomi,
>
> What OS/version are you on? Do you need to make
> changes to the 2nd
> database? If not, you might consider Data Guard
> Physical Standby.
>
> It allows you to open the 2nd database read-only
> during the day. At night
> you put it in managed recovery mode, and it will
> resync. This can be done
> through sql-scripts/cron. After sync you put it in
> R/O mode again.
>
> Extra advantage: You have a standby datbase you can
> use in case of failure
> of the primary database.
>
> Regards, Carel-Jan
>
> ===
> If you think education is expensive, try ignorance.
> (Derek Bok)
> ===
>
>
>
> > Hi,
> >
> > We have 2 database that need to be in sync every
> > night, also 1 database for user transactions while
> > sync process is running.
> >
> > Current operation is using logical exp-imp and
> take
> > half hour to complete, no manual intervention
> here.
> > But because future space estimation is about 20
> times
> > more than current, it means at least exp-imp will
> run
> > in 10 hours, and this is untolerable.
> >
> > So i try to use transportable tablespace instead,
> but
> > i'm not sure if this can be done everytimes
> without
> > manual intervention (the main reason is because i
> must
> > drop existing tablespace in destination, how if it
> > failed??).
> >
> > additional info for current exp-imp process:
> > - Related tablespace in source db is set to read
> only
> > when exp-imp.
> > - Destination db is idle when exp-imp (no users
> > connect to it).
> >
> > Can transportable tablesplace replace logical
> exp-imp?
> > The main limitation is : no manual intervention
> > allowed (except space problem, of course).
> >
> > ps: i believe probably someone will suggest
> > replication instead of exp-imp. But, i'm sorry,
> > because i can't change anything related to
> application
> > (we use 3rd party vendor).
> >
> > regards,
> > tomi

---

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Oct 25 2004 - 11:58:57 CDT