Re: DBA- Moving REDO LOGs

From: Steve Harville <steve.harville_at_gmail.com>
Date: Thu, 06 Aug 2015 20:32:29 +0000
Message-ID: <CAGd4=DROEuXW1nkNyN0AfcPYoK8k2D6tC8Z=u+67pzKPij6wkw_at_mail.gmail.com>

I wrote a PL/SQL package to do this :
https://steveharville.wordpress.com/2014/03/20/automating-redo-log-maintenance/

On Thu, Aug 6, 2015 at 1:31 PM Andrew Kerber <andrew.kerber_at_gmail.com> wrote:

> Pro tip: 'alter system checkpoint' after a log switch will put the
> previous log into the inactive state faster than just waiting.
>
> Sent from my iPad
>
> On Aug 6, 2015, at 12:18 PM, Don Seiler <don_at_seiler.us> wrote:
>
> Best way to move them without downtime is to add new logfile groups on the
> new location, then perform logfile switches and as the old logfiles are
> archived and status is INACTIVE then you can drop the old groups. Ideally
> new and old groups would have the same size logs, etc.
>
> Don.
>
> On Thu, Aug 6, 2015 at 12:12 PM, Michael Calisi <oracle455_at_gmail.com>
> wrote:
>
>> I am new to oracle-l and posting my first question.
>>
>> I currently have 6 redo logs and we would like to move them with out
>> taken the database down. We are creating a new lun/pool on the top shelf
>> and wondering what's the best way to move my redo logs.
>>
>> Thanks,
>>
>
>
>
> --
> Don Seiler
> http://www.seiler.us
>
>

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

Received on Thu Aug 06 2015 - 22:32:29 CEST