Re: Question re Data Guard Configuration

From: Mark Strickland <strickland.mark_at_gmail.com>
Date: Tue, 19 Feb 2008 16:38:23 -0800
Message-ID: <90ad14210802191638w7c5ec619j9da7c161f0c38120@mail.gmail.com>


Bill, I have a step-by-step document that I put together to setup and test a 4-way configuration. I can send it to you privately, if you'd like.

Mark
Qpass, Seattle

On Feb 19, 2008 3:09 PM, William Wagman <wjwagman_at_ucdavis.edu> wrote:

> Greetings,
>
> I am new to Data Guard and have a question concerning configuration. I
> am running Oracle EE 10.2.0.3.0 on RHEL4 and setting up a physical
> standby. I haven't been able to find a specific answer to this question
> in the documentation and hoping someone can help. In the primary I the
> following is set...
>
> SQL> show parameter name
>
> NAME TYPE VALUE
> ------------------------------------ -----------
> ------------------------------
> db_file_name_convert string /opt/oracle/edrs/,
> /opt/oracle
> /edrs/
> db_name string edrs
> db_unique_name string edrs
> global_names boolean FALSE
> instance_name string edrs
> lock_name_space string
> log_file_name_convert string /opt/oracle/edrs/,
> /opt/oracle
> /edrs/
> service_names string edrs
>
> I understand that on the standby server the db_unique_name must be
> unique but it is not clear to me whether the db_name,instance_name and
> service_names must also be unique. From some of the examples I have
> found it appears that the db_name and instance_name may be the same but
> I am not sure. I also don't find anything indicating that the
> service_names parameter must also be different on each node. It doesn't
> seem like it needs to be but I'm not sure. Any help appreciated.
>
> Thanks.
>
> Bill Wagman
> Univ. of California at Davis
> IET Campus Data Center
> wjwagman_at_ucdavis.edu
> (530) 754-6208
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Feb 19 2008 - 18:38:23 CST

Original text of this message