Any way to use shared disk cabinet w/o RAC ?
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: Any way to use shared disk cabinet w/o RAC ?

  1. #1
    Join Date
    Jan 2003
    Location
    Denver
    Posts
    152

    Any way to use shared disk cabinet w/o RAC ?

    Is there anyway to take a half-step towards RAC or GRID by getting some components like shared disk now? The only way I can see using shared disk is

    OPS - replaced by Dataguard
    RAC - Too expensive for us right now
    3rd party - ?

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Not really sure what you are trying to do.

    Sure you can share disk between hosts.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    May 2001
    Posts
    73
    You can also use shared disk to setup failover at the OS level by setting up cluster Eg: Veritas Cluster.(Oracle will be installed on the shared disk and can be accessed from a single node. Incase the node goes down then failover happens and Database will be accessed from a second node)
    OCP 7.3,8.0,8i,9i

  4. #4
    Join Date
    Jan 2003
    Location
    Denver
    Posts
    152
    Originally posted by marist89
    Not really sure what you are trying to do.

    Sure you can share disk between hosts.
    I thought that if two oracle instances were going to hit the same datafiles ( rather than dividing the disk space ) you had to have parallel server or rac or grid to sort out the conflicts.

    Sorry if I am not making much sense here, I rotated off Oracle for sql server firefighting the last 3 months. Oracle is stable but they want me to move it to new platform and if I do that I want to build something interesting.

    I have already proven that a read-only ( except for new partition loads ) data warehouse needs nothing special to have 2 instances read the same datafiles, you just use transportable tablespaces to inform the instance that did not perform the data load.

    But this time its OLTP. Wondering if I have any options to share datafiles and not just the disk system in a read-write OLTP system.

    THANKS

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Two instances same set of datafiles without RAC, no way.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  6. #6
    Join Date
    Jan 2003
    Location
    Denver
    Posts
    152
    Originally posted by marist89
    Two instances same set of datafiles without RAC, no way.
    I thought so. But it does work for DW if you just need read-only tablespace, but then your sort of forced to make each new partition live in its own tablespace so its awkward for frequent updates which its seems like everyone now wants their DW updated realtime.

    Thanks rad_jen, I forgot about veritas, if its a lot cheaper than RAC then we could get underway with the shared disk and still have failover capacity.

  7. #7
    Join Date
    May 2001
    Posts
    73
    Yes, its lot cheaper than RAC.

    Hardware failover + Dataguard is the popular solution for the sites that can't afford RAC.
    OCP 7.3,8.0,8i,9i

  8. #8
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Originally posted by BJE_DBA
    I thought so. But it does work for DW if you just need read-only tablespace,
    Will you please show me some docs (in the net) explaing this functionality. ie two or more instances in a OS clustered environment working on the same database without OPS or RAC. Very much interesting.
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  9. #9
    Join Date
    Jan 2003
    Location
    Denver
    Posts
    152
    Thomasps,

    When I ran a terabyte Datawarehouse for qwest and one for AT&T I presented the 'poor mans' approach to management but recommended RAC.

    'Poor mans' allowed no updates. We loaded our DW monthly so 24 partions on all the tables for a 2 year window was nothing. We were going to daily processing so I looked into it and was comfortable with 712 partitions/tablespaces based on the type of queries we typically ran against it. The load automation would go like this, add a new partition in a new tablespace, bulk load it, index it, exchange it including indexes for all such fact and dim tables. Analyze it.

    Set tablespace to read-only

    Export the DD info as Transportable Tablespace, Import it into the 2nd machine.

    Query away....

  10. #10
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Originally posted by BJE_DBA

    Set tablespace to read-only

    Export the DD info as Transportable Tablespace, Import it into the 2nd machine.

    Query away....
    Boy, you know what is RAC or OPS?!?! That is not even close, you are not reading same datafiles, you are reading each database own datafiles!

    What you do is not even close, what you do is what we used to do since 2000 for DWH ETL processes.

Posting Permissions

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


Click Here to Expand Forum to Full Width