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

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Fri, 9 Oct 2015 10:27:32 +0100
Message-ID: <CABe10sZZwXHXRc81qKQuOdyw7rc0+EsC4aK40o2k1EiV_Mv_9w_at_mail.gmail.com>

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

Received on Fri Oct 09 2015 - 11:27:32 CEST