Relocation of Controlfiles & online redo log files

[Former Member]

Hi

I'm running SAP ECC6 on Oracle 10g on as SUN Solaris Box running Solaris 5.10

All my online redo log files and controlfiles are on the same disk creating a single point of failure in case of media failure.

I want multiplex both control files and online redo log files on two separate physical disks. Does BRTOOLs give me an option for this or should I resort to SQLPLUS commands ?

Thanks

[stefan_koehler]

Hello Joseph,

yes you can use the BR*Tools (=> BRSPACE 7.10 Patch-Level 17) for that. Sapnote #1259767 describes this in detail.

I always recommend to use the BR*Tools, if you don't exactly know how to do it (or what to do).

Regards

Stefan

[Former Member]

Thanks

I've read the SAPNOTE. But only mentions the relocation of online redolog files. What about relocation controlfiles ? Is there such a facility in brtools ?

regards

[stefan_koehler]

Hello Jospeh,

> What about relocation controlfiles ? Is there such a facility in brtools ?

Of course. The BR*Tools allows you to change the corresponding init parameter:

http://help.sap.com/saphelp_nw70/helpdata/en/f1/0d01b42a4aa84fbe2be415d23bf023/content.htm

After the BR*Tools action you have to create the copy of the control file (after shutdown):

http://pbarut.blogspot.com/2007/03/movingadding-control-file-when-using.html

Regards

Stefan

[fidel_vales]

Hi,

AFAIK, the control file location cannot be changed with BRTOOLS.

To move them you have to stop oracle, move them at OS level, change the parameter "control_file" to point to the new location and start oracle.

If you are using spfile the change of the parameter "control_files" has to be done before shutdown:

ALTER SYSTEM SET control_files='<new locations>' SCOPE=SPFILE;