Re: logical standby database

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Mon, 28 Jan 2013 20:39:40 +0000
Message-ID: <CABe10sY3KEmMBp7+pt6_6dAXiewppSsngSG-rDfFf+HJdrJatw_at_mail.gmail.com>

Well I was tempted to say "By fixing the errors that you have", but whilst satisfying (I've had a hard month or so) this isn't very helpful, so I'll point you at
http://docs.oracle.com/cd/B19306_01/server.102/b14239/manage_ls.htm#CHDEFEFCfor the minimum level of database views that is likely to be helpful, and suggest that if you have problems with a specific scenario perhaps supplying the necessary details to aid our understanding would help - for this purpose some clue as to the table structure, any capture rules and so on would be helpful.

On Mon, Jan 28, 2013 at 8:30 PM, David Fitzjarrell <oratune_at_yahoo.com>wrote:

> You should check the log_archive_dest_state_X (where X is a number between
> 1 and 31, at least on 11.2, and corresponds to the log_archive_dest
> parameter you set to communicate with your standby server) to see if it's
> been defered; it may be as simple as
>
> alter system set log_archive_dest_state_X enable;
>
> then check to see if logs are being received and applied. Also it may be
> that you haven't started the log apply process on the standby database;
> this, too, is an eaxy fix (presuming there are no errors that killed the
> processe):
>
> alter database start logical standby apply;
>
> Check these areas and if you still cannot get logs transferred and applied
> give us more details on the situation so we can better assist you.
>
> David Fitzjarrell
>
>
> ________________________________
> From: Joseph David Paparo <jpaparo_at_uark.edu>
> To: "oracle-l_at_freelists.org" <oracle-l_at_freelists.org>
> Sent: Monday, January 28, 2013 1:08 PM
> Subject: logical standby database
>
> Hello,
> I recently created my first logical standby database. I have noticed that
> when I update a data from a table in the primary database, the data doesn't
> transfer over to the equivalent table on the logical standby database. Can
> anyone give me any tips as to how I can get the logical standby to refresh
> its data from the primary? Thanks.
>
> Joe
>
> --
> http://www.freelists.org/webpage/oracle-l
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info


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

Received on Mon Jan 28 2013 - 21:39:40 CET