adding a control file (I blew something)

From: obakesan <pellicleundies_at_hotmail.com>
Date: Fri, 29 Aug 2008 06:18:32 GMT
Message-ID: <YwMtk.29$Hv4.28@read4.inet.fi>

HiYa

I had the 10g server here (Release 10.2.0.1.0) configured (from creation) to have 3 control files (although in the same location)

/u01/app/oracle/product/10.2.0/oradata/orcl/control01.ctl,
/u01/app/oracle/product/10.2.0/oradata/orcl/control02.ctl,
/u01/app/oracle/product/10.2.0/oradata/orcl/control03.ctl

I wanted to (as an exersize) make a 4th to make it:

/u01/app/oracle/product/10.2.0/oradata/orcl/control01.ctl,
/u01/app/oracle/product/10.2.0/oradata/orcl/control02.ctl,
/u01/app/oracle/product/10.2.0/oradata/orcl/control03.ctl,
/u01/app/oracle/product/10.2.0/oradata/orcl/control04.ctl'

my server is started from an SPFILE, and I'm a little uncertain of the procedure as previously (8i) I've modified the init$SID.ora text file.

Anyway, I thought that the procedure was to: SQL> startup nomount;
ORACLE instance started.

Total System Global Area 536870912 bytes

Fixed Size                  1220408 bytes
Variable Size             163578056 bytes
Database Buffers          364904448 bytes
Redo Buffers                7168000 bytes

SQL> alter system
  2 set control_files =
'/u01/app/oracle/product/10.2.0/oradata/orcl/control01. ctl,

  3  /u01/app/oracle/product/10.2.0/oradata/orcl/control02.ctl,
  4  /u01/app/oracle/product/10.2.0/oradata/orcl/control03.ctl,
  5  /u01/app/oracle/product/10.2.0/oradata/orcl/control04.ctl'

  6 scope=spfile;

System altered.

SQL> alter database mount;

Database altered.

then shut it down
SQL> shutdown immediate;

and copy the files in the OS.
Eg:

$ cp /u01/app/oracle/product/10.2.0/oradata/orcl/control01.ctl  /u01/app/oracle/product/10.2.0/oradata/orcl/control04.ctl

then startup. However this procedure didn't work for me.

SQL> startup
ORACLE instance started.

Total System Global Area 536870912 bytes

Fixed Size                  1220408 bytes
Variable Size             167772360 bytes
Database Buffers          360710144 bytes
Redo Buffers                7168000 bytes

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

dratt!

looking in the alert log I find:

ORA-00202: control file:
'/u01/app/oracle/product/10.2.0/oradata/orcl/control01. ctl, /u01/app/oracle/product/10.2.0/oradata/orcl/control02.ctl,
/u01/app/oracle/

product/10.2.0/oradata/orcl/control03.ctl,
/u01/app/oracle/product/10.2.0/oradat

a/orcl/control04.ctl'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory Additional information: 3

which I don't understand, because I can confirm each of the files with an ls

I then thought mmm ... and tried another angle

I made a PFILE from my SPFILE:

SQL> create pfile from spfile;

edited this line:

*.control_files='/u01/app/oracle/product/10.2.0/oradata/orcl/control01.ctl,

to

*.control_files='/u01/app/oracle/product/10.2.0/oradata/orcl/control01.ctl,
/u01/app/oracle/product/10.2.0/oradata/orcl/control02.ctl,
/u01/app/oracle/product/10.2.0/oradata/orcl/control03.ctl,
/u01/app/oracle/product/10.2.0/oradata/orcl/control04.ctl'

and started from the PFILE

same error

I then paired the line down to:

*.control_files='/u01/app/oracle/product/10.2.0/oradata/orcl/control03.ctl'

and it started fine.

so I suspect my syntax is wrong.

Is there anything else which might be going wrong here? For example is there any reason why I needed to copy any particular control file (1, 2 or 3) for example?

thanks in advance

See Ya
(when bandwidth gets better ;-)

Chris Eastwood
Photographer, Programmer Motorcyclist and dingbat blog: http://cjeastwd.blogspot.com/

please remove undies for reply Received on Fri Aug 29 2008 - 01:18:32 CDT