RE: Enabling Flashback DB in Production Databases. - Reverse
Date: Wed, 25 Feb 2009 16:47:26 -0500
Message-ID: <21469B88E0EA11498818517F210335310C03C83A_at_EPRI17P32001A.csfb.cs-group.com>
that should be
alter database flashback off
Paul Baumgartel
CREDIT SUISSE
Information Technology
Prime Services Databases Americas
One Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel_at_credit-suisse.com
www.credit-suisse.com
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bradd Piontek
Sent: Wednesday, February 25, 2009 2:29 PM
To: Brian.Zelli_at_roswellpark.org
Cc: Oracle-L Group
Subject: Re: Enabling Flashback DB in Production Databases. - Reverse
The only reason I can see for enabling this in production is for Data Guard. These are , obviously, my personal opinions. I don't see many scenarios (if any) where I would flash an entire production database back as that would mean data loss.
To turn it off, you need to shutdown, startup mount, alter database disable flashback database, alter database open.
Bradd Piontek
"Next to doing a good job yourself,
the greatest joy is in having someone else do a first-class job under your direction."
- William Feather
On Wed, Feb 25, 2009 at 1:19 PM, Zelli, Brian <Brian.Zelli_at_roswellpark.org> wrote:
Ok, we have it running and it keeps filling up and stopping the database. Is there a way to disable it? ciao, Brianconfidential information. If you are not the intended recipient(s), or the employee or agent responsible for the delivery of this message to the intended recipient(s), you are hereby notified that any disclosure, copying, distribution, or use of this email message is prohibited. If you have received this message in error, please notify the sender immediately by e-mail and delete this email message from your computer. Thank you.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of FMHabash Sent: Wednesday, February 25, 2009 11:22 AM To: Oracle-L Group Subject: Enabling Flashback DB in Production Databases. We use FB DB pretty regularly to test application upgrades. We have thought to explore this feature in prod dbs and looking for real-life experience. Has anyone implemented it in production DB's. If yes, what lessons have you learned that you can share?
--
http://www.freelists.org/webpage/oracle-l This email message may contain legally privileged and/or
--
http://www.freelists.org/webpage/oracle-l
Please access the attached hyperlink for an important electronic communications disclaimer:
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 25 2009 - 15:47:26 CST