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;
Lars Dohn
Very old dba...
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-lReceived on Fri Oct 09 2015 - 10:58:09 CEST