Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

About controlfile multiplexing and naming conventions.

steelnwoolMay 20 2011 — edited May 20 2011
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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 17 2011
Added on May 20 2011
10 comments
569 views