11.2.0.3
Hi,
I cant reinstate my primary database after a failover to the secondary database. I have flashback enabled and doing a flashback using RMAN works fine:
RMAN> flashback database to SCN 513252698542;
Starting flashback at 26-JUN-17
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=4247 device type=DISK
starting media recovery
archived log for thread 1 with sequence 54632 is already on disk as file /u01/arch/prim101_1_54632_859260340.arc
archived log for thread 1 with sequence 54633 is already on disk as file /u01/arch/prim101_1_54633_859260340.arc
archived log for thread 1 with sequence 54634 is already on disk as file /u01/arch/prim101_1_54634_859260340.arc
archived log for thread 1 with sequence 54635 is already on disk as file /u01/arch/prim101_1_54635_859260340.arc
archived log for thread 1 with sequence 54636 is already on disk as file /u01/arch/prim101_1_54636_859260340.arc
archived log for thread 1 with sequence 54637 is already on disk as file /u01/arch/prim101_1_54637_859260340.arc
archived log for thread 1 with sequence 54638 is already on disk as file /u01/arch/prim101_1_54638_859260340.arc
archived log for thread 1 with sequence 54639 is already on disk as file /u01/arch/prim101_1_54639_859260340.arc
archived log for thread 1 with sequence 54640 is already on disk as file /u01/arch/prim101_1_54640_859260340.arc
media recovery complete, elapsed time: 00:00:09
Finished flashback at 26-JUN-17
But the reinstate fails:
6/26/2017 09:15:34
Data Guard notifying Oracle Clusterware of database role change
SQL Execution error=604, sql=[FLASHBACK DATABASE TO SCN 513252698542]. See error stack below.
ORA-00604: error occurred at recursive SQL level 1
ORA-38754: FLASHBACK DATABASE not started; required redo log is not available
ORA-38762: redo logs needed for SCN 513252696530 to SCN 513252698542
ORA-38761: redo log sequence 54641 in thread 1, incarna
Physical RSM: Reinstatement failed. Flashback database to SCN 513252698542 fails. If there is insufficient flashback log to flashback this database, reinstatement will never succeed. You will have to do a full physical standby re-instantiation of this database.
Database Resource SetState Error (3)
How come I can flashback using RMAN but not use reinstate? I guess Im missing sequence 54641, but where could that log be, its not in the new primary. Or how can I find it?
Regards
TheLonelyDBA