Re: Is anyone doing replication on 7.3.4?

From: <CHUCK_HAMILTON_at_qvc.com>
Date: Mon, 22 May 2000 12:07:31 -0400
Message-Id: <10505.106244@fatcity.com>

My experience with replication was a couple of years ago with snapshots and I wouldn't use it again. There were too many problems trying to keep the snapshots in sync. Fast refresh snapshots were constantly getting out of sync and thinking they needed a full refresh when such was not the case. If I were doing it now, I'd create a standby database and open it in read only mode. When you want to refresh it, put it back into recovery mode to sync it with production, then put it back in read only mode.

As a side note, one of my colleagues recently went to a class that included replication and the they (instructor included) were never able to get the database to replicate properly even in a classroom setting. Doesn't sound like it works any better now than 3 years ago when I tried it.
--

Chuck Hamilton
QVC Inc.
Enterprise Technical Services
Oracle DBA

                                                                                                                   
                    "Smith, Ron                                                                                    
                    L."                  To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>       
                    <rlsmith_at_kmg.        cc:     (bcc: CHUCK HAMILTON/QVC)                                         
                    com>                 Subject:     Is anyone doing replication on 7.3.4?                        
                    Ext: NA                                                                                        
                    Sent by:                                                                                       
                    root_at_fatcity.                                                                                  
                    com                                                                                            
                                                                                                                   
                                                                                                                   
                    05/22/00                                                                                       
                    09:58 AM                                                                                       
                    Please                                                                                         
                    respond to                                                                                     
                    ORACLE-L

I have been asked to look into creating a read only replicated database for reporting purposes. Can anyone tell me if they have done this? I am interested if there is a performance hit when replication is implemented. How much time should I expect to dedicate to replication on a fairly large online production system? Is the replication software free? Has anyone used Quest's Shareplex?

Thanks!
Ron Smith
Database Administration
rlsmith_at_kmg.com

--

Author: Smith, Ron L.
INET: rlsmith_at_kmg.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon May 22 2000 - 11:07:31 CDT