Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Manual update / replication on a live database?

Re: Manual update / replication on a live database?

From: tcp100 <tcp277_at_yahoo.com>
Date: 2 Jan 2007 13:59:48 -0800
Message-ID: <1167775188.320425.214700@v33g2000cwv.googlegroups.com>


Unfortunately, no.

This is isolated for very strict legal reasons, which I can't really detail here.

Let's just say the site is operationally and physically isolated, so direct network connectivity is not an option.

Operations issues are not an issue, as we'll have people who are responsible for this procedure -- We just want to make sure that there's a way of doing it, and if so, we're doing it what amounts to the best way.

Would the redo / transaction log "replay" at the other site work, or is there a better way, without having to take down the databases?

Thanks again..

hpuxrac wrote:
> tcp100 wrote:
> > Pardon me if this is naive, but I'm not an expert on Oracle - and this
> > is why I'm coming to the group..
> >
> > I have a question about replicating data across non-connected
> > databases.. (both Oracle 10g)
> >
> > We have two databases - one is our "active" database that takes in
> > transactions, and the other is a read-only "copy" at a remote location.
> > We'd like to update this "copy" database three times a week, but
> > since this remote database is not WAN connected, it'd have to be via CD
> > or other manual file transfer.
> >
> > The single requirement, however, is that we can't take either database
> > down to extract the data (on the "active" side) or to upload the data
> > (on the "read only copy" side). Both databases need to be able to be
> > accessed uninterrupted during any such maintenance procedures.
> >
> > What would you folks say is the best practice for this? Our intent
> > right now is to take the transaction / redo log from the live database,
> > and simply transport it over via CD, and then 'recover' the database
> > from the redo log in live mode.. Is that feasible, and is there a
> > better way?
> >
> > Thanks in advance for any pointers or tips..
> >
> > -Chris
>
> What you are describing is "somewhat" feasible but the task of taking
> archive log copies onto cd then over to the other machine sounds like a
> potential operational nightmare.
>
> If your active database has much volume at all it sounds like something
> to avoid. Can you look at getting some kind of network connectivity
> for the remote location?
Received on Tue Jan 02 2007 - 15:59:48 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US