RE: Enabling Flashback DB in Production Databases. - Reverse

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@xxxxxxxxxxxxxxxxx 
www.credit-suisse.com 

 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Bradd Piontek
Sent: Wednesday, February 25, 2009 2:29 PM
To: Brian.Zelli@xxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxxx> wrote:



        Ok, we have it running and it keeps filling up and stopping the
        database.  Is there a way to disable it?
        
        ciao,
        Brian
        
        
        -----Original Message-----
        From: oracle-l-bounce@xxxxxxxxxxxxx
        [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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
confidential 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.
        --
        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
==============================================================================

Other related posts: