MyOracleWorld.Net  .........

 

Creating an ASM alias for control files - "Missing" after clone

Users usually experience this error after doing a duplicate database using RMAN from one +ASM instance to another +ASM instance

 

Error:

 

SQL> startup mount;   

ORA-32004: obsolete and/or deprecated parameter(s) specified

ORACLE instance started.

 

Total System Global Area 2137886720 bytes

Fixed Size                   2161400 bytes

Variable Size                872416520 bytes

Database Buffers             1140850688 bytes

Redo Buffers                 122458112 bytes

ORA-00205: error in identifying control file, check alert log for more info

 

SQL>

 

From the alert.log:

 

SUCCESS: diskgroup DATA3 was mounted

ORA-00210: cannot open the specified control file

ORA-00202: control file: '+DATA3/PROD/cntrl01.dbf'

ORA-17503: ksfdopn:2 Failed to open file +DATA3/PROD/cntrl01.dbf

ORA-15173: entry 'cntrl01.dbf' does not exist in directory 'preprod'

ORA-205 signalled during: ALTER DATABASE   MOUNT...

SUCCESS: diskgroup DATA3 was dismounted

Wed May 04 07:39:57 2011

 

 

Solution:

 

ASMCMD> ls    

TEST/

EMREP/

SLAB/

PROD/

cntrl01.dbf

cntrl02.dbf

cntrl03.dbf

ASMCMD>

 

cntrl01/2/3 belongs to PROD, but it should be in the PROD/ subdirectory

 

One solution is to copy the file within ASM to the correct path - from my experience, this don't always solve the problem, if not, create the alias as explained below

 

ASMCMD> cp cntrl01.dbf PREPROD/

copying +DATA3/cntrl01.dbf -> +DATA3/PREPROD/cntrl01.dbf

ASMCMD>

 

After this, it might still look for the file callled "cntrl01.dbf", which will not exist after the above copy, as Oracle 'rename' these files as soon as it opens the database

 

Change to the +DATA3/PROD directory and create an alias for the newly stamped control files to a static control file name, like I did below.

 

ASMCMD> ls

CONTROLFILE/

DATAFILE/

TEMPFILE/

cntrl01.dbf.499.750237909 

cntrl01.dbf.528.750238283 

ASMCMD>

 

ASMCMD> mkalias cntrl01.dbf.499.750237909 cntrl01.dbf

ASMCMD> ls

CONTROLFILE/

DATAFILE/

TEMPFILE/

cntrl01.dbf 

cntrl01.dbf.499.750237909 

cntrl01.dbf.528.750238283 

ASMCMD>

 

 

 

HTML Comment Box is loading comments...