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

https://community.oracle.com/community/database/database-ideas

On Fri, Oct 9, 2015 at 4:27 AM, Niall Litchfield <niall.litchfield_at_gmail.com
> wrote:

> 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_at_dst.dk> 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
>

--
http://www.freelists.org/webpage/oracle-l