Is it possible to restrict usage of a diskgroup to a specific database?
Hello,
We are working on a 3 node RAC which will have 2 databases installed.
Each databases will have an ASM diskgroup with 16 disks: DB01->+DATA1,DB02->+DATA2
The redundancy is external.
- 1 grid infrastructure
- 2 database home
- 2 database
We will have a georedundant site with the same configuration.
Replication is performed at SAN level. (EMC vmax)
The SAN disks are exposed to only one site at any given time.
If DB02 happens to have tablespaces created on +DATA1, and DB01 fails over to site2, then DB02 would suffer data loss due to the missing disk.
Likewise, trying to failover DB02 won't be a very positive experience.