Re: DBA- Moving REDO LOGs

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Thu, 6 Aug 2015 12:29:37 -0500
Message-Id: <888EC25B-9F13-4A1C-A239-82647C57354A_at_gmail.com>

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 - 19:29:37 CEST