My Oracle Support Banner

Failover failed with ORA-16131 (Doc ID 2040995.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.

Symptoms

Physical standby failover fails with the following error:

Tue Jul 07 22:44:55 2015
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH FORCE
Attempt to do a Terminal Recovery (orcl)
Media Recovery Start: Managed Standby Recovery (orcl)
 started logmerger process
Tue Jul 07 22:44:56 2015
Managed Standby Recovery not using Real Time Apply
Parallel Media Recovery started with 24 slaves
Begin: Standby Redo Logfile archival
End: Standby Redo Logfile archival
Terminal Recovery timestamp is '07/07/2015 22:44:57'
Cannot recover datafiles with current logs containing different
Terminal Recovery Stamps (TRSTAMP).  The datafiles must be
restored from backups to clear the TRSTAMP and then recovered
up to the current log.
Log file TRSTAMP:  Count: 884472297l
Datafile #1:  Count: 819047454l
Terminal recovery failed with error 16131
Recovery interrupted!
Media Recovery failed with error 16131
Errors in file /dumps/diag/rdbms/orcl_a/orcl/trace/orcl_pr00_21341.trc:
ORA-00283: recovery session canceled due to errors
ORA-16131: An error occurred during a Terminal Recovery of the standby.
ORA-283 signalled during: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH FORCE...
Tue Jul 07 22:44:57 2015
Failover failed with ORA-16798.

There was a failover happened previously for this database. File header dump shows it happened two years ago:

 name #220: /fs/databases/orcl/system-01.dbf
Terminal Recovery Stamp  06/25/2013 17:10:54
 name #219: /fs/databases/orcl/undo_t1-01.dbf
Terminal Recovery Stamp  06/25/2013 17:10:54
 name #218: /fs/databases/orcl/sysaux-01.dbf
Terminal Recovery Stamp  06/25/2013 17:10:54
......

  

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.