Guenadi N Jilevski's Oracle BLOG

Oracle RAC, DG, EBS, DR and HA DBA BLOG

Data Guard Broker Improvements in Oracle 10g

Data Guard Broker Improvements in Oracle 10g

The Oracle 10g Data Guard also has its share of improvements, including the following, which are discussed in more detail next:

  • Broker support for RAC databases
  • Enhancements to the 10g Enterprise Manager Data Guard GUI
  • New Data Guard Broker commands

Broker Support for RAC Databases

If you use the GUI interface to create a standby from a RAC database, the standby will be created as a single-instance database.

Starting in 10g, the Data Guard Broker has added support for a RAC database environment. This means that DBAs who run a RAC environment can now configure and support Data Guard configurations using the Broker GUI or the command-line interface. You can use the same Broker commands and GUI pages you used for a single instance, now for a RAC instance. It is important to understand, however, that the Broker only supports sending redo to one instance of the standby database. The standby database can be either a single instance or a RAC-enabled instance, but in either case, only one instance would act as the receiving instance and apply the redo information. It would be convenient to have a standby RAC database apply redo information in case of standby instance failure. If the receiving instance fails, the Broker automatically detects the failure, selects a new receiving instance on the RAC standby, redirects redo shipment to the new receiving instance, and starts log apply on the instance. Just as in prior releases, to perform any switchover with a RAC database in place, all instances except one must be shut down. Because Data Guard and RAC are integrated, however, the Broker will invoke the shutdown commands and perform all necessary work for the switchover.

Enhancements to the Enterprise Manager Data Guard GUI

The 10g Enterprise Manager has updated the interface for the Data Guard Broker GUI. From the Data Guard home page, shown in Figure 16.2, you can now see an overview of the configuration, a summary of the amount of data shipping and applied to each standby, and the status of the standby databases. As a result, DBAs can now easily manage the Data Guard environment.

Figure 16.2. The Data Guard home page via 10g EM Grid Control.


 

The Performance Overview page, which you access by clicking the Performance Overview link in the Performance section of the Data Guard home page, consists of four new charts:

  • Data Archived (MB). This chart indicates the amount of redo generated on the primary over time.
  • Standby Progress Summary. This chart includes Data Not Applied and Data Not Received statistics.
  • Data Applied. This chart conveys the amount of redo being applied on each standby over time.
  • Log Services Summary. This chart includes detailed information about the current log file being used by each database.

This page, shown in Figure 16.3, is monitored in real-time, manually or automatically (every 30 or 60 seconds). There is no difference in the appearance if the databases are RAC or single-instance. If the primary database is a RAC database, each chart will aggregate the information across all necessary threads.

Figure 16.3. The 10g Data Guard Performance Overview page.


 

Also new in 10g Enterprise Manager is the Add Standby Database wizard, which you access by clicking the Add Standby Database button in the Standby Databases section of the Data Guard home page. Using the Add Standby Database wizard enables individuals who previously did not have an advanced understanding of Data Guard to quickly and easily build and run standby databases in any environment.

Building a standby database with the Standby Database Creation Wizard is as easy as providing a few bits of information about your configuration. Figure 16.4 displays the first screen of the Add Standby Database wizard.

Figure 16.4. The new 10g Standby Database Creation wizard.

[View full size image]



 

To use the new 10g Standby Database Creation wizard to build your new standby environment, your primary database must be in archive log mode. If it is not, you will receive an error message about the NOARCHIVELOG MODE status.

When you use the wizard to build a new standby database, the wizard will first display a window to allow you to choose your backup method. Because a hot or cold backup is needed to begin the process, Data Guard Manager utilizes RMAN to perform this backup process (see Figure 16.5). You may also receive a warning at this point if your database is not in force-logging mode. Force logging is not required, but Oracle recommends that your primary database be placed in force-logging mode to ensure that no no-logging operations can be executed at the primary.

Figure 16.5. Choosing a backup method for the 10g Standby Database Creation wizard.


 

Next, as shown in Figure 16.6, the wizard will prompt you for a working directory and the user admin credentials of the Oracle Home owner. The working directory will be used to house the primary database backup files during the standby build process. You can also choose to delete or retain the working directory for future builds.

Figure 16.6. Providing the backup options for the 10g Standby Database Creation wizard.


 

The wizard’s third step, shown in Figure 16.7, prompts you for the standby instance name as well as the user admin credentials over the standby Oracle Home. In this example we used the same Oracle Home for the primary and standby; note, however, that the primary and standby Oracle Homes could have different user admin credentials.

