RE: Move Control File in ASM
- From: "Terrian, Thomas J Mr CTR DLA J6DIB" <Tom.Terrian.ctr@xxxxxxx>
- To: <ag@xxxxxxxxxxxx>, "Ian Cary" <ian.cary@xxxxxxxxxxxxxx>
- Date: Tue, 27 May 2008 07:50:29 -0400
Alex, you are 100% correct. I have left the files where they are. I
didn't know that the ls -l command existed. Running it explains
everything. Thanks for the information.
Tom
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Alex Gorbachev
Sent: Saturday, May 24, 2008 11:41 PM
To: Terrian, Thomas J Mr CTR DLA J6DIB; Ian Cary
Cc: ORACLE-L Freelists
Subject: Re: Move Control File in ASM
Tom, Ian,
+DATA/db/control01.ctl is actually an alias to something like +DATA/db/
controlfile/current.xxx.xxxxxxxxxx
Whenever you specify a fully qualified name in ASM, it creates an
alias. The real path is managed by OMF convention and based on kind of
file, DB_NAME and couple numbers at the end for unique names.
You can see it using ASMCMD utility - use "ls -l" to see the aliases.
Aliases are something like soft links.
So if you copy your controlfile to +DATA/db/CONTROLFILE/control01.ctl,
it will still be a link to another file. That means that you can
simply create an alias. What's the reason to reference the file using
this new name? If you check existing alias, you will see that it
references existing file +DATA/db/controlfile/current.xxx.xxxxxxxxxx
so you can simply change control_files parameter to that value and
remove old alias.
Btw, I recall that using DBMS_FILE_TRANSFER to copy files to ASM often
results in fancy naming with DB_UNKNOWN used as SID and requested
target path would be just an alias again.
Be careful thinking about ASM as a normal filesystem. It's not really
a filesystem and manages files and paths in its own way.
Alex
On 21-May-08, at 8:04 AM, Terrian, Thomas J Mr CTR DLA J6DIB wrote:
> Great thanks.
>
> -----Original Message-----
> From: Ian Cary [mailto:ian.cary@xxxxxxxxxxxxxx]
> Sent: Wednesday, May 21, 2008 7:47 AM
> To: Terrian, Thomas J Mr CTR DLA J6DIB
> Cc: oracle-l@xxxxxxxxxxxxx; oracle-l-bounce@xxxxxxxxxxxxx
> 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@dl|
> | | a.mil |
> | | Sent by: |
> | | oracle-l-bounce@fr|
> | | eelists.org |
> | | |
> | | |
> | | 21/05/2008 12:07 |
> | | Please respond to |
> | | Tom.Terrian.ctr |
> | | |
> |---------+----------------------------->
>
>>
-----------------------------------------------------------------------
> ---------------------------------------|
> |
> |
> | To: oracle-l@xxxxxxxxxxxxx
> |
> | 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
>
> --
> //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.
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
