Re: Q: farsync questions

From: Nassyam Basha <nassyambasha_at_gmail.com>
Date: Tue, 14 Oct 2014 19:17:45 +0530
Message-ID: <CAABGLu+kzEn8u3W9cQr6JaHjgOeADbP2AF2d=Xp2j0Ji74O8YQ_at_mail.gmail.com>

I Would like to know what is the protection mode you have configured? When you say crash its simulated or on its own?

> After that , I've renamed the directory contains the primary db datafiles
and redolog (simluate database loss)
you mean to say directory changed something like this? From: /u01/app/oradata/prod/*.dbf to /u01/app/oradata/prod_new/*.dbf ? Please explain this part more.

> When starting the FS instance , i got errors in the alert log of the FS
complaining it doesn't find the redologs of the primary !! . Have you upated DB_FILE_NAME_CONVERT/LOG_FILE_NAME_CONVERT after the renaming directories?

On Tue, Oct 14, 2014 at 2:49 PM, amihay gonen <agonenil_at_gmail.com> wrote:

> Hi all , I've started playing with farsync to learn better how it work.
>
> I've setup primary and farsync on the same instance (I know it is not best
> practice , but for learning propuse). I've create a standby on another
> machine and verified everything is working as expected.
>
> Then I've stop the standby (simluate network outage) , put some data in
> primary db + commit (no switch log ) and crash both primary db and farsync
> instance (in this order).
> After that , I've renamed the directory contains the primary db datafiles
> and redolog (simluate database loss)
>
> When starting the FS instance , i got errors in the alert log of the FS
> complaining it doesn't find the redologs of the primary !! .
>
> Any idea why ? it seems the FS read the primary redo log to complete
> recovery? this is strange to me since it is sync transport
>
>

-- 
Nassyam Basha.
Oracle DBA
*The Pythian Group * <http://www.pythian.com/>
11g OCP Certified, Blogger
Co-Author: Oracle Data Guard 11gR2
<http://www.amazon.in/Oracle-Guard-11gR2-Administration-Beginners/dp/1849687900>
Member of Oraworld-team <http://www.oraworld-team.com>

Visit My Blog <http://www.oracle-ckpt.com>
Let's Connect - Linkedin Profile <http://in.linkedin.com/in/nassyambasha/>
My Twitter <https://twitter.com/nassyambasha>
My Facebook <https://www.facebook.com/nassyambasha>

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

Received on Tue Oct 14 2014 - 15:47:45 CEST