Figure 16.7. Providing the necessary instance name and host credentials for the 10g Standby Database Creation wizard.

]


 

Next, the wizard verifies the standby file locations as well as the network configuration file location, as shown in Figure 16.8. Because our sample standby database uses the same host as the primary, Data Guard Manager automatically uses the OFA (Oracle Flexible Architecture) file structure.

Figure 16.8. Verifying the standby database and network file locations for the 10g Standby Database Creation wizard.


 

The next screen, shown in Figure 16.9, prompts you for the specific information about your standby configuration. Here you will need your database unique name, target name, and standby archive location.

Figure 16.9. Configuring the new standby database using the 10g Standby Database Creation wizard.



 

Possible Error with Standby Filenames

When using the wizard to build your logical or physical standby database, it is possible that you may run into bug 3655231 if you are using Version 10.1.0.3 or below. If you receive the Can’t find unicode character property definition via main->r or r.pl at unicode/Is/r.pl line 0 error message during your standby build you have hit this bug. The workaround is to remove any standby data file and/or log file names that contain \p. If this exists, either rename the directory or choose a different directory to house the files. Then, rename the files accordingly using the Customize button in the screen shown in Figure 16.8. You could also avoid this issue by applying the 10.1.0.4 patch set or oneoff patch 4039195 to version 10.1.0.2.

 

Finally, the wizard displays a summary of your standby build options, as shown in Figure 16.10. Review your choices. If any are incorrect, click the Back button repeatedly until you reach the relevant screen to correct them. When you’re satisfied with your selections, click the Finish button.

Figure 16.10. Overall summary for new target standby database using the 10g Standby Database Creation wizard.


 

Data Guard Manager proceeds with the build by creating your configuration (see Figure 16.11), preparing and submitting the build job (see Figure 16.12), and adding your standby target to Enterprise Manager Grid Control (see Figure 16.13).

Figure 16.11. Process screen showing the creation of the new standby database environment.



 

Figure 16.12. Process screen showing the necessary jobs submitted to build the new standby database.

[View full size image]



 

Figure 16.13. Process screen showing the necessary jobs submitted to build the new standby database.

[View full size image]


 

When the target is complete, Enterprise Manager redirects you to the Data Guard home page so you can monitor the standby database build (see Figure 16.14).

Figure 16.14. The 10g Data Guard home page showing the new standby database in process.



 

New 10g Broker Commands

With Oracle 10g, most DGMGRL commands have changed. Many have been improved with simplified meanings; others are just brand new due to the changes with the 10g Data Guard Broker configuration model. Following are the more notable changes with the 10g Broker command line syntax.

CREATE CONFIGURATION

One command that has become highly simplified with 10g is the CREATE CONFIGURATION command. In previous releases, the CREATE CONFIGURATION command was highly complex; with 10g, however, all you need to supply is three arguments to create your new configurationconfiguration name, database name, and connect identifieras shown here:

DGMGRL> create configuration ‘DR_CONFIG’ as primary database is ‘PROD’

connect identifier is ‘RAC_PROD’;

  • The configuration name is a name you provide for the Broker configuration. The name, like most names in Oracle, must be made up of alphanumeric characters and can only consist of 30 characters. The preceding example shows DR_CONFIG as the configuration name.
  • The database name is the name that will be used by the Broker to refer to the primary database object. The name must match that value of the corresponding database DB_UNIQUE_NAME parameter. In the preceding example, PROD is the database name.
  • The connect identifier can be a fully specified connect descriptor or name that is reprehensive in an Oracle Net environment (a tnsnames.ora enTRy) to the primary database. In a RAC environment, you must make sure your connect identifier can be used to address at least one instance of the primary database. In the preceding example, RAC_PROD is the connect identifier.

When your configuration is set, you can then use the new ADD DATABASE command to add standby databases to the configuration.

ADD DATABASE

This new Broker command is used to add databases to a configuration. The database name is the DB_UNIQUE_NAME of the standby and the connect identifier must resolve to the standby database. The type of standby (physical or logical) can be interchangeable with this command.

DGMGRL> add database ‘DRPROD’ as connect identifier is ‘RAC_DRPROD’ maintained as physical;


 

REMOVE DATABASE

The REMOVE DATABASE command is used to remove a standby database from your configuration. The database name is the DB_QUIQUE_NAME of the standby you want removed.

DGMGRL> remove database ‘DRPROD’;


 

DISABLE DATABASE (Replaces DISABLE_RESOURCE)

The DISABLE DATABASE command is used to disable Broker management of a standby database within a configuration. This means that all Broker-directed modifications will be ignored for this specific standby database. Also, the Broker will no longer monitor the specified database for health-status checks. The database name is the DB_UNIQUE_NAME of the standby you want to disable.

DGMGRL> disable database ‘DRPROD’;


 

ENABLE DATABASE (Replaces ENABLE_RESOURCE)

The ENABLE DATABASE command is used to restore Broker management of a standby database that was previously disabled. The database name is the DB_UNIQUE_NAME of the standby you want to disable.

DGMGRL> enable database ‘DRPROD’;


 

EDIT DATABASE (Replaces ALTER_RESOURCE)

The EDIT DATABASE command is used to set a new property value to your specified database, rename your database, or modify the state of the database. The database name is the DB_UNIQUE_NAME of the standby you want to disable.

DGMGRL> edit database ‘DRPROD’ set property ‘logarchivetrace’=’127’;

DGMGRL> edit database ‘DRPROD’ set state=’read-only’;

DGMGRL> edit database ‘DRPROD’ rename to ‘DRPROD_STDBY’;


 

EDIT CONFIGURATION (Replaces ALTER_CONFIGURATION)

The EDIT CONFIGURATION command is used to modify the current protection mode setting for a predefined configuration.

DGMGRL> edit configuration set protection mode as maxprotection;

Valid protection modes for a configuration are MAXPROTECTION, MAXAVAILABILITY, and MAXPERFORMANCE. The default is MAXPERFORMANCE.

EDIT INSTANCE

The EDIT INSTANCE command is used to modify the value of a property for a specified instance. For these commands, if your instance name is unique across the configuration, then the database name is not required.

DGMGRL> edit instance ‘DRPROD_N1’ on database ‘DRPROD’ set property lsbymaxservers = ‘4’;

Properties that can be modified with the EDIT INSTANCE command include the following:

  • StandbyArchiveLocation. Location of archived redo logs arriving from a primary database.
  • AlternateLocation. Alternate location to be used if the standby can no longer archive to StandbyArchiveLocation.
  • LogArchiveTrace. Integer value to denote the progression of the archiving of redo logs on the primary and standby databases.
  • LogArchiveFormat. Format for filenames of archived redo log files.
  • LsbyMaxSga. Number of megabytes allocated from the System Global Area (SGA) for the log apply services cache. The default value is one quarter (1/4) of the value set for SHARED_POOL_SIZE parameter.
  • LsbyMaxServers. Number of parallel query servers specifically reserved for log apply services.

FAILOVER

The new FAILOVER command specifies that a standby database will take on the role of a primary database.

DGMGRL> failover to DRPROD_STDBY;

If the Data Guard Broker configuration is in Maximum Protection or Maximum Availability mode, a failover will force the protection mode to be MAXIMUM PERFORMANCE. After the failover has occurred, the DBA can change this mode if needed.

SHOW

The new SHOW command displays the current settings of your configuration model. The SHOW command can be used at the configuration, database, or instance level.

DGMGRL> show configuration;

DGMGRL> show database ‘DRPROD’;

DGMGRL> show instance ‘RAC_DRPROD’;


 

SWITCHOVER

The new SWITCHOVER command performs a switchover operation to the database object corresponding to the named site.

DGMGRL> switchover to DRPROD_STDBY;

March 6, 2010 - Posted by | oracle

23 Comments »

  1. Hi,
    Sir i have succesfully implemented dguard as u ave shown with rman i followed the steps and got implemented ……..but sir can u help me with this

    iam trying to configure 2 standby databases my primary database name is anupp1 and standby database name is anups1 and anups2 respectively (physical standby databases)when i configured means archiving is received at both databases but when i switchover at that time archiving is received at only one database

    my primary database is anupp1 and standby databases are anups1 ,anups2

    now when i perform switchover at that time ie primary is anups1 and standby are anupp1 and anups2

    so archive log are nnoy shipped on anups2 they are on anupp1 iam posting the contents of all the pfiles

    pfile of anupp1

    db_unique_name=’anupp1′
    log_archive_dest_1=’LOCATION=/u01/app/oracle/oradata/anupp1/arch/
    VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
    db_unique_name=anupp1′
    log_archive_dest_2=’SERVICE=anups1 LGWR ASYNC
    VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
    db_unique_name=anups1′
    log_archive_dest_3=’SERVICE=anups2 LGWR ASYNC
    VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
    db_unique_name=anups2′
    log_archive_dest_state_1=enable
    log_archive_dest_state_2=enable
    log_archive_dest_state_3=enable
    fal_server=anups1
    fal_client=anupp1

    pfile of anups1

    db_unique_name=’anups1′
    log_archive_dest_1=’LOCATION=/u01/app/oracle/oradata/anups1/arch/
    VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
    db_unique_name=anups1′
    log_archive_dest_2=’SERVICE=anupp1 LGWR ASYNC
    VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
    db_unique_name=anupp1′
    log_archive_dest_state_1=enable
    log_archive_dest_state_2=enable
    fal_server=anupp1
    fal_client=anups1
    log_file_name_convert=’/u01/app/oracle/oradata/anupp1/’,’/u01/app/oracle/oradata/anups1/’
    db_file_name_convert=’/u01/app/oracle/oradata/anupp1/’,’/u01/app/oracle/oradata/anups1/’

    pfile of anups2

    db_unique_name=’anups2′
    log_archive_dest_1=’LOCATION=/u01/app/oracle/oradata/anups2/arch/
    VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
    db_unique_name=anups2′
    log_archive_dest_2=’SERVICE=anupp1 LGWR ASYNC
    VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
    db_unique_name=anupp1′
    log_archive_dest_state_1=enable
    log_archive_dest_state_2=enable
    log_file_name_convert=’/u01/app/oracle/oradata/anupp1/’,’/u01/app/oracle/oradata/anups2/’
    db_file_name_convert=’/u01/app/oracle/oradata/anupp1/’,’/u01/app/oracle/oradata/anups2/’

    so above are the contents …… pls let me know which parameter is not set correctly or what modifications i need to do

    Thanks in Advance
    Regards
    Kavita

    Comment by kavita | June 20, 2011 | Reply

    • Hi,

      Are those pfile files before or after the switch? See that only anupp1 can ship to other remote destinations. Why do not add remote destinations to other pfiles? You can verify it trough the alert.log of the new primary anups1.

      Regards,

      Comment by gjilevski | June 20, 2011 | Reply

    • Hi,

      Modify each spfile to include the other 2 destinations for role transition.

      Regards,

      Comment by gjilevski | June 20, 2011 | Reply

  2. Hi,
    sir i apologize for later reply …….but yesterday i solved it ………yes sir i included log_Archive_dest_3 in pfile of anups1 as well as configure the networking on anups1 for anups2 so now it is shipping the archive logs

    Thanks Sir for your response

    Best Regards
    Kavita

    Comment by kavita | June 21, 2011 | Reply

    • Hi,

      I am glad that you solved it.

      Regards,

      Comment by gjilevski | June 21, 2011 | Reply

  3. Hi,
    Sir i just want to ask u if i need to implement dataguard with asm so is there any post on your blog

    Thanks in Advance

    Best Regards
    Kavita

    Comment by kavita | June 21, 2011 | Reply

  4. Hi,
    Sir thanks for your responses ………Sir i was going through your article this is with in respect to rac
    i have some queries related to it if i implement above will it work if iam using 10gr2 version and my operating system is OLE5.5 Sir even i have oracle Sun solaris 10 so i jsut wanted to ask u if i wanted to implement rac so which o/s should i go for and my database is 10gr2

    Thanks in Advance 🙂

    Best Regards
    Kavita

    Comment by kavita | June 21, 2011 | Reply

  5. Hi,
    Sir by the following link https://gjilevski.wordpress.com/2010/03/page/2/
    I have successfully created the standby through rman but when iam again doing it iam facing the above related error

    rman target=sys/sys123@chicago auxiliary=/

    connected to target database: CHICAGO (DBID=1364296147)
    connected to auxiliary database (not started)

    RMAN> duplicate target database for standby nofilenamecheck ;

    Starting Duplicate Db at 26-JUL-11
    using target database control file instead of recovery catalog
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of Duplicate Db command at 07/26/2011 00:35:03
    RMAN-06403: could not obtain a fully authorized session
    RMAN-04006: error from auxiliary database: ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist
    Linux Error: 2: No such file or directory

    then i export my sid and try
    ie
    ORACLE_SID=boston
    export ORACLE_SID=boston

    [oracle@oracle ~]$ rman target=sys/sys123@chicago auxiliary=/

    Recovery Manager: Release 10.2.0.1.0 – Production on Tue Jul 26 00:35:35 2011

    Copyright (c) 1982, 2005, Oracle. All rights reserved.

    connected to target database: CHICAGO (DBID=1364296147)
    connected to auxiliary database: CHICAGO (not mounted)

    after setting this iam getting connected to primary database instead of standby

    Thanks in Advance
    Regards
    Kavita

    Comment by kavita | June 25, 2011 | Reply

    • Hi,

      Pay attention to setting the

      ORACLE_SID=
      INSTANCE_NAME=
      DB_NAME=DNAME
      DB_UNIQUE_NAME=

      ORACLE_SID, DB_UNIQUE_NAME and instance_name spfile parameters should be unique on the primary and standby site.

      Also set the envirionment varuables on the standby site.

      Regards

      Comment by gjilevski | June 25, 2011 | Reply

  6. Hi ,
    Sir now after doing it thrice ie delteing and starting from scratch iam getting the above issue

    Recovery Manager complete.
    [oracle@oracle ~]$ ORACLE_SID=boston
    [oracle@oracle ~]$ export ORACLE_SID=boston
    [oracle@oracle ~]$ rman target=sys/krishna@chicago auxiliary /

    Recovery Manager: Release 10.2.0.1.0 – Production on Tue Jul 26 04:08:57 2011

    Copyright (c) 1982, 2005, Oracle. All rights reserved.

    connected to target database: CHICAGO (DBID=1364296147)
    connected to auxiliary database: CHICAGO (DBID=1364296147, not open)

    RMAN> duplicate target database for standby nofilenamecheck ;

    Starting Duplicate Db at 26-JUL-11
    using target database control file instead of recovery catalog
    allocated channel: ORA_AUX_DISK_1
    channel ORA_AUX_DISK_1: sid=156 devtype=DISK
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of Duplicate Db command at 07/26/2011 04:09:17
    RMAN-05500: the auxiliary database must be not mounted when issuing a DUPLICATE command

    Thanks &Regards
    Kavita

    Comment by kavita | June 25, 2011 | Reply

    • Hi,

      You have the error

      RMAN-05500: the auxiliary database must be not mounted when issuing a DUPLICATE command

      Start the auxiliary database with nomount and than run the rman duplicate command.

      Regards,

      Comment by gjilevski | June 25, 2011 | Reply

  7. Hi,
    Sir i was starting it all in nomount only but now i just deleted everything and created fresh database as sir in old i was not getting the result i would have done that much before but only i didnt because here it is fine as iam doing it for my studies but at my workplace i can’t do that so i was trying to do it but that is still unsolved iam doing but i know as something has gone wrong ……
    Sir but your article is perfect if done step by step i did before twice it worked and now also but in mid what is going wrong ……….

    Sir Its a request can u pls post some theory on rac archtiecture the conecpts OCFS ,voting disk , background process and the internal working and it ‘ s components

    thanks sir for your responses

    Best Regards
    Kavita

    Comment by kavita | June 26, 2011 | Reply

  8. I Sir iam following the above link

    http://kamranagayev.wordpress.com/2011/04/05/step-by-step-installing-oracle-10g-rac-on-vmware/

    installing orace rac on vmware so when istarted lot of issues has arised and solving them i used to to delete and create my machines several times
    so fianlly after trying 8 times i reached a step where oracle clusterware and orace software are getting installed successfully but as i said then i stuck where my asm was not mounting on sec node so with help of otn i have solved that and now sir at last step my database has created but when it exec for instances at time i got the issue iam sending u link
    http://imageshack.us/photo/my-images/703/rac1.png/

    iam posting the output of both nodes

    this is from first node

    [root@rac1 bin]# crs_stat -t
    Name Type Target State Host
    ora.devdb.db application ONLINE ONLINE rac2
    ora….b1.inst application ONLINE ONLINE rac1
    ora….b2.inst application ONLINE OFFLINE
    ora….SM1.asm application ONLINE ONLINE rac1
    ora….C1.lsnr application ONLINE ONLINE rac1
    ora.rac1.gsd application ONLINE ONLINE rac1
    ora.rac1.ons application ONLINE ONLINE rac1
    ora.rac1.vip application ONLINE ONLINE rac1
    ora….SM2.asm application ONLINE ONLINE rac2
    ora….C2.lsnr application ONLINE ONLINE rac2
    ora.rac2.gsd application ONLINE ONLINE rac2
    ora.rac2.ons application ONLINE ONLINE rac2
    ora.rac2.vip application ONLINE ONLINE rac2
    [root@rac1 bin]#

    from second node

    Name Type Target State Host
    ora.devdb.db application ONLINE ONLINE rac2
    ora….b1.inst application ONLINE ONLINE rac1
    ora….b2.inst application ONLINE OFFLINE
    ora….SM1.asm application ONLINE ONLINE rac1
    ora….C1.lsnr application ONLINE ONLINE rac1
    ora.rac1.gsd application ONLINE ONLINE rac1
    ora.rac1.ons application ONLINE ONLINE rac1
    ora.rac1.vip application ONLINE ONLINE rac1
    ora….SM2.asm application ONLINE ONLINE rac2
    ora….C2.lsnr application ONLINE ONLINE rac2
    ora.rac2.gsd application ONLINE ONLINE rac2
    ora.rac2.ons application ONLINE ONLINE rac2
    ora.rac2.vip application ONLINE ONLINE rac2
    [root@rac2 bin]#

    but before proceding everything was up but now when i checked at failure so the ora….b2.inst application i is offline at both the nodes Sir i stopped and started it several times please help me in resolving this ………….

    Thanks in Advance
    Regards
    Kavita

    Comment by kavita | July 7, 2011 | Reply

    • Hi,

      Please reffer to

      http://download.oracle.com/docs/cd/E11882_01/rac.112/e16794/cvu.htm#CJGCFFJG

      reboot the servers and run the chaecks to make sure that prerequisite are met

      cluvfy stage -post crsinst -n all ## CRS installation is OK

      cluvfy stage -pre dbinst -n all ## RDBMS prereqisites are OK

      cluvfy stage -pre dbcfg -n all -d $ORACLE_HOME ## prerequsites for DBCA are OK

      Fix any problems. Use -fixup option for suggestions.

      Make sure that resource are up ./crs_stat

      See if you can start that database. What are there errors?

      Regrtry dbca

      Regards,

      Comment by gjilevski | July 7, 2011 | Reply

    • Hi,

      Investigate

      1. Prerequisites use cluvfy
      2. If you can restart and why fails. ( check listeners, resource status with crs_stat )
      3. Drop database and restart dbca.

      Regards,

      Comment by gjilevski | July 7, 2011 | Reply

    • Him

      See if using sqlplus can start the instance, see if all tnsnames.ora parametes have local_listener and remote_listener parameters set up as well? Can you localte pfile/spfile from all nodes?

      Regards,

      Comment by gjilevski | July 7, 2011 | Reply

  9. i am quite following your blog its simple superb!!
    i had Setup DB Broker Configuration in our Company with 1 production and 2 standby Databases Successfully.
    i have done Fast Start Failover and Observer Configuration too with oracle version 10.2.0.1.

    Issue is after failover or Switch over Condition Standby automatically transfers as Production.But how application knows the new Production database and is there any automatic Configuration for doing this if our Database changes its roles to standby as production, application also should automatically redirects to new primary.

    i have gone through clienet failover setup but not able to understand.please suggest me as it is very important in our setup.
    Thanks in advance

    Comment by ravikishore | May 24, 2013 | Reply

    • Hi,

      Look at here http://prutser.files.wordpress.com/2008/12/client_connectivity.pdf for answers to your questions.

      Best Regards,

      Guenadi Jilevski

      Comment by gjilevski | May 30, 2013 | Reply

      • Hi,
        Greetings of the Day!
        Thanks for your Reply and it was really awesome Doc for Client Connectivity in Datagaurd Broker Setup.
        As i said my Configuration consists of 1 Primary with 2 Physical Standby Databases which are in Mount state(10.2.0.1).Can you please send me detailed Demonstration with scripts and examples to implement the above Stated Client Connection Setup to my mail id ravikishore4dba@gmail.com.

        Thanks in Advance!!

        Comment by ravikishore | May 31, 2013

      • Hi,

        I am trying to help you unerstabd the concepts so that you can tailor the solution to your case.

        Best Regards,

        Guenadi Jilevski

        Comment by gjilevski | May 31, 2013

  10. Thanks for your Valuable Support!!!
    You are doing Really an awesome Job in feeding us.Can you Please Send me the Demo scripts to my mailid ravikishore4dba@gmail.com so that i will to Implement Client Failover Setup.

    Comment by ravikishore | June 3, 2013 | Reply


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: