Re: cheapest way to setup replication using oracle
Date: Thu, 11 Mar 2010 10:37:12 -0800
thanks a lot Glenn.
I never setup that kind of "DATA Guard" before, I just ask you ,need I setup the slave DB in "managed recovery" mode manually and how to let it apply those logs from Master DB ? Also, those views like V$archived_logs are still helpful for monitoring the logs are applied or not ? I will try to setup the environment and begin test soon, but if you can give me some hint or some links about it , that will be very great! thanks a lot , I will also try to google it for solutions because I think it is much easier than using stream plus MV.
On Wed, Mar 10, 2010 at 5:29 PM, Glenn Stauffer <glennstauffer_at_gmail.com>wrote:
> You can setup a data guard-like environment using standard edition.
> Basically, you set up a copy in recovery mode and transport and apply the
> archive logs through scripts rather than any in-built Oracle features. This
> is a physical standby and you can't really activate the standby for
> reporting and the like - certainly that wouldn't be legal under your
> This does work; I've done it for years for a production system where the
> customer couldn't afford an enterprise edition license. I use rsync to get
> the archive logs to the standby machine since rman scripts that delete the
> archivelogs after backup keep the file system from running out of space or
> having to be 'managed' at the unix level. The apply script is pretty
> simple, but it is important to capture output and parse for errors related
> to a missing log. Otherwise, you can go out of sync and not catch it for
> weeks and depending upon your recovery window, that can lead to a lost
> archive file in which case you have to rebuild the standby instance.
> Glenn Stauffer
> Millport, PA
> On Wed, Mar 10, 2010 at 7:53 PM, bao jiejie <baojiejie_at_gmail.com> wrote:
>> Hi friend,
>> I am thinking about setup a cheapest replication solutions for Oracle dbs.
>> I am wondering if that is ok to setup DB replication using oracle standard
>> Edition ?
>> like stream plus MV ?
>> Or I have to apply for Enterprise Edition license so that it maybe easier
>> to replication via DG ?
>> Any advice for Oracle replication ?
>> Yeah, MySQL belongs to Oracle now and it has a quite easy way to setup
>> replication , but we are not talking about MySQL this time :)
>> '7_ 7 ) '_. ( ).'-.__.')
>> (_Y_.) ._ ) '._ '. ''-..-'
>> _.'--'_..-_/ /--'_.' ,'
>> (il),-'' (li),' ((!.-'
>> Best regards，
>> Yours sincerely House
-- ("'-''-/").___..--''"'-._ '7_ 7 ) '_. ( ).'-.__.') (_Y_.) ._ ) '._ '. ''-..-' _.'--'_..-_/ /--'_.' ,' (il),-'' (li),' ((!.-' Best regards， Yours sincerely House baojiejie_at_gmail.com -- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 11 2010 - 12:37:12 CST