Re: cheapest way to setup replication using oracle

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.

Thanks again.

Yours Danny

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
> license.
>
> 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
>> baojiejie_at_gmail.com
>>
>>
>>
>

-- 

("'-''-/").___..--''"'-._
 '7_ 7  )   '_.  (     ).'-.__.')
 (_Y_.)   ._   )  '._ '. ''-..-'
_.'--'_..-_/  /--'_.' ,'
(il),-''  (li),'  ((!.-'

Best regards，
Yours sincerely House
baojiejie_at_gmail.com

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