Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-38743: Time/SCN is in the future of the database.

JhilNov 24 2015 — edited Nov 27 2015

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 ?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 25 2015
Added on Nov 24 2015
55 comments
11,386 views