RE: Flashback Database NEWBIE - 10g - Going to setup one for first time
Date: Thu, 7 Mar 2013 16:09:09 -0600
Message-ID: <F05D8DF1FB25F44085DB74CB916678E88582EB557D_at_NADCWPMSGCMS10.hca.corpad.net>
Ugh - nevermind the bit about finding amount of redo generated - was having a "moment". ;)
Chris
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Christopher.Taylor2_at_parallon.net
Sent: Thursday, March 07, 2013 3:32 PM
To: oracle-l_at_freelists.org
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
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 07 2013 - 23:09:09 CET