Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Flashsback, ASM, and archive logs on RAC

Re: Flashsback, ASM, and archive logs on RAC

From: Alex Gorbachev <ag_at_oracloid.com>
Date: Mon, 23 Jul 2007 09:03:10 -0400
Message-ID: <c2213f680707230603gd4a854cuf7ad602ba60bfc87@mail.gmail.com>


You can back them up and compressed they will consume about 30 percent of space according to my experience. You don't have to delete archive logs after backup - Oracle will delete them if there is space pressure in FRA. This can save you some time during recovery as you won't need to restore them.

On 7/22/07, Michael Kline <mkline1_at_comcast.net> wrote:
> We have a new setup using ASM, RAC and Flashback Recovery Area.
>
>
>
> The archive logs go to the FRA as well. We do hot backups but are not
> deleting
> the archive logs. Since the backup sets go to FRA, I'm wondering what, if
> any,
> advantage there is to keeping the archive logs. I'm thinking that "backup
> archive logs delete input" may make a lot more sense because they would
> already
> be in the backup sets anyhow.
>
>
>
> We do daily full hot backups. It's 10.2.0.3 on AIX, and everything is pretty
> much in ASM.
>
>
>
> Comments?
>
>
>
> Michael Kline
>
> Principal Consultant
>
> Business to Business Solutions
>
> 13308 Thornridge Ct
>
> Midlothian, VA 23112
>
> O: 804.744.1545
>
> Fax: 804.763.0114
>
>
>
>

-- 
Alex Gorbachev, Oracle DBA Brewer, The Pythian Group
http://www.pythian.com/blogs/author/alex http://www.oracloid.com
BAAG party - www.BattleAgainstAnyGuess.com
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jul 23 2007 - 08:03:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US