Flashback database on a RAC database with rac standby setup
This has been tested in a 8 Node RAC with 8 node Standby RAC database. 1. Verify if flashback and force_logging database is enabled on both primary and standby. Primary: select flashback_on,force_logging from v$database; [RACFDP1]oracle@primarydb1.ora.com$ sqlplus /nolog SQL*Plus: Release 11.2.0.1.0 Production on Fri Oct 14 10:23:58 2011 Copyright (c) 1982, 2009, Oracle. All rights reserved. SQL> conn / as sysdba Connected. SQL> select flashback_on,force_logging from v$database; FLASHBACK_ON FOR ------------------ --- YES YES Stanbdy: select flashback_on,force_logging from v$database; [RACFDP1]oracle@primarydb1.ora.com$ sqlplus /nolog SQL*Plus: Release 11.2.0.1.0 Production on Fri Oct 14 10:23:58 2011 Copyright (c) 1982, 2009, Oracle. All rights reserved. SQL> conn / as sysdba Connected. SQL> select flashback_on,force_logging from v$database; FLASHBACK_ON FOR ------------------ --- YES YES SQL> 2. Verify if