DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Physical Standby on RAC to non-RAC standby

  1. 12-16-2005, 04:50 PM #1
    dbdude
    dbdude is offline Junior Member
    Join Date
    Nov 2005
    Posts
    7

    Physical Standby on RAC to non-RAC standby

    I was wondering if anyone has ever configure this setup or you thoughts on the opossibility.


    standby_type: physical

    primary database : RAC/with two nodes (instance1/instance2)

    standby database non-RAC with standalone database instance1
    Reply With Quote Reply With Quote
  2. 12-16-2005, 05:20 PM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    yes, i do it
    Reply With Quote Reply With Quote
  3. 10-26-2007, 11:21 AM #3
    kap_ravi
    kap_ravi is offline Junior Member
    Join Date
    Oct 2007
    Posts
    2

    Oracle 10g RAC to non-RAC Standby database Config

    Hi,

    Its great that you have done the configuration setting up a non-RAC standby database for a 2-node RAC. It is very interesting as Oracle has no documentation on this specific configuration. They always give the configuration with Data Guard, which comes only with the COSTLY enterprise edition.

    Can you kindly give us the outline of the activities in you have carried out to achieve the above configuration without using the Data Guard.

    Thanks a lot in advance

    Regards

    Ravi
    Reply With Quote Reply With Quote
  4. 10-26-2007, 11:25 AM #4
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    umm, it does use dataguard, that was the while point of the question - a standby database is dataguard
    Reply With Quote Reply With Quote
  5. 10-26-2007, 11:44 AM #5
    kap_ravi
    kap_ravi is offline Junior Member
    Join Date
    Oct 2007
    Posts
    2

    Rac 2 non-RAC standby Config

    humm...what a pity. As the word data guard was not found on the discussion, i thought that you have achieved it without using the data guard.

    any way thanks for the fast reply.

    Ravi
    Reply With Quote Reply With Quote
  6. 10-26-2007, 12:23 PM #6
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    well dataguard is enhanced standby, equals standby by enhanced log shipping so there is not really much different in this context
    Reply With Quote Reply With Quote
  7. 10-28-2007, 05:16 AM #7
    hrishy
    hrishy is offline Senior Advisor
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    I am not sure i am understanding your question

    But according to me what you are asking is not possible

    Code:
    primary database : RAC/with two nodes (instance1/instance2)

standby database non-RAC with standalone database instance1
    As Standby or dataguard needs the archived redologs from both instance1 as well as instance2 to become a standby

    so what you are asking should really be

    Code:
    primary database : RAC/with two nodes (instance1/instance2)

standby database non-RAC with standalone 
database instance1 and instance2
    And if above is what your looking for then Oracle's recommended HA strategy is Maximum Availability Architectutre which uses RAC and a dataguard.

    I am sorry if i have messed this thread up
    Reply With Quote Reply With Quote
  8. 10-28-2007, 06:04 AM #8
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    hrishy it is possible rac with a single instance standby/dataguard

    http://download.oracle.com/docs/cd/B...htm#sthref2196
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width