RE: Flashback Database NEWBIE - 10g - Going to setup one for first time
- From: <Christopher.Taylor2@xxxxxxxxxxxx>
- To: <andy@xxxxxxxxxxxxxxx>
- Date: Thu, 7 Mar 2013 16:48:32 -0600
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@xxxxxxxxx]
Sent: Thursday, March 07, 2013 4:34 PM
To: gcunningham@xxxxxxxxxxxxxx
Cc: Taylor Christopher - Nashville; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxx [mailto:andyklock@xxxxxxxxx] On Behalf Of Andy Klock
Sent: Thursday, March 07, 2013 4:40 PM
To: Taylor Christopher - Nashville
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxx<mailto:Christopher.Taylor2@xxxxxxxxxxxx>>
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
