We currently have a 2 node Oracle RAC and will be going to a Stand Alone DB
simply because RAC is overkill for the applications we have. I also have 2
stand alone DBs and for those I'm using ASM and Oracle Restart. I like ASM and
also like the tools that can be used with Oracle Restart (srvctl, crsctl).
But, in looking to move to a pure stand alone environment, I'd like to get your
opinions on using ASM and Oracle Restart vs using regular file storage. We
are a smaller shop and I'm the only official Oracle DBA and I've had a hard
time trying to get the SQL Server DBA to engage enough in order for me to feel
like I have a good backup resource. So I guess I'm wondering if I just went
to simple standalone with no GI/Oracle Restart/ASM, do you think that would be
easier to manage for someone who is not as familiar with Oracle? And also
would that be easier for upgrades and patching? I've always used GI/ASM so I'm
just trying to look at it from all perspectives - so I can take a vacation
without being worried about who's minding the shop!
I would appreciate your thoughts on this.
Sallie Cottingham, OCP
Comptroller of the Treasury
425 Fifth Avenue North
Nashville, TN 37243-34001