i have my controlfiles all in a single directory but was just thinking that won't be ideal enough,as shown below.
Code:
SQL> show parameters control_files;
NAME TYPE VALUE
-------- ----------- ------------------------------
control_files string C:\ORACLE\PRODUCT\10.1.\ORADATA\ORCL_1\CONTROL01.CTL,
C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL_1\CONTROL02.CTL,
C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL_1\CONTROL03.CTL
i need to make a multiplex to a new directory like
''C:\oracle\product\10.1.0\oradata\orcl_1\mulplx\CONTROL04.CTL''
If I do
alter system set control_file=''C:\oracle\product\10.1.0\oradata\orcl_1\CONTROL01.CTL'',''C:\oracle\product\10.1.0\or adata\orcl_1\mulplx\CONTROL04.CTL '' scope = spfile;
Will oracle synchronise the new controlfile withe the old ones even if they are in different directory.
thanks