Hi all;
TEST CASE .
I have started manual failover operation.
i did failover operation using DGMGRL interface, it worked.
then i tried with SQL interface , here i am hitting error.
>> On standby datavase server ( The new primary)
SQL> select flashback_on, STANDBY_BECAME_PRIMARY_SCN from v$database;
FLASHBACK_ON STANDBY_BECAME_PRIMARY_SCN
------------------ --------------------------
YES 1100172
>> On the failed primary ( old primary)
SQL> startup mount;
ORACLE instance started.
Database mounted.
SQL> flashback database to scn 1100172;
flashback database to scn 1100172
*
ERROR at line 1:
ORA-38743: Time/SCN is in the future of the database.
I can go for lower SCN, but i try to understand , why i got different response ?
Getting confused. Initially how DGMGRL done , at that time i did not find any error in alert log.
Expecting exact problem. why it occurred ?