i have my controlfiles all in a single directory but was just thinking that won't be ideal enough,as shown below.
i need to make a multiplex to a new directory likeCode: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
''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




Reply With Quote