Re: Flashsback, ASM, and archive logs on RAC
- From: "Syed Jaffar Hussain" <sjaffarhussain@xxxxxxxxx>
- To: mkline1@xxxxxxxxxxx
- Date: Sun, 22 Jul 2007 16:41:09 +0300
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@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
>
>
>
--
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."
Other related posts:
