Re: Question re Data Guard Configuration

  • From: "Mark Strickland" <strickland.mark@xxxxxxxxx>
  • To: wjwagman@xxxxxxxxxxx
  • Date: Tue, 19 Feb 2008 16:38:23 -0800

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@xxxxxxxxxxx> 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@xxxxxxxxxxx
> (530) 754-6208
> --
> //www.freelists.org/webpage/oracle-l
>
>
>

Other related posts: