Home > Default > Multiple Standby Database

Multiple Standby Database

November 30Hits:0
Advertisement
Hello Folks,
DB Version : 10.2.0.4
OS : Solaris 5.8
I am planning to configure 2nd standby database (Physical ) for one of the my production database.
Right now it's configured with 1 physical standby database. If any one has previous experience or any document link please update the forum.
Thanks for your time.

Answers

primary database parameter
*.fal_client=' '
*.fal_server=' '
standby database 1
*.fal_client='stby1'
*.fal_server='primary'
standby 2 parameter
*.fal_client='stby2'
*.fal_server='stby1','primary'
more that that we have to set log_archive_dest_n parameters correctly
and db_file_name_convert and log_file_name_convert parameters , if it is needed.
configuring listener.ora and tnsnames.ora files ....
i plan to post a documentation of creating and adding physical and logical standby databases in different hosts..
please wait this month end , i plan to post it in my blog
http://oracleinstance.blogspot.com
Edited by: Rajeshkumar Govindarajan on May 6, 2010 2:31 PM
Edited by: Rajeshkumar Govindarajan on May 6, 2010 2:36 PM

Read other 6 answers

Tags:

Related Articles

  • Multiple standby database about FAL_SERVER and FAL_CLIENT parameter in DGNovember 30

    Hi, I am little bit confused about FAL_SERVER and FAL_CLIENT parameter in Data Guard. We are planning to configure multiple standby database in Data Guard environment. Let Assume that, i have production db named as 'PROD' and multiple standby name li

  • Multiple Standby Databases on same RAC nodes.November 30

    We have a 3 node Oracle 10gR2 RAC production environment on site A and a 3 node Oracle 10g RAC standby environment on site B. Both use like HW and OS - HP BL45p with RHEL AS 4.x. Can we have heterogeneous standby databases(logical and physical) runni

  • Create multiple standby databases of primary databaseNovember 30

    Hi, I have to create 2 standby databases of a single primary database, where can i get the stpe for the same? Thanksuser10745179 wrote: What about FAL_CLIENT parameters in primary? how to set the values of the above parameter in priamry for second st

  • Multiple Standby DatabaseNovember 30

    Hello Folks, DB Version : 10.2.0.4 OS : Solaris 5.8 I am planning to configure 2nd standby database (Physical ) for one of the my production database. Right now it's configured with 1 physical standby database. If any one has previous experience or a

  • Create Multilevel Standby databaseNovember 30

    HI All, We have a 10.2.0.2 primary database with a physical standby database. We would like to create 2 more physical standby databases for the same primary but, we dont want to have the logs shipping from primary database as it is prod. Is there any

  • Error while trying to open physical standby database - (DATA GUARD)October 11

    Hi Everyone, I have problems in opening the database of the physical standby in read- write mode/ read only mode. I have a primary server which is running on 2 node RAC and the standby on a seperate single server being used as DR. I recently got this

  • How to setup a Multi-instance standby database?October 11

    I was asked to setup a multi-instance standby database for a multi-instance primary database. I understand that only one of the instance will apply redo logs from the primary database, but how about the other instance? Should I mount that instance ju

  • JDBC URL to connect to Standby DatabaseOctober 11

    Could somebody please post the details of configuring a JDBC String in an app server (JBOSS) to connect to Standby database.Hi, The type, multiplicity or redundancy of the datasource connection pool can be independent of your JPA application beyond c

  • Logical standby database keeps displaying ORA-16768November 30

    I have a logical standby database setup on a remote host to accept cascaded logs from a physical standby. Everything was working fine until yesterday when I get the above error and log apply services stopped. When I go into Grid Control to Data Guard

  • Standby database with different directory structureNovember 30

    Hi, sorry to say that we are in desupported version due to some constraint. oracle version : 8.1.7.0.0. os:sun 5.9 I need to create physical standby database with different directory structure: i have created standby database with same directory stru

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.541 s.