During a switchover the message 'switchover will wait 900 seconds' is seen in the alert.log
(Doc ID 1332403.1)
Last updated on MARCH 05, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.1.0.7 [Release 10.2 to 11.1]Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
Goal
During a switchover the following messages are written to the alert log of the standby site where managed recovery is cancelled as a part of performing the switchover operation.
Thu Jun 23 11:24:08 2011
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL
MRP0: Background Media Recovery cancelled with status 16037
Thu Jun 23 11:24:09 2011
Errors in file /<path>/bdump/<oracle_sid>_mrp0_6011.trc:
ORA-16037: user requested cancel of managed recovery operation
Managed Standby Recovery not using Real Time Apply
Recovery interrupted!
Thu Jun 23 11:24:12 2011
Errors in file /<path>/bdump/<oracle_sid>_mrp0_6011.trc:
ORA-16037: user requested cancel of managed recovery operation
Thu Jun 23 11:24:12 2011
MRP0: Background Media Recovery process shutdown (plb102)
Thu Jun 23 11:24:13 2011
Managed Standby Recovery Canceled (plb102)
Thu Jun 23 11:24:13 2011
Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL
Thu Jun 23 11:24:13 2011
ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY WAIT WITH SESSION SHUTDOWN
Thu Jun 23 11:24:13 2011
ALTER DATABASE SWITCHOVER TO PRIMARY (plb102)
If media recovery active, switchover will wait 900 seconds
SwitchOver after complete recovery through change 2019896
Online log +DATA1/<db_unique_name>/onlinelog/group_1.267.730293491: Thread 1 Group 1 was previously cleared
Online log +FRA1/<db_unique_name>/onlinelog/group_1.302.730293493: Thread 1 Group 1 was previously cleared
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL
MRP0: Background Media Recovery cancelled with status 16037
Thu Jun 23 11:24:09 2011
Errors in file /<path>/bdump/<oracle_sid>_mrp0_6011.trc:
ORA-16037: user requested cancel of managed recovery operation
Managed Standby Recovery not using Real Time Apply
Recovery interrupted!
Thu Jun 23 11:24:12 2011
Errors in file /<path>/bdump/<oracle_sid>_mrp0_6011.trc:
ORA-16037: user requested cancel of managed recovery operation
Thu Jun 23 11:24:12 2011
MRP0: Background Media Recovery process shutdown (plb102)
Thu Jun 23 11:24:13 2011
Managed Standby Recovery Canceled (plb102)
Thu Jun 23 11:24:13 2011
Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL
Thu Jun 23 11:24:13 2011
ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY WAIT WITH SESSION SHUTDOWN
Thu Jun 23 11:24:13 2011
ALTER DATABASE SWITCHOVER TO PRIMARY (plb102)
If media recovery active, switchover will wait 900 seconds
SwitchOver after complete recovery through change 2019896
Online log +DATA1/<db_unique_name>/onlinelog/group_1.267.730293491: Thread 1 Group 1 was previously cleared
Online log +FRA1/<db_unique_name>/onlinelog/group_1.302.730293493: Thread 1 Group 1 was previously cleared
Is the message 'If media recovery active, switchover will wait 900 seconds' something to be concerned about?
Solution
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
| Goal |
| Solution |
| References |