About controlfile multiplexing and naming conventions.
My first question is: A lot of times when people are multiplexing control files they are named control01.ctl control02.ctl but reside in different locations on the machine. Is there a reason for this convention versus just naming them all control.ctl or control01.ctl everywhere?
Second, this one is more about moving them.
Right now I have 2 control files:
SQL> SHOW PARAMETERS control_files;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_files string /u00/app/oracle/oradata/orcl/control01.ctl, /u00/app/oracle/flash_recovery_area/orcl/control02.ctl
I want to either MOVE the second one in the flash_recovery_area, or just kill it and re-multiplex. Is there any difference to which I choose?
Going forward I plan upon keeping 3 versions of it. One on each of the 3 disks available to the system, same place I keep my online redo logs multiplexed.
As I understand it, I should do this
SQL> ALTER SYSTEM SET control_files = '/u00/app/oracle/oradata/orcl/control01.ctl', '/u01/oracle_control_file/control0x.ctl', '/u02/oracle_control_file/control0x.ctl';
SQL> shutdown immediate
SQL> HOST MOVE a to b....... do i need this if i remove?
SQL> startup open;
Log out of sqlPlus
Log into RMAN
RMAN> run a backup;
Thanks.