I haven't tried it myself, but it appears to me that the procedure would
be as follows:
- 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.
- SHUTDOWN IMMEDIATE
- Move the control file(s)
- STARTUP
HTH,
Brian
"Gordon T. Wu" wrote:
>
> Hi Group:
>
> I'm trying to multiplex the locations of control files. How do I
> change the location of CONTROL03.CTL in Oracle 9.2? The spfile thing
> in Oracle 9.2 is making this process complicated.
>
> Thanks a lot.
--
===================================================================
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 Wed Jun 11 2003 - 16:19:17 CDT
