This is on a dev server for multiple different envs of one application.
e.g. a copy of production as of last night, a copy of production as of a week ago, etc etc
Does it make more sense to have 1 instance of Oracle with 8 schemas (one for each application env) or for 8 instances each with 1 schema?
We are doing backups with datapump instead of RMAN.
The key difference to this question is that in this case it is one application team with multiple instances/versions of their application and that is talk about multiple applications and also RAC.