RE: Flashback Database NEWBIE - 10g - Going to setup one for first time

From: <Christopher.Taylor2_at_parallon.net>
Date: Thu, 7 Mar 2013 16:48:32 -0600
Message-ID: <F05D8DF1FB25F44085DB74CB916678E88582EB561B_at_NADCWPMSGCMS10.hca.corpad.net>



So, do you have to put UNDO and backups and archives in the FLASH recovery area? What if I already have ASM disk groups assigned to those functions (minus backups - backups goto cooked filesystem on the server). Chris

From: Andrew Kerber [mailto:andrew.kerber_at_gmail.com] Sent: Thursday, March 07, 2013 4:34 PM
To: gcunningham_at_proteuseng.com
Cc: Taylor Christopher - Nashville; oracle-l_at_freelists.org Subject: Re: Flashback Database NEWBIE - 10g - Going to setup one for first time

Keep in mind that you also need space for backups and archived logs, not just the flashback logs.

From: andyklock_at_gmail.com [mailto:andyklock_at_gmail.com] On Behalf Of Andy Klock Sent: Thursday, March 07, 2013 4:40 PM
To: Taylor Christopher - Nashville
Cc: oracle-l_at_freelists.org
Subject: Re: Flashback Database NEWBIE - 10g - Going to setup one for first time

You are still missing space for the flashback logs. Those are not chump change either. Plus any additional space you will need for your UNDO tablespace.

http://docs.oracle.com/cd/B19306_01/backup.102/b14192/rpfbdb003.htm On Thu, Mar 7, 2013 at 5:13 PM, <Christopher.Taylor2_at_parallon.net<mailto:Christopher.Taylor2_at_parallon.net>> wrote: I've checked the MAX redo log generation for the training database.

The maximum for any day (rounded up) is 80GB.

If I want to make sure I have enough FLASHBACK space for 5 business days I thought about using 6x80 (to give me an extra day of space "just in case") and come up with 480 GB of redo generated that I need to be able to flashback from.

In this case is 500GB enough for a flashback area or am I still leaving out something?

Chris

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 07 2013 - 23:48:32 CET

Original text of this message