Re: Needed for next oracle version: alter database add control_files

  • From: Michael Cunningham <napacunningham@xxxxxxxxx>
  • To: LDO@xxxxxx
  • Date: Fri, 9 Oct 2015 14:22:54 -0700

I'll vote for that enhancement.
On Oct 9, 2015 1:58 AM, "Lars Dohn" <LDO@xxxxxx> wrote:

Hi list;



Tomorrow I’m patching 51 databases.
At the same time, I’m moving log+ctrl to new fusion-io cards.
Already done logfiles (alter database add logfile; drop old logfiles etc).



To move the control files:
alter system set control_files=’new_location’ scope=spfile;
shutdown;
host copy old to new location;
startup;



What I need :



alter database add control_files (‘new1’,’new2’);
alter database drop control_files(‘old1’,’old2’);



Wouldn’t that be nice J (no downtime).



How do I file an enhancement request?



Regards

_____________

*Lars Dohn*

*Very old dba…*



*Statistics Denmark*


*Sejrøgade 11 2100 København Ø*



Other related posts: