Failed Primary Conversion to Physical Standby

1) Query on old standby database (new primary)SQL> SELECT TO_CHAR(STANDBY_BECAME_PRIMARY_SCN) FROM V$DATABASE;TO_CHAR(STANDBY_BECAME_PRIMARY_SCN)----------------------------------------124966431892) Flash back the failed primary database.SQL> shutdown immediate;SQL> startup mount;SQL> FLASHBACK DATABASE TO SCN 12496643189;Flashback complete.3) Convert old primary into standby databaseSQL> ALTER DATABASE CONVERT TO PHYSICAL STANDBY;SQL> SHUTDOWN IMMEDIATE;SQL> STARTUP MOUNT;SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM … Continue reading Failed Primary Conversion to Physical Standby

Flashback in SQL Server 2008

SQL Server and DB2 still dont have features like Flashback Table or Flashback Query. SQL Server has snapshots mimicking similar behaviour of Flashback bit it isn't as fine grained as Oracle. IBM DB2 has time travel query which again isn't on the same level  as Flashback. But all other RDBM's are playing quick catchup to Oracle.Get your act … Continue reading Flashback in SQL Server 2008

Flashback Database After Dataguard Failover ( STANDBY_BECAME_PRIMARY_SCN)

Flashing Back a Failed Primary Database into a Physical Standby Database The following steps assume the user has already performed a failover involving a physical standby database and Flashback Database has been enabled on the old primary database. This procedure brings the old primary database back into the Data Guard configuration as a new physical … Continue reading Flashback Database After Dataguard Failover ( STANDBY_BECAME_PRIMARY_SCN)