Re: Flashsback, ASM, and archive logs on RAC

Are you also backing up the archived logs or not?

I am not sure, even if the FRA deletes the older files to make a room for the new one, it will be a valid delete(archived logs) or not for the RMAN.

Why dont you backup the archived logs with compressed option and leave the backupsets in FRA (or make backup to tape).?

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

-- 
Best Regards,
Syed Jaffar Hussain
Oracle ACE
8i,9i & 10g OCP DBA

http://jaffardba.blogspot.com/
http://www.oracle.com/technology/community/oracle_ace/ace1.html#hussain
----------------------------------------------------------------------------------
"Winners don't do different things. They do things differently."

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