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

  • From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
  • To: LDO@xxxxxx
  • Date: Fri, 9 Oct 2015 10:27:32 +0100

I think the current method for doing this is to file an SR and indicate
that its an enhancement request in the text. Whether this is more or less
effective than hoping the relevant product manager is on this list is open
to question!!

I agree that that would be a nice enhancement.

On Fri, Oct 9, 2015 at 9: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 Ø*






--
Niall Litchfield
Oracle DBA
http://www.orawin.info

Other related posts: