RE: Flashback Database NEWBIE - 10g - Going to setup one for first time
- From: <Christopher.Taylor2@xxxxxxxxxxxx>
- To: <andrew.kerber@xxxxxxxxx>
- Date: Thu, 7 Mar 2013 17:23:40 -0600
Here's the scenarios we're trying to hit - any thoughts?
I thought this would be rather simple to maintain I must be missing something:
Scenario 1 (what do I need to consider here)
#1 Monday - Initial Restore Point - always will flashback to this
#2 Tuesday - safety restore point
#3 Wed - safety restore point
#4 Thur - safety restore point
#5 Friday - safety restore point
Friday Night - flashback database to restore point #1. (The subsequent
flashback #s here will be cleaned out/overwritten or do I need to script that?)
Scenario 2 (what do I need to consider here)
#1 Monday - Initial Restore Point - always will flashback to this
#2 Tuesday - safety restore point
#3 Wed - safety restore point
#4 Thur - safety restore point
#5 Friday - safety restore point
*OOOPS - need to flashback to Thursday #4
Friday night - Flashback to #1
From: Andrew Kerber [mailto:andrew.kerber@xxxxxxxxx]
Sent: Thursday, March 07, 2013 5:09 PM
To: Taylor Christopher - Nashville
Subject: Re: Flashback Database NEWBIE - 10g - Going to setup one for first time
Yeah, I agree. Its going to be a pain to maintain. You will probably even
want to try and keep a virgin copy out somewhere safe in case something gets
screwed up along the way.
On Thu, Mar 7, 2013 at 4:57 PM,
<Christopher.Taylor2@xxxxxxxxxxxx<mailto:Christopher.Taylor2@xxxxxxxxxxxx>>
wrote:
Thanks for taking some time - lots of pieces to this and I like hitting it
right the first time :)
Chris
From: Andrew Kerber
[mailto:andrew.kerber@xxxxxxxxx<mailto:andrew.kerber@xxxxxxxxx>]
Sent: Thursday, March 07, 2013 4:54 PM
To: andy@xxxxxxxxxxxxxxx<mailto:andy@xxxxxxxxxxxxxxx>
Cc: Taylor Christopher - Nashville;
oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>
Subject: Re: Flashback Database NEWBIE - 10g - Going to setup one for first time
No you do not have to put those there, but most people do put the archivelogs
and often one copy of the backups in the FRA. Archivelogs will go there by
default, unless you direct them elsewhere.
On Thu, Mar 7, 2013 at 4:48 PM, Andy Klock
<andy@xxxxxxxxxxxxxxx<mailto:andy@xxxxxxxxxxxxxxx>> wrote:
Sending again for over-quoting. Sorry.
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:
> 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
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
--
//www.freelists.org/webpage/oracle-l
Other related posts:
