11.2.0.2 Physical Standby Fails To Open Read Only Requesting Further Recovery

(Doc ID 1312376.1)

Last updated on JANUARY 27, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.2.0.2 [Release 10.1 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 26-Sep-2012***
***Checked for relevance on 06-Aug-2014***
*** Checked for relevance '25-Nov-2015' ***

Symptoms

Dataguard configuration - physical standby database

In this case 11.2.0.2, this can happen on each other release.

Opening standby database read only (using active dataguard) fails with:

Fri Apr 08 13:02:44 2011
alter database open read only
Beginning standby crash recovery.
Standby crash recovery aborted due to error 275.
Errors in file /oracle/diag/rdbms/caresdg/caresdg/trace/caresdg_ora_7488.trc:
ORA-00275: media recovery has already been started
Completed standby crash recovery.
Errors in file /oracle/diag/rdbms/caresdg/caresdg/trace/caresdg_ora_7488.trc:
ORA-10458: standby database requires recovery
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/oradata/dbdata2/SYSTEM_FNO_1_jmm63u36.dbf'
ORA-10458 signalled during: alter database open read only...
Fri Apr 08 13:05:00 2011
ALTER DATABASE RECOVER standby database until cancel

Changes

Cust. upgraded the primary database from 10g to 11g. After this he created
a physical standby database.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms