Hello All,
We have to do a fresh oracle database 11g installation with ASM storage. The OS will be Oracle Linux 7.0. We will be installing linux and creating all required partitions in the freshly created VM. Once the database is ready, we will be importing around 60GB of data from another production database.
Could you please let me know the disk architecture that is required for ASM storage? Like how many disks should be there, how many partitions should be there in each disk, how many diskgoups are recommended, how many disks/disk partitions are to be assigned for the diskgroups? Also, the customer wants us to create 16 disk partitions, and keep separate data on separate partitions, like there are 3 schemas, they want to keep tables of one schema in one partition and indexes of that schema in another partition, then datafiles in one partition, redo logs in another, archive logs in another one, and so on.
Is this possible when using ASM storage? Or ASM will manage files and data automatically?? Please advise.