can anyone tell that is it possible to have database on external storage (without RAC or OPS). How application will be connected to other node at time of failure?
Printable View
can anyone tell that is it possible to have database on external storage (without RAC or OPS). How application will be connected to other node at time of failure?
you better explain what you mean - most people have databases on external stroage, be it disk arrays or SAN's or whatever.
Do you want two database to share the same files without using RAC?
It sounds to me like you're after something like HPs MC Service Guard. The database exists on a single storage array and the relevant file systems are mounted on the first node. A customisable cluster control script (a shell script) monitors for Oracle background processes. If it finds that one of the processes isn't there the script tries to shut the database down and unmount the filesystem. The filesystem is then mounted on the other node and the database started up.