Needed for next oracle version: alter database add control_files

  • From: Lars Dohn <LDO@xxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 9 Oct 2015 08:58:09 +0000

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 :) (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: