ASM and to OMF or not to OMF
itbpjdpJan 6 2012 — edited Jan 10 2012Hi,
I am building a new test environment on oracle db 11g.
I want to consolidate all my test environments to 1 box.
Our test environment currently consists of 4 boxes and about 20 db's across 9i, 10.1 and 10.2 .
I did a multi home and multi inventory installation , 1 for every test env and one for ASM and one for our OEM agent.
Everything works fine.
But now I want to create db's in our 2 disk group (data and arch) ASM setup.
How do I create the db's as follows:
data\test_env1\datafiles\...
\temp\...
......
\test_env2\datafiles\
......
etc
I don't want to use aliases and see all 20 db's in the data root.
So how do I create the db's without OMF in ASM ?
And is this a good idea? I know OMF does a lot of the user management of files etc, but I want to keep my ASM directory structure neat and keep the test env's separate from one another.
Thank you
Phillip du Plooy