RE: Question re Data Guard Configuration

  • From: "William Wagman" <wjwagman@xxxxxxxxxxx>
  • To: "Mark Strickland" <strickland.mark@xxxxxxxxx>
  • Date: Tue, 19 Feb 2008 17:22:17 -0800

Mark,
 
Thank you, I would appreciate it very much.
 

Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman@xxxxxxxxxxx
(530) 754-6208 

 

________________________________

From: Mark Strickland [mailto:strickland.mark@xxxxxxxxx] 
Sent: Tuesday, February 19, 2008 4:38 PM
To: William Wagman
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Question re Data Guard Configuration


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: