Re: Flashsback, ASM, and archive logs on RAC
- From: "Alex Gorbachev" <ag@xxxxxxxxxxxx>
- To: mkline1@xxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Mon, 23 Jul 2007 09:03:10 -0400
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
