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

Quote:

---

Originally posted by pando
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.

---

What are you talking about? There was one set of files - PERIOD. Transportable tablespaces contains DD info, however I never transported the files themselves just the dd info left them where they are, let it point to the original file locations.

No duplication of data - PERIOD.

Jeez what a nutjob, Oracle even agreed it would work, were you there? Have you tried it and proven me wrong ?

Woops... This is very interesting. Very much new for me!

Well, what is your OS and oracle Version?

Any docs around you to share with us? Even in metalink?
Very much appreciated

Quote:

---

Originally posted by Thomasps
Woops... This is very interesting. Very much new for me!

Well, what is your OS and oracle Version?

Any docs around you to share with us? Even in metalink?
Very much appreciated

---

I recommended RAC but the CEO also wanted a cheap option. I was suggesting that it could be done by having 2 instances pointing to the same datafiles if they dont need to write to them. Read-only. The network guy insisted it would not work without the expensive shared disk cabinet and special Oracle software ( RAC or OPS ). I talked to Oracle about getting instance #2 to see the same datafiles by importing their tablespace DD info via Transportable Tablespaces and they said it should work. We were on Sun and Windows, to quickly illustrate my point without the shared disk cabinet I setup 2 instances on one Windows machine and loaded the DD info into instance #2 for the SAME un-moved un-copied read-only tablespace datafiles.

One set of datafiles, 2 instances READ-ONLY. Both instances up and both querying the tablespace fine.

I recommended RAC because its would be supported by Oracle and because they quite often asked me to go back to the already loaded months of data and change certain values across the board. In the cheap method that would be awkward. Again this was just to demonstrate that it could be done, I never took it any further but found it interesting.

Eventually they could not afford RAC and started talking about not paying Oracle for the Partitioning I had been using so I quit and took a contract elsewhere.

ok I make a pardon but since in your previous posts you didnt say you only imported the metadata I thought you was moving the datafiles as well

Oracle says it should work but do they support this configuration if there are corruptions?

Quote:

---

Originally posted by pando
ok I make a pardon but since in your previous posts you didnt say you only imported the metadata I thought you was moving the datafiles as well

Oracle says it should work but do they support this configuration if there are corruptions?

---

I doubt they would offer much help. What I really wanted was RAC experience, but the CEO wanted to know why it was so expensive, wanted to see me come up with some alternative.

When I brought the Oracle sales/consultants in to discuss RAC they told us we had been using partitioning without paying for it ( I did not know this ), that only aggravated the situation. No way could they afford RAC.

Is there a way for me to build a simple RAC in my basement lab with all my computers? Is there any shared disk that is 'inexpensive' at the low end that is suitable for this ? I am not even sure if I can get my hands on the correct Oracle software without 'purchasing' the RAC option. thx.