Re: Flashsback, ASM, and archive logs on RAC

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@xxxxxxxxxxx> 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


Other related posts: