Re: cron backups on RAC
From: rjamya <rjamya_at_gmail.com>
Date: Thu, 14 Jun 2012 11:16:32 -0400
Message-ID: <CAGurbTPr0Y00bc0We3vC0CgLSY16NrJJXL+gYCSN0xJ+cok2tg_at_mail.gmail.com>
We use flashback restore points for major app releases ... 1 (P1) before release, (this is where we roll back if we rollback the release
2. (P2) one after release but before sanity testing by ops and qa, this is used to roll back to p2 of all is well. This gets rid of testing and we are ready to roll. if something fails, we flashback to P1. if all is well in few hours, we drop the restore points. DB doesn't need to be brought down at all but ymmv.
Date: Thu, 14 Jun 2012 11:16:32 -0400
Message-ID: <CAGurbTPr0Y00bc0We3vC0CgLSY16NrJJXL+gYCSN0xJ+cok2tg_at_mail.gmail.com>
We use flashback restore points for major app releases ... 1 (P1) before release, (this is where we roll back if we rollback the release
2. (P2) one after release but before sanity testing by ops and qa, this is used to roll back to p2 of all is well. This gets rid of testing and we are ready to roll. if something fails, we flashback to P1. if all is well in few hours, we drop the restore points. DB doesn't need to be brought down at all but ymmv.
Raj
On Thu, Jun 14, 2012 at 6:33 AM, Don Morse <dmorse2_at_yahoo.com> wrote:
> Niall, thanks for your response.The only time I would possibly want the
> offline would be to create a before-image serverbackup, prior to a major
> application upgrade, to be used to restore the server to before-upgrade
> image if something went wrong. Otherwise, the online rman backups are run
> daily.
> Thanks,
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jun 14 2012 - 10:16:32 CDT