Needed for next oracle version: alter database add control_files

From: Lars Dohn <LDO_at_dst.dk>
Date: Fri, 9 Oct 2015 08:58:09 +0000
Message-ID: <16C81F9A2D1FD54CADFDE04942D601D8508A56B9_at_SRVEXC5.dst.local>



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 Ø

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Oct 09 2015 - 10:58:09 CEST

Original text of this message