Add 3rd Control File in ASM with 2 Disk Groups and keep auto naming
Hi - I have a 2 Node RAC install with 2 control file and use the autonaming of the files. I would like to add a 3rd control file and keep it with the 1st control file on the +DATA Group and use autonaming for all 3 files. I can figure out how to accomplish this...open to alternative strategy suggestions also...Thanks!
Current Config:
+DATA/test1/controlfile/current.271.887372499
+FRA/test1/controlfile/current.297.887372499
Desired Config:
+DATA/test1/controlfile/current.271.887372499
+DATA/test1/controlfile/current.###.####### --New Control File
+FRA/test1/controlfile/current.297.887372499
I tried this:
ALTER SYSTEM SET control_files = '+DATA/test1/controlfile/current.271.887372499', '+FRA/test1/controlfile/current.297.887372499', '+DATA' SCOPE=SPFILE sid='*';