This certainly can be helpful feature and already has been requested in past,
but may be worth trying again.
Adding/dropping logfile group/member is done on “INACTIVE” group, so no process
is accessing logfile. I don’t know how this could be possible for controlfile
maintenance (add/drop) because controlfile(s) should be available for
read/write all the time.
- Mayen
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Michael Cunningham
Sent: Friday, October 09, 2015 5:23 PM
To: LDO@xxxxxx
Cc: oracle-l@freelists org
Subject: Re: Needed for next oracle version: alter database add control_files
I'll vote for that enhancement.
On Oct 9, 2015 1:58 AM, "Lars Dohn" <LDO@xxxxxx<mailto: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 ☺ (no downtime).
How do I file an enhancement request?
Regards
_____________
Lars Dohn
Very old dba…
Statistics Denmark
Sejrøgade 11
2100 København Ø