15Tb FRA will let you run for 3 months before you remember that you didn't drop a gauranteed restore point. Theoretically. :) ________________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Christopher.Taylor2@xxxxxxxxxxxx [Christopher.Taylor2@xxxxxxxxxxxx] Sent: Thursday, March 07, 2013 5:13 PM To: oracle-l@xxxxxxxxxxxxx Subject: RE: Flashback Database NEWBIE - 10g - Going to setup one for first time 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 -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Christopher.Taylor2@xxxxxxxxxxxx Sent: Thursday, March 07, 2013 3:32 PM To: oracle-l@xxxxxxxxxxxxx Subject: Flashback Database NEWBIE - 10g - Going to setup one for first time We have a training database that we're going to setup as a flashbackable database (is that a word?). The requirement is to take the restore point on Monday, do the training and then flashback to the Monday restore point on Friday evening/Saturday morning. This training database currently is not flashback enabled and generates regular amounts of redo etc. Here's my first question: Can I look at the existing training database and query the amount of redo activity generated to calculate the flashback area size that I need to setup? I'll want to be able to flashback to any point during the week on the off chance they really fubar something and need to go back a day. If this is true, what view(s) do I need to look at to drive my calculations? Second question: In the event I need to do a flashback to a the day before (say Thursday back to Wednesday) will I still be able to flashback to Monday once I get to Friday night? I assume the answer to this is yes as long as the Monday flashback is a guaranteed flashback recovery point. Please correct me if I'm wrong on that or need additional guidance. Regards, Chris Taylor Oracle DBA Parallon IT&S -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l-- //www.freelists.org/webpage/oracle-l