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 14:17:23 -0800
Message-ID: <1167776243.576075.44370@s34g2000cwa.googlegroups.com>


Ok, so editorializing aside.. The standby database will be able to be updated regularly with the archives from the primary database, and will still be able to be read by applications without interruption, correct?

You say "evidently this will go wrong".. Other than the fact that I'm here asking questions on a high level and you're aware that I'm not an Oracle expert, constructively, what is it that you're forseeing as far as this is concerned? If the same procedure is followed each time, how exactly is this going to fail, other than obvious issues of operator error?

Sorry.. Sometimes when you're in a small organization, you've got to wear a few hats, and we're not all experts in everything. If I had the power or ability to hire an expert in the matter, I would, unforunately that is not an option.

sybrandb 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
>
> The read only database would need to be a standby/dataguard database
> opened in read only mode.
> As there is no RFS process, you would need to register the new archives
> manually, and recover them manually.
> Evidently this procedure *will* go wrong sooner or later, and the
> higher powers will question why such an amateur approach was
> implemented at all.
> Hopefully you aren't hit when those powers start to blame and fire
> people.
>
> --
> Sybrand Bakker
> Senior Oracle DBA
Received on Tue Jan 02 2007 - 16:17:23 CST

Original text of this message

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