Re: modify the location of control files

From: Brian Peasland <oracle_dba_at_remove_spam.peasland.com>
Date: Thu, 12 Jun 2003 17:48:38 GMT
Message-ID: <3EE8BCF6.CE18E866@remove_spam.peasland.com>

Sorry, it works for me:

ORA9I SQL> alter system set
control_files='/edcsns14/oradata3/ora9icontrol01.ctl','/edcsns14/oradata3/ora9icontrol02.ctl','/edcsns14/oradata3/ora9icontrol04.ctl' scope=spfile;

System altered.

ORA9I SQL> connect / as sysdba
Connected.
ORA9I SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
ORA9I SQL> !mv /edcsns14/oradata3/ora9icontrol03.ctl /edcsns14/oradata3/ora9icontrol04.ctl

ORA9I SQL> startup
ORACLE instance started.

Total System Global Area 219238532 bytes

Fixed Size                   454788 bytes
Variable Size             150994944 bytes
Database Buffers           67108864 bytes
Redo Buffers                 679936 bytes

Database mounted.
Database opened.

No PFILE ever appeared in my process. Just a lowly SPFILE... ;)

Cheers,
Brian

bob.schmitz_at_artisanpartners.com wrote:
>
> Harald Maier <maierh_at_myself.com> wrote in message news:<m3adcn3j1a.fsf_at_ate.maierh>...
> > Harald Maier <maierh_at_myself.com> writes:
> >
> > > Brian Peasland <oracle_dba_at_remove_spam.peasland.com> writes:
> > >
> > >> I haven't tried it myself, but it appears to me that the procedure
> > >> would be as follows:
> > >>
> > >> 1. Issue ALTER SYSTEM SET
> > >> control_files=/newdir/control01.ctl,.....,/newdir/control03.ctl
> > >> SCOPE=SPFILE;
> > >> This changes the parameter in the SPFILE, but not for the active
> > >> instance.
> > >
> > > This produces the following error:
> > >
> > > 02095, 00000, "specified initialization parameter cannot be modified"
> > > // *Cause: The specified initialization parameter is not modifiable
> >
> > The filenames need to be quoted. The following works fine now:
> >
> > SQL> ALTER SYSTEM SET control_files='/newdir/control01.ctl','/newdir/control02.ctl','/newdir/control03.ctl'
> > SCOPE=SPFILE;
> >
> > System altered.
> >
> > Harald
>
> Nope ... you get this ....
>
> ORA-02095: specified initialization parameter cannot be modified
>
> the correct answer was given above ... create the pfile, modify it,
> shutdown, move the files, startup the oracle database using the new
> pfile, save to the spfile.

-- 
===================================================================

Brian Peasland
oracle_dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"

Received on Thu Jun 12 2003 - 12:48:38 CDT