Aw: Re: flashback a standby database

From: Ingrid Voigt <>
Date: Mon, 12 Dec 2016 15:28:59 +0100
Message-ID: <trinity-79773a40-9096-4fe0-962f-932badee429c-1481552939490_at_3capp-gmx-bs07>

What can be done on a snapshot standby is moving 500GB data, indexes and lobs from
one tablespace to another. The flashback took a while, but there were no problems.
After a few hours the database had been converted back to physical standby without
further input from me.
I believe the limits are the same you would have for a "normal" flashback database, i.e.
try to stay away from datafile operations.
Gesendet: Montag, 12. Dezember 2016 um 15:01 Uhr
Von: "Mladen Gogala" <>
Betreff: Re: flashback a standby database
On 12/12/2016 05:35 AM, Howard Latham wrote:
RH 4
Oracle 11.2
I've searched but haven't found the usual list Oracle provides on limits to this feature. 
Does this mean I can do ANYTHING  to a standby database while it is activated then flash it back to a physical standby later? 

Well, I haven't tried anything drastic, like "DROP TABLESPACE <> INCLUDING CONTENTS AND DATAFILES", but the testing that one of my clients was conducting did include add columns and constraints to the tables and then using regular DML. There were no problems. I think that "anything" means "anything within reasonable limits".


Mladen Gogala
Oracle DBA
Tel: (347) 321-1217
-- Received on Mon Dec 12 2016 - 15:28:59 CET

Original text of this message