Hi everybody,
I have a few questions concerning the best practices about storing microstratgy's [bi reporting tool] metadata in Oracle and as our experience w Oracle is limited I kindly ask for you advice / opinion...
We are planning to configure an metadata database with two schema, one for the production environment and one for development.
1) Are there any best practices concerning the back-up procedures(in terms of type of backup, frequency..etc) ?
2) For hardware, any benefit in partitioning the server into drives, if the server will only be used for holding the Oracle metadata? Except for the standard RAM and disk space recommendations are there any other hardware settings that we should take into consideration?
3) Any recommendations for the physical separation of the data contained in the two schema?
Any input is appreciated
Regards,