Re: Move Control File in ASM

  • From: Alex Gorbachev <ag@xxxxxxxxxxxx>
  • To: Tom.Terrian.ctr@xxxxxxx, Ian Cary <ian.cary@xxxxxxxxxxxxxx>
  • Date: Sat, 24 May 2008 23:41:27 -0400

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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 05-2008