Re: Move Control File in ASM

Hello,

ASM is perfectly happy with RAC (built for it really), so DBMS_TRANSFER is ok.

I personally prefer doing the following rman command:

RMAN>restore controlfile to '<NEW LOCATION>' from '<OLD LOCATION>';

jason.

--
http://jarneil.wordpress.com

On 22 May 2008, at 20:05, kathy duret wrote:



> Would this work in a Rac environment as well?

>

> Kathy

>

> "Terrian, Thomas J Mr CTR DLA J6DIB" <Tom.Terrian.ctr_at_dla.mil> wrote:

> Great thanks.

>

> -----Original Message-----

> From: Ian Cary [mailto:ian.cary_at_ons.gsi.gov.uk]

> Sent: Wednesday, May 21, 2008 7:47 AM

> To: Terrian, Thomas J Mr CTR DLA J6DIB

> Cc: oracle-l_at_freelists.org; oracle-l-bounce_at_freelists.org

> Subject: Re: Move Control File in ASM

>

> DBMS_FILE_TRANSFER should do the trick.

>

> create directory dir1 as '+DATA/db';

> create directory dir2 as '+DATA/db/CONTROLFILE';

>

> exec

> dbms_file_transfer 

> .copy_file('dir1','control01.ctl','dir2','control01.ct

> l');

>

> Cheers,

>

> Ian

>

>

>

> |---------+----------------------------->

> | | Tom.Terrian.ctr_at_dl|

> | | a.mil |

> | | Sent by: |

> | | oracle-l-bounce_at_fr|

> | | eelists.org |

> | | |

> | | |

> | | 21/05/2008 12:07 |

> | | Please respond to |

> | | Tom.Terrian.ctr |

> | | |

> |---------+----------------------------->

>

> > 

> -----------------------------------------------------------------------

> ---------------------------------------|

> |

> |

> | To: oracle-l_at_freelists.org

> |

> | cc:

> |

> | Subject: Move Control File in ASM

> |

>

> > 

> -----------------------------------------------------------------------

> ---------------------------------------|

>

>

>

>

> Using Oracle 10.2, does anyone know how to move a control file in that

> is in ASM 10.2? I want to move my control file from

> +DATA/db/control01.ctl to +DATA/db/CONTROLFILE/control01.ctl. I can

> change the init.ora parameter but I don't see a mv command in asmcmd  

> in

> 10.2.

>

> Thanks,

> Tom

>

> --

> http://www.freelists.org/webpage/oracle-l

>

>

>

> This email was received from the INTERNET and scanned by the  

> Government

> Secure Intranet anti-virus service supplied by Cable&Wireless in

> partnership with MessageLabs. (CCTM Certificate Number  

> 2007/11/0032.) In

> case of problems, please call your organisation's IT Helpdesk.

> Communications via the GSi may be automatically logged, monitored  

> and/or

> recorded for legal purposes.

>

>

> For the latest data on the economy and society consult National

> Statistics at http://www.statistics.gov.uk

>

> ************************************************************************

> *********

>

>

> Please Note: Incoming and outgoing email messages are routinely

> monitored for compliance with our policy on the use of electronic

> communications

> ************************************************************************

> *********

>

>

> Legal Disclaimer : Any views expressed by the sender of this message

> are not necessarily those of the Office for National Statistics

> ************************************************************************

> *********

>

>

> The original of this email was scanned for viruses by the Government

> Secure Intranet virus scanning service supplied by Cable&Wireless in

> partnership with MessageLabs. (CCTM Certificate Number  

> 2007/11/0032.) On

> leaving the GSi this email was certified virus free.

> Communications via the GSi may be automatically logged, monitored  

> and/or

> recorded for legal purposes.

>

> --

> http://www.freelists.org/webpage/oracle-l

>

>

>

>



--
http://www.freelists.org/webpage/oracle-